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

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.


Unknown said...
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

Unknown said...

Thanks Yoshinori to report it! - logged a bug: - was able to reproduce, and get first surprises ;-)
should be fixed, let's see..


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:

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.

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

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.

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 |

aintagg said...

tn pas cher 2014

aintagg said...

tn pas cher 2014,tn requin pas cher

Yoga Fahri said...

nice info
Obat Bius
Jual Obat Bius
Aneka Obat Bius
Obat Perangsang Wanita
Obat Pembesar Penis
Alat Bantu Sex Wanita
Alat Bantu Sex Pria

Online Game said...

you'd have time to look these kids active. Please visit our website and let us play the game interesting.
Thanks for sharing !
Friv 10
Kizi 10
Yepi 2

Naveen Chaudhary said...

valentine wish
valentine quotes for girlfriend
valentine day wishes for girlfriend
valentine day poems for girlfriend

Post a Comment