Recently, the great Heikki said that the following directive should also
defragment your InnoDB tables:
ALTER TABLE table_name TYPE=InnoDB;
How was it put...ah yes, a "table no-op".
Regards,
Chris
On Fri, 2003-09-19 at 01:32, Gustavo A. Baratto wrote:
> from the manual:
> -
> 7.5.12.3
from the manual:
-
7.5.12.3 Defragmenting a Table
If there are random insertions or deletions in the indexes of a table,
the indexes may become fragmented. By fragmentation we mean that the
physical ordering of the index pages on the disk is not close to the
alphabetical ordering of the
from the manual:
-
7.5.12.3 Defragmenting a Table
If there are random insertions or deletions in the indexes of a table,
the indexes may become fragmented. By fragmentation we mean that the
physical ordering of the index pages on the disk is not close to the
alphabetical ordering of the
