Maintenance
Different storage engines will perform different actions when issuing these operations.
Operations
analyze table
generates table statistics.check table
checks for errors in a table.checksum table
generates a checksum for a table which can be used to verify that the data is the same before and after a maintenance operation such as a backup and restore or rollback.optimize table
defragments data files.
repair table
recovers data from corrupted tables.