MySQL Forums
Forum List  »  InnoDB

Purging Innodb Data
Posted by: development
Date: May 10, 2005 04:12AM

Hello all,

I m using innodb engine newly on my mysql4.1.11 server. we are just evaluating it against performace and storage of MyISAM. all the tables i've converted in innodb type. Our total database size is around 14GB. After conversion when i've tried to optimize one big table it is causing cont increasing the size of ibdata file size, i've got the reason that first it is copying in temp table. but after optimization the ibdata size is not decreased.

how i can remove the temp data from ibdata files or how can i purge the unrequired rows from the ibdata file. same way at the time of deletion of data, the ibdata file size is not reduced. !!

Thank you very much.


Options: ReplyQuote

Written By
Purging Innodb Data
May 10, 2005 04:12AM
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.