Hi All, We have upgraded our percona servers from 5.5.36-34.2 to 5.6.32-78 version. We use this database for creating caches daily, We truncate the table drop the secondary indexes on the table and load data into them and recreate those secondary indexes back. There is one tables whose size is ar…

Create Index is Dead slow after upgrading percona from 5.5.36-34.2 to 5.6.32-78

Suhendro June 6, 2018, 2:45pm 2

Any solution for this issue? I use MySQL 5.7 and index creation is awful slow. Thanks

Topic		Replies	Views
slow create table on Percona Server 5.5 and 5.6 Other MySQL® Questions	5	1013	February 24, 2015
Percona 8 - LOAD DATA 600+ times slower after creating specific secondary index Percona Server for MySQL 8.0	7	567	February 4, 2024
Slow Create Temp Table/ CREATE INDEX on temp table Percona Server for MySQL 5.7	3	1126	October 27, 2020
Percona-server SLOWER in my benchmarks? Other MySQL® Questions	3	571	November 20, 2010
Percona Server 5.6 vs 5.5 - what about performance of MyISAM tables ? Percona Server for MySQL 5.6	1	1221	June 10, 2014