Rebuild index in MySQL | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
+ 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 Réponse
+ 2
or you can use replication
8th Dec 2016, 10:04 PM
nsfantom
nsfantom - avatar