How do I reclaim Space from the INNODB (Ibdata) file?


This is the major issue with the Innodb engine, the bulk delete/truncate operation will deleted the data but it is not reclaiming the space from the Innodb file. There are some techniques to reclaim the space but please make sure you must have the extra space on your servers.

1. Alter Database Set Engine = Innodb

2. Instead of truncate use the DROP statement.

3. Migrate your MySQL databases to another server MySQL server using MySQL dump utility and remove the ibdata file. Further migrate the backup database to orginal server which will makes the ibdata1 file fully de-fragmented.

Advertisements

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s