Re: /var/lib/mysql/ibdata1 growing out of control
Is there an option that does not just keep growing a file endlessly?
If there's any chance that using MyISAM might not be compatible, I don't want to chance it... since the people who wrote the app that uses this database can't answer the question, I do not want to introduce any more variables.
What is the correct way to get rid of this huge file? And how can I tell MySQL to not do whatever it's doing that keeps it growing?
Right now, my best guess is to export the databases, stop mysqld, delete the ibdata1 file, start mysqld, and import the databases. Will that work? Or will it start throwing a bunch of errors about something vital it can't find any more? Is my guess correct, or am I missing something?
Subject
Written By
Posted
Re: /var/lib/mysql/ibdata1 growing out of control
July 20, 2009 03:00PM
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.