Different storage engines will perform different actions when issuing these 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.