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 19, 2011 07:57AM

Sorry, the way to shrink ibdata1 is painful and time consuming:

0. stop writing to the tables
1. mysqldump all the tables
2. stop mysqld
3. remove ibdata1
4. change the setting (my.cnf or my.ini) to something small, like 30M;autoextend
5. start mysqld; this will rebuild ibdata1 (at 30M)
6. reload all the tables

If you are currently doing mysqldumps, then there is no need to capture the .ibd files. Note, however, that stored procedures, view, triggers, etc may not be included in the dumps.

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


Subject
Views
Written By
Posted
All Innodb tables using seperate ibd, but ibdata1 still being modified?
4618
Kyle Bresin
August 12, 2011 01:33PM
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
1825
Rick James
August 13, 2011 02:50PM
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
1595
Kyle Bresin
August 18, 2011 07:53AM
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
1979
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.