Hi all,
for myisam tables we have optimize table that can be cronned to run at
night, but is there something like this for the innodb table type as well?
Franky
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
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
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