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

**URL:** <https://forums.percona.com/t/create-index-is-dead-slow-after-upgrading-percona-from-5-5-36-34-2-to-5-6-32-78/5190>\
**Category:** Other MySQL® Questions\
**Created:** [November 5, 2016, 7:11am UTC](https://forums.percona.com/t/create-index-is-dead-slow-after-upgrading-percona-from-5-5-36-34-2-to-5-6-32-78/5190 "2016-11-05T07:11:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jayakarthik](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jayakarthik](https://forums.percona.com/u/jayakarthik)\
**Post date:** [November 5, 2016, 7:11am UTC](https://forums.percona.com/t/create-index-is-dead-slow-after-upgrading-percona-from-5-5-36-34-2-to-5-6-32-78/5190/1 "2016-11-05T07:11:19Z")

</div>

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 around 66GB and two secondary indexes of total size 52 GB.  
In 5.5 version create index used to take about 1.5 hours but in 5.6 it is taking around 14 hours.  
Ram on the server is 140GB and innodb\_buffer\_pool is 100GB.  
I already disabled the performance schema thinking that it may be an overhead on memory.

Still the index creation is dead slow, any suggestions would be helpful to improve the index creation speed…

---

<div class="post-metadata">

**Author:** ![Suhendro](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@Suhendro](https://forums.percona.com/u/Suhendro)\
**Post date:** [June 6, 2018, 2:45pm UTC](https://forums.percona.com/t/create-index-is-dead-slow-after-upgrading-percona-from-5-5-36-34-2-to-5-6-32-78/5190/2 "2018-06-06T14:45:20Z")

</div>

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