Mysql - tablename.ibd file is huge in size

0 votes

2 answers

400 views

                          I'm using MySQL 5.6 and innodb file per table has been enabled.

I noticed that one file named as tablename.ibd is 211GB, then query the information schema there it's showing 21GB.

I have done a huge delete operation on this table. And daily archiving some old data.

Is this because of that?
Optimize table - command is the only way to reclaim the space?

Asked by TheDataGuy (1986 rep)

Sep 4, 2019, 05:56 PM
Last activity: Jul 3, 2025, 05:05 AM

Mysql - tablename.ibd file is huge in size

Related Questions