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