Re: Purging Innodb Data
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
Subject
Views
Written By
Posted
4848
May 10, 2005 04:12AM
Re: Purging Innodb Data
2359
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.