Maintaining a table

During its lifetime, a table repeatedly gets modified and is, therefore, continually growing and shrinking. Outages may occur on the server, leaving some tables in a damaged state.

Using the Operations page, we can perform various operations, which are listed next. However, not every operation is available for every storage engine.

• Check table: Scans all rows to verify that deleted links are correct. A checksum is also calculated to verify the integrity of the keys. If everything is all right, we will obtain a message stating OK or Table is already up to date; if any other message shows up, it's time to repair this table (refer to the Repair table bullet point).

• Analyze table: Analyzes and stores the key distribution; this will be used on subsequent JOIN operations to determine the order in which the tables should be joined. This operation should be periodically done (in case data has changed in the table) to improve JOIN efficiency.

• Repair table: Repairs any corrupted data...