MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

ibdata1 file still growing even with innodb_file_per_table option
Posted by: Gharieb Abdel-Mawla
Date: December 14, 2009 03:18AM

Hi,
InnoDB data file (ibdata1) was growing fast and it reached more than 35 GB, so that I tried to separate this file into ibdata file per table and I did these steps:
1-Took backup from all databases.
2-Uninstalled MySQL and re-installed fresh one.
3-Configured InnoDB option innodb_file_per_table to be enabled.
4-Restored all databases.

and then ibdata file was created indeed to every table but after 4 days ibdata1 file(the shared one) was about 15 GB.that means ibdata1 file still growing even with innodb_file_per_table option !!
So how can I prevent or reduce ibdata1 file growing ?? and why this file still growing rapidly after enabling this option??

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ibdata1 file still growing even with innodb_file_per_table option
4802
Gharieb Abdel-Mawla
December 14, 2009 03:18AM
Re: ibdata1 file still growing even with innodb_file_per_table option
2191
Brian Papantonio
December 14, 2009 08:56PM
Re: ibdata1 file still growing even with innodb_file_per_table option
1663
Andres Bernasconi
January 26, 2010 10:48PM


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.