Re: /var/lib/mysql/ibdata1 growing out of control
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
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.