The amount of data in a table is 1000W, so when you look at the hard disk space that the table occupies, the data itself is 300M and the index is 200M
This time, delete 500W data, this time the data itself 150M, and the index is still around 200M
When you delete data, MySQL does not reclaim the occupied storage space of the deleted data, as well as the index bits.
Instead of waiting for new data to compensate for the vacancy, there is a lack of it, and if there is no data to fill the vacancy at 1:30, it would be a waste of resources.
So for the comparison of the frequency of the table, to regularly carry out optimize, one months once, see the actual situation and decided.
Optimize table xxxxxx;
OPTIMIZE table works only on MyISAM, BDB, and InnoDB tables.
Note that MySQL locks the table during the Optimize table run.
Optimize table is important when it comes to optimizing MySQL