Wednesday, July 31, 2013

Another reason to disable performance schema

Here is another micro-benchmark to prove that Performance Schema overhead is so serious.

non-persistent connections from remote machine, 100 concurrency, MySQL 5.6.13
performance_schemaconnections per second
039525.62
1(default)26304.53


Benchmark command is the same as what I published long time ago.

I understand almost all applications don't need 20000~30000 connections per second per instance, but latency increase should be considered. It would be better to make performance_schema parameter dynamic, and set 0 as default.

10 comments:

Unknown said...

http://yoshinorimatsunobu.blogspot.com/2012/12/non-persistent-connection-performance.html
MySQL v5.6.9 = 37800 connections per second

Now, MySQL 5.6.13 = 26304 connections per second

Why are there so big differences? Regressions? Or did you disable performance schema before but forgot to mention?

Yoshinori Matsunobu said...

I disabled perf_schema on my previous benchmarks but forgot to mention.

Alex said...

What about doing innodb_stats_update_need_lock = 0
instead?

Unknown said...

Thanks Yoshinori to report it! - logged a bug: http://bugs.mysql.com/bug.php?id=70018 - was able to reproduce, and get first surprises ;-)
should be fixed, let's see..

Rgds,
-Dimitri

wow9gamer said...

atency increase should be considered. It would be better to make performance_schema parameter dynamic, and set 0 as default.Cheap League of Legends Account

Buy LOL Coaching

NTB said...

This is really interesting, You’re a very skilled blogger.
I have joined your feed and stay up for in the hunt for extra of your fantastic post.
Also, I have shared your website in my social networks. Check my site here: http://softmodo.blogspot.com

Uttam Kumar Sarkar said...

The HSC CoWorks is a premium HSC tuition service providing regular face to face tuition, weekend study sessions, HSC Study Bootcamps and Mock Trial Exams to students living in Mosman and Bondi Junction and students living in surrounding areas.
http://www.hsccoworks.com.au./

Михаил Прокопив said...

Hi,
could you share your configs (for full test reproduce)?
I'm always getting "error 1040: Too many connections". :(
Thanks, Michael

Momo Wu said...

I really like your site.and really enjoyed this post.Very helpful,, the style of this article I'm like, really pretty good.http://k2restaurantgroup.com

sadia sulaman said...

Thank you for this blog. That's all i can say..useful information shared... i am very happy to read this article.. thanks for giving us nice info. fantastic walk-through.businessitis |

srirambusinessschool |

probusiness4u |

bpl-business |

bonnerbusinesscenter |

businesstravelstjob |

businessaffaires |

newbusinessmodels |

business-rating |

thebusinessfinder |

Post a Comment