Mysql under the Optimization table and Repair Table command usage instructions (REPAIR table and optimize table) _mysql

Copy Code code as follows:

REPAIR table ' table_name ' repair form
OPTIMIZE table ' table_name ' optimization tables

The REPAIR table is used to repair damaged tables.
The OPTIMIZE table is used to reclaim unused database space, and when data rows on a table are deleted, the disk space occupied is not immediately reclaimed, the space is reclaimed after the OPTIMIZE Table command is used, and the data rows on the disk are recycled (note: on disk, Rather than a database.

Most of the time, you do not need to run optimize table, you can only run it for those specific tables after you have deleted the data rows in bulk or periodically (once a week or once a month) to perform a data table optimization operation.