Table Diagnostics

Use Tools -> Table Diagnostics (Ctrl+Alt+T) to perform various Table Diagnostics operations.

Analyze

The Analyze Tables Wizard allows you to analyze and store the key distribution for the table. During the analysis the table is locked with a read lock. Currently MySQL supports analyzing only for MyISAM tables and transaction-safe type tables. MySQL uses the stored key distribution to decide in which order tables should be joined when one does a join on something other than a constant.

Check

The Check Tables Wizard allows you to check the database tables on errors. Options that you can use with CHECK operation.

Quick: Don't scan the rows to check for wrong links.

Fast: Only check tables which haven't been closed properly.

Changed: Only check tables which have been changed since last check or haven't been closed properly.

Medium: Scan rows to verify that deleted links are ok. This also calculates a key checksum for the rows and verifies this with a calculated checksum for the keys.

Extended: Do a full key lookup for all keys for each row. This ensures that the table is 100 % consistent, but will take a long time!

Repair

The Repair Option allows you to repair the database tables that may be corrupted. Options that you can use with REPAIR option.

Quick: Do a repair of only the index tree.

Extended: Create the index row by row instead of creating one index at a time with sorting. This may be better than sorting on fixed-length keys if you have long char() keys that compress very good.

Optimize

The Optimize option should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB, or TEXT columns). Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions. You can use optimization to reclaim the unused space and to defragment the data file.