Chapter 30. Table Maintenance

MySQL has the capability to check tables for problems and to repair them should problems be found. Other table-maintenance capabilities include table analysis and optimization. This chapter discusses how to perform these types of maintenance operations. It covers the following exam topics:

• Types of table maintenance operations

• SQL statements for table maintenance

• Client and utility programs for table maintenance

• Repairing InnoDB tables

• Enabling auto-repair for MyISAM tables