MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
Posted by: Rick James
Date: August 13, 2011 02:50PM

ibdata1 is _vital_ to the operation of InnoDB, even when you have innodb_file_per_table = 1. If you delete ibdata1, you will lose access to all your InnoDB tables.

ibdata1 needs to be of modest size, say, 50MB. It is used for a variety of things, possibly including things needed for transactions that are in progress.

If you have a huge ibdata1, and need to shrink it, the process is lengthy: Dump (via mysqldump or other) all the tables, delete ibdata1, reload all the tables.

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


Subject
Views
Written By
Posted
All Innodb tables using seperate ibd, but ibdata1 still being modified?
4353
Kyle Bresin
August 12, 2011 01:33PM
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
1725
Rick James
August 13, 2011 02:50PM
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
1504
Kyle Bresin
August 18, 2011 07:53AM
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
1880
Rick James
August 19, 2011 07:57AM


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.