Subscribe to our newsletter

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

MySQL Service Center provides you with a feature that reclaims the unused space and defragments the datafile for the tables. This feature should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows. This feature is identical with running myisamchk --quick --check-only-changed --sort-index --analyze for the table. If you wish to be able to perform this operation with your tables, you should create a new task specified as the optimize task in the Add Task Wizard. After the task is added, you can execute it explicitly or set its options to execute it by schedule.

Note: This feature works only for MyISAM and BDB tables.

See also:

• Analyzing tables
• Checking tables
• Repairing tables
• Task Management