+ 1
Rebuild index in MySQL
How to rebuild index on fields in huge table without lock table in production? I use innodb engine. I think that copy to the new table, execute optimize command, rename the old table and finally rename new table on old name.
1 Answer
+ 2
or you can use replication