Reputation: 1
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
Reputation: 11
try to optimize the table because you have used delete statement. 'shrink' size of table for optimization.
Upvotes: 0
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