TMyServerControl.OptimizeTable Method

Packs tables deleting unused places from the file at the disk and defragmenting it.

procedure OptimizeTable;

Call the OptimizeTable method to pack tables deleting unused places from the file at the disk and defragmenting it.

It makes sense to call it from time to time when working with a table actively, especially when deleting frequently.

The list of the tables is used from TableNames.

Refer to OPTIMIZE TABLE detailed description at MySQL Reference Manual.