During the lifetime of a table, it repeatedly gets modified, and so grows and shrinks. Outages may occur on the server, leaving some tables in a damaged state.
Using the Operations sub-page, we can perform various operations, but not every operation is available for every table type:
Check table: Scans all rows to verify that deleted links are correct. Also, a checksum is calculated to verify the integrity of the keys; we should get an 'OK' message if everything is all right.
Analyze table: Analyzes and stores the key distribution; this will be used on subsequent
JOINoperations to determine the order in which the tables should be joined.Repair table: Repairs any corrupted data for tables in the
MyISAMandARCHIVEengines. Note that the table might be so corrupted that we cannot even go into Table view for it! In such a case, refer to the Multi-Table Operations section for the procedure to repair it.Optimize table: This is useful when the table contains overheads...