Mysql DB has two files that are extremely large
Budget: $10 – $30 USD
The DB is less than 10MB on the linux server.
Somehow, the mysql DB folder is ridiculously large. After checking file sizes, these two files are huge:
64G project_db/FTS_000000000000068d_00000000000010a0_INDEX_1.ibd
7.3G project_db/FTS_000000000000068d_DELETED.ibd
This link tells something. It seems to be used in fulltext search!
https://dba.stackexchange.com/questions/83353/what-does-fts-file-mean-after-converting-from-myisam-to-innodb
Possible to get rid of this kind of space eater completely from the whole db?
Or at least, need to minimize its space usage.
We need you to help us figure out what the issue is and provide a solution to fix it.
You can access our DB using anydesk or teamviwer. The work has to be done remotely.
Somehow, the mysql DB folder is ridiculously large. After checking file sizes, these two files are huge:
64G project_db/FTS_000000000000068d_00000000000010a0_INDEX_1.ibd
7.3G project_db/FTS_000000000000068d_DELETED.ibd
This link tells something. It seems to be used in fulltext search!
https://dba.stackexchange.com/questions/83353/what-does-fts-file-mean-after-converting-from-myisam-to-innodb
Possible to get rid of this kind of space eater completely from the whole db?
Or at least, need to minimize its space usage.
We need you to help us figure out what the issue is and provide a solution to fix it.
You can access our DB using anydesk or teamviwer. The work has to be done remotely.