MySQL 5.6 supports Online DDL. Most operations are online, you can see a list at: http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-o...
(The table 14.5 column "Allows Concurrent DML?" is the interesting one.)
Re:MySQL 5.7.6 is out
by IgorPartola on Tuesday March 10, 2015 @11:34AM
(#9178265)
Awesome, thanks. I am actually really happy about this.
I didn't know about a lot of these improvements, and am happy that they are happening. I moved away from MySQL around 2012-2013 because of the above reasons, so glad that things are improving.