Sections
MySQL Maintenance
MySQL Maintenance
Analyze a MySQL table
ANALYZE TABLE MyTable;The analysis allows to update statistics.
On a table that often change, you can plan a regular analyze of tables.
Repair a MySQL table
REPAIR TABLE MyTable;Repair command is used to repair a corrupted table.
This command can be launched after a MySQL server crash.