MySQL Forums
Forum List  »  InnoDB

Re: Purging Innodb Data
Posted by: Bob Bankay
Date: May 10, 2005 02:12PM

Not sure that I understand everything, however the following may help.
(Note: Innodb tables/indices can occupy up to 300% the space of myisam tables.)

After doing the deletes from innodb table then do

alter <innodb-table> type = innodb;

That should release partial pages and compress the table and indices. It seems to improve performance as well.

Bob Bankay

Options: ReplyQuote

Written By
May 10, 2005 04:12AM
Re: Purging Innodb Data
May 10, 2005 02:12PM

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.