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.