CODEWITHSUNDEEP
mysql
clarkk
clarkk

Reputation: 1

mysql table size unchanged after rows deleted

Had a table with about 2,000,000 rows (168 MB)

Deleted 1,800,000 rows but the table size is unchanged!?

Why is that? The rows where deleted about two days ago now, but the table size is still 168 MB?

MySQL 5.6.20 innodb table

Upvotes: 0

Views: 1043

Answers (2)

om_mish99
om_mish99

Reputation: 11

try to optimize the table because you have used delete statement. 'shrink' size of table for optimization.

Upvotes: 0

Sumit Gupta
Sumit Gupta

Reputation: 2192

Did you try to optimize it, to save disk operation the file is not optimize on every delete and hence the "Table" size remain unchanged.

You need to optimize it and sometime Re-index can also reset the table size.

Upvotes: 1

Related Questions