Rebuild index in MySQL | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 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.

28th Nov 2016, 2:49 PM
MrFandorin
MrFandorin - avatar
1 Answer
+ 2
or you can use replication
8th Dec 2016, 10:04 PM
nsfantom
nsfantom - avatar