# Percona Server 5.6 vs 5.5 - what about performance of MyISAM tables ?

**URL:** <https://forums.percona.com/t/percona-server-5-6-vs-5-5-what-about-performance-of-myisam-tables/3305>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [February 27, 2014, 7:16am UTC](https://forums.percona.com/t/percona-server-5-6-vs-5-5-what-about-performance-of-myisam-tables/3305 "2014-02-27T07:16:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sarge](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@Sarge](https://forums.percona.com/u/Sarge)\
**Post date:** [February 27, 2014, 7:16am UTC](https://forums.percona.com/t/percona-server-5-6-vs-5-5-what-about-performance-of-myisam-tables/3305/1 "2014-02-27T07:16:44Z")

</div>

Hello to everyone !

There are a lot of discussions dedicated to InnoDB performance - but what about performance on MyISAM tables ?  
I have many of them to store the data for fast INSERT and SELECT, without complex queries.

So, before upgrading from Percona Server 5.5 to 5.6 - I would be obliged for the opinions from community/developers about 5.6 performance on MyISAM tables.  
Are there any serious improvements, better/faster performing of the operations, may be the references to benchmarks, may be the bugs known ?

Thanks in advance to everyone for a comment !  
Best regards  
Serge

---

<div class="post-metadata">

**Author:** ![wydlakson](https://avatars.discourse-cdn.com/v4/letter/w/57b2e6/32.png) [@wydlakson](https://forums.percona.com/u/wydlakson)\
**Post date:** [June 10, 2014, 6:10am UTC](https://forums.percona.com/t/percona-server-5-6-vs-5-5-what-about-performance-of-myisam-tables/3305/2 "2014-06-10T06:10:12Z")

</div>

Hello,

my experience seems problem with upgrade from 5.5 to 5.6 on MyISAM tables. After upgrade DB has lower performance when top connections of day. I have two same slave databases (v5.5 and v5.6). Ratio working is 3:1 (3 at v5.5). Percona 5.5 is ok without query in slow\_query log (limit is 2s). Percona 5.6 has full slow\_query (time\_query ~ 20s). Configuration was same. After problems i try insert and change some variables:

+performance\_schema = OFF  
+thread\_handling = pool-of-threads

But without change.

Any ideas? Thanks for all reply.

Sorry for my bad english.

Petr
