MySQL Forums
Forum List  »  InnoDB

Re: KILL OPTIMIZE TABLE for INNODB
Posted by: Aftab Khan
Date: March 11, 2009 05:22AM

Innodb is ACID compliance, the optimize table simply copy all records into new table
1. If the index pages are not sorted, sort them,
2. If the table's statistics are not up to date (and the repair could not be accomplished by sorting the index), update them.

3.If the table has deleted or split rows, repair the table.

and if you try to kill it when it's running you will not loose any records..

Options: ReplyQuote


Subject
Views
Written By
Posted
5870
March 11, 2009 03:34AM
Re: KILL OPTIMIZE TABLE for INNODB
3665
March 11, 2009 05:22AM


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.