Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected]m for any comments or concerns.

Migrating from MyISAM to INNODB while minimizing downtime

untenableuntenable EntrantCurrent User Role Beginner
I need to migrate two 5GB MyISAM tables to Innodb tables. What's the best way to do this while minimizing downtime?

It takes several hours even on a quad proc 8GB RAM box to load a 5GB MyISAM mysqldump as a INNODB tables.

And this is with several optimizations including these:

-Increasing the innodb_buffer_pool_size to 4GB
-SET UNIQUE_CHECKS=0


My questions:

1. What other performance optimizations can I perform?
2. How do I do this to minimize downtime. What I was thinking is that I'd take a mysqldump, copy it to another server and import the database tables as Innodb tables.

Once the import is complete, I would do a diff between the previous mysqldump and the current live database, copy and import the diff into the other DB Server.

Is this possible?
I was looking online and could not find a way to do this "diff + import only the diff" thing.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.