MySQL Forums
Forum List  »  General

Re: split rows
Posted by: Dominique Duay
Date: October 28, 2004 09:29AM

Thank you,

But I have still a question: how can you explain that an optimize table on a innodb table is much slower than on a myisam table. No dml operation were done on the table in between the different optimize command.

Optimize should do something only if the following tasks are necessary:
- Repair the table if it has deleted or split rows
- Stort the index pages if not sorted
- Update the statistics

Cheers
Dominique

Options: ReplyQuote


Subject
Written By
Posted
October 28, 2004 08:52AM
October 28, 2004 08:55AM
October 28, 2004 09:12AM
October 28, 2004 09:18AM
Re: split rows
October 28, 2004 09:29AM
October 28, 2004 09:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.