MySQL Tuning table and Repair Table command usage instructions (REPAIR table and optimize tables)

With the long-term use of MySQL, you can fix the table to optimize and reduce disk footprint when optimizing. Easy backup.

REPAIR table is used to repair corrupted tables.
OPTIMIZE table is used to reclaim unused database space, and when the data rows on the 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 re-ordered (note: on disk, Rather than a database).

You do not need to run optimize table most of the time, only 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 only for those specific tables.

MySQL Tuning table and Repair Table command usage instructions (REPAIR table and optimize tables)