MySQL: index

from mysql 5.6 on, create new index on mysql table will not cause the table be locked for r/w.

--DATA

And create a index with one field to 30 million records uses 1 min 43 sec.