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.