MyDAC

TMyServerControl.OptimizeTable Method

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

Class

TMyServerControl

Syntax

procedure OptimizeTable;

Remarks

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.

See Also

© 1997-2017 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback