MySQL Forums
Forum List  »  Newbie

Re: /var/lib/mysql/ibdata1 growing out of control
Posted by: Jaime Crespo
Date: July 10, 2009 04:08AM

Innodb table space files do never shrink.
Exporting, deleting and importing the database should work. If space is important for you, you should use the "innodb_file_per_table" option and run regularly the OPTIMIZE command on your tables. Also you could limit buffer options like innodb_log_file_size.
Beware that some of these options can degrade performance or reliability.

--
Jaime Crespo
http://dbahire.com

Options: ReplyQuote


Subject
Written By
Posted
Re: /var/lib/mysql/ibdata1 growing out of control
July 10, 2009 04:08AM


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.