Subscribe to our newsletter

SQL Maestro Group / Products / MySQL / Service Center for MySQL / Documentation

MySQL Service Center provides you with a possibility of using four operations for MySQL server maintenance. The maintenance features performs the following operations with MySQL tables:

• Analyzing tables
  Analyses and stores the key distribution for the table(s). During the analysis, the table is locked with a read lock. This works for MyISAM and BDB tables.
  
  

• Checking tables
  Checks the table(s) for errors. For MyISAM tables the key statistics are updated. This works only for MyISAM and InnoDB tables.
  
  

• Repairing tables
  Repairs the corrupted table(s). This works only for MyISAM tables.
  
  

• Optimizing tables
  Reclaims the unused space and defragments the datafile for the table(s) with variable-length rows. This works for MyISAM and BDB tables.