MySQL Forums
Forum List  »  InnoDB

ibdata1 Size Issue
Posted by: Carmon Colvin
Date: January 09, 2006 05:55AM

I am a newbie to MySQL but I have searched these forums and various other places around the net and can't find the answer to my problem.

I have a small development database in MySQL 5.0 using InnoDB engine. At one time one of my tables had a large amount of data in it. It now has less than 5000 records. My problem is that my /data/ibdata1 file is 2.5 GIG in size!

I have since checked the "one file per table" in MySQL administrator and then "Optimized Table" (under the Maintenance Menu in MySQL administrator. This created what seems to be appropriately sized .IBD files in the database subdirectory ("/data/mydbname/mytable.IBD").

This has increased the hard drive space the database consumed because the /data/ibdata1 file is still 2.5 GIG!

More searching turned up this thread,47517,52798#msg-52798
That states "The only way is to shrink that tablespace is to dump your tables and recreate the whole InnoDB installation."

Does this mean I need to backup my database, uninstall MySQL, reinstall MySQL, import my database?

Is there a better engine choice than innodb that does a better job at disk management?

Options: ReplyQuote

Written By
ibdata1 Size Issue
January 09, 2006 05:55AM
January 11, 2006 08:51AM
January 17, 2006 02:15AM
January 20, 2006 09:54AM

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.