[MySQL] optimize table)

If a table has a large amount of data and is often inserted or deleted, a large amount of space fragments will be generated (mainly because the server does not necessarily release disk space when performing the delete operation on the table, or the impact of data block size ). If these fragments are cleared from time to time, the database performance will speed up and decrease.

Therefore, you should have a scheduled task to perform optimize operations on the table. On the one hand, you can reclaim a large amount of physical space, and on the other hand, you can greatly restore the original performance of the MySQL database.