Tip : mysql table maintenance commands

Following commands can be used for table maintenance using the mysql command line:

1) check table table_name

This command is used to run a check on the specified table to see if it has errors. It works on MyISAM, InnoDB and ARCHIVE tables.

2) repair table table_name

Repair table command can be used for repairing a corrupted table. It can be used for MyISAM and ARCHIVE tables. To execute this command the user must have SELECT and INSERT privileges for the table specified in the command.

3) optimize table table_name

This table is used for optimizing table after you have deleted lots of rows in a table or have made a lot of changes in a table with plenty of variable length field (such as varchar, blob, etc). It defragments the data file and reclaims unused space.