REPAIRTABLE and OPTIMIZETABLE optimize table and repair table _ MySQL

REPAIRTABLE and OPTIMIZETABLE optimize TABLE and REPAIR table repair table 'Table _ name' REPAIR table

Optimize table 'Table _ name' OPTIMIZE table

Repair table is used to REPAIR damaged tables.

Optimize table is used to reclaim idle database space,

When the data rows in the TABLE are deleted, the occupied disk space is not immediately recycled. the space will be recycled after the optimize table command is used, in addition, the data rows on the disk are rearranged (note: it is on the disk rather than the database ).

Optimize table does not need to be run most of the time. you only need to perform a data TABLE optimization operation after batch deletion of data rows, or regularly (once a week or once a month), only for those specific tables.