# Percona DB server 5.6 innodb table loads slow

**URL:** <https://forums.percona.com/t/percona-db-server-5-6-innodb-table-loads-slow/2935>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [September 12, 2013, 3:37pm UTC](https://forums.percona.com/t/percona-db-server-5-6-innodb-table-loads-slow/2935 "2013-09-12T15:37:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![CharlieB](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@CharlieB](https://forums.percona.com/u/CharlieB)\
**Post date:** [September 12, 2013, 3:37pm UTC](https://forums.percona.com/t/percona-db-server-5-6-innodb-table-loads-slow/2935/1 "2013-09-12T15:37:45Z")

</div>

Hello;

I have Percona 5.6.13 installed. I have tried testing some table refresh jobs with both innodb & myisam as the default engines. The load procedure creates shadow tables suffixed with the string ‘\_new’. These tables are then loaded by performing ‘insert into ~ select from ~’ commands, and then renamed. Several test runs have consistently shown that using innodb as the default engine runs almost 3 times longer than those tests with myisam as the default. Also, the same tests with the 5.5.30 version run in roughly the same amount of time as that of the myisam default in 5.6.13. The my.cnf file used is the same for all tests. So the question, is there something different about 5.6.13 that I’m missing?

Thanks

---

<div class="post-metadata">

**Author:** ![laurynas](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/laurynas/32/12_2.png) [@laurynas](https://forums.percona.com/u/laurynas)\
**Post date:** [September 15, 2013, 4:01am UTC](https://forums.percona.com/t/percona-db-server-5-6-innodb-table-loads-slow/2935/2 "2013-09-15T04:01:28Z")

</div>

Hello -

This is indeed odd if you have already ruled out any config changes. Please see if you can reduce this to a repeatable testcase and file a bug on [bugs.percona.com](http://bugs.percona.com)?

Thanks,  
Laurynas

---

<div class="post-metadata">

**Author:** ![\_ck](https://avatars.discourse-cdn.com/v4/letter/_/d6d6ee/32.png) [@\_ck](https://forums.percona.com/u/_ck)\
**Post date:** [September 23, 2013, 9:19am UTC](https://forums.percona.com/t/percona-db-server-5-6-innodb-table-loads-slow/2935/3 "2013-09-23T09:19:56Z")

</div>

@CharlieB I’ve also cloned innodb tables under 5.6.13, to reduce space used and I’ve found it critical to make sure there are no indexes created on the new table until all data is copied. Otherwise it is excruciatingly slow.