MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Why is the ibdata1 file much bigger than all databases?
Posted by: Kathy Mazur Worden
Date: February 26, 2008 03:14PM

The ibdata1 file doesn't automatically reduce in size. To reduce it manually you'll need to:
1. backup the db
2. either drop the db or convert each table to MyISAM
3. stop the server
4. delete ibdata1 and the innodb log files
5. restart the server to automatically re-create a clean ibdata1 file and innodb logs
6. either restore the backup or convert the tables back to innodb

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


Subject
Views
Written By
Posted
Why is the ibdata1 file much bigger than all databases?
3874
Julia Range
February 26, 2008 10:00AM
Re: Why is the ibdata1 file much bigger than all databases?
6288
Kathy Mazur Worden
February 26, 2008 03:14PM
Re: Why is the ibdata1 file much bigger than all databases?
2892
Julia Range
February 27, 2008 02:00AM
Re: Why is the ibdata1 file much bigger than all databases?
2943
KimSeong Loh
February 27, 2008 07:44PM
Re: Why is the ibdata1 file much bigger than all databases?
2650
Per Hallström
February 28, 2008 02:49PM


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.