Improved InnoDB fast index creation - MySQL Performance Blog
By temporarily dropping secondary indexes from the new table before copying the data, and then recreating them later, ALTER TABLE can take advantage of the fast index creation feature even when it has to copy the entire table.
mysql
performance
database