Online Documentation for SQL Manager for MySQL

Optimize Tables


Optimize Table Wizard 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 (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions. You can use optimization to reclaim the unused space and to defragment the data file.

 

OPTIMIZE TABLE works as follows:

  • if the table has deleted or split rows, repairs the table;
  • if the index pages are not sorted, sorts them;
  • if the statistics are not up to date (and the repair could not be done by sorting the index), updates them.

 

In MySQL 6.x.x the service works only for tables of MyISAM, InnoDB, and ARCHIVE storage engines.

 

To run the wizard, select the Services | iconOptimizeTables Optimize Tables... main menu item.

 

menuServices_OptimizeTables

 

 

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.