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.

42 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 |

aintagg said...

tn pas cher 2014
http://www.gaypodcast.fr/tn-pas-chere-livraison-gratuite-chaussure-nike-tn-requin-pas-cher.html

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

Emily Walker said...

Thank you very much! The post is really helpful to me super smash flash 2 | happy wheels | car games | kids games | games for girls | cool math games | free online games | football games | unblocked games

lolyta said...

Nice blog and article, thanks for sharing. However want to statement on few common issues, The website taste is great, the articles is in point of fact excellent. Vimax IZON Canada Original | Obat Pembesar Penis
vimax izon

vimax izon canada

vimax izon asli

harga vimax izon

jual vimax izon

vimax

tranduyphong said...

after hours of work tired, you need entertainment. Refer to our website. hope you get the most comfortable
Kizi 1000

tranduyphong said...

after hours of work tired, you need entertainment. Refer to our website. hope you get the most comfortable
Kizi 1000

Hảo Lê said...

Jeg takker Dem for den interesse, som De og de organer, De repræsenterer, Navarra-regionens kommuner i Valle de Lónguida, Aoiz, Valle de Artze, Oroz-Beztelu, Junta General del Valle de Aezcoa samt Coordinadora de Itoiz, har vist i bevaringen og beskyttelsen af miljøet.
Friv 2017
Gry Friv
Five Nights at Freddy's
Juegos De Five Nights at Freddy's
Freddy


Ich danke Ihnen für das Interesse, das Sie und die von Ihnen vertretenen Gremien, die Gebietskörperschaften von Valle de Lónguida, Aoiz, Valle de Artze und Oroz-Beztelu
Friv 3
Friv 4
Friv 5
Kizi2
Yoob

slamet siswanto said...

Film Semi
Movies
Hot Film
Film Terbaru 2016
Film Kartun
Drama korea
Film Indo

Film Semi
Film Kartun
Drama korea
Film Indo
Film Ip Man3
Film Movies
Film India
Film Hot

Zhemwel Elanor said...

Nice Post Gan, Visit Juga Ya..

Blog Saya
Download Avatar Korra Sub Indo
Bobol WinRar Yang BerPassword
Aktivasi Windows 8
Komponen Yang Terdapat Dalam Komputer

Games Mincecraft said...

great post. i like it. feeling great when reading your post
minecraft games

Linda Rose said...

This is a great article. It gave me a lot of useful information. thank you very much.
Geometry Dash 2.0 | Papa Louie 2|Trollface Quest 2|Dr Driving| Sonic Dash |Square Quick |

Mincecraft Games said...

Great! Thanks for sharing the information. That is very helpful for increasing my knowledge in this field.
- minecraft games
- happy wheels
- happy wheels
- tetris
- brain games
- puzzle games
- agario
- abcya
- fnaf 4

Mai Doan said...

This topic is interesting. This information is very useful to me. I hope there will be many articles or like this article. Thank you for sharing


Speaking of football games can not fail to mention head soccer . head soccer is a great game that every player knows games. Not only that Big Head Soccer or Big Head Football games also are a lot of lovers. Please entertainment with Big Head Soccer Big Head Football offline
Tiny Tanks other Tiny Planes are appealing for your child. In Tiny Planes you can play Run 3 Unblocked. Milky quite interesting if you explore all Run 3 Unblocked . The same play with Car Racing Games , Donkey Kong Unblocked and are also Super Mario Unblocked offline

Online Game said...

You need to kill time, you'd have time to look these kids active. Refer to our website. Hope you get the most comfort.
Thanks for sharing !
Friv 5
Kizi 1
Yepi 3

Hảo Lê said...


wir danken euch für das bisherige Teilnehmen lassen, möchten aber den Rundbrief nicht mehr erhalten" oder
five nights at freddy's
friv games
happy wheels
friv games
jogos friv
Wir danken Ihnen, dass Sie diese Hoffnung mit uns teilen und diesen Schritt auf dem Pilgerweg des Vertrauens? mit uns gegangen sind.

Danke für das Teilen mit mir einige Ihrer Ideen betreffend sind die Möglichkeit des Verminderns unserer gegenwärtigen Arbeitslosigkeit
juegos friv
juegos fnaf
juegos friv
yoob games
yoob

Hảo Lê said...


wir danken euch für das bisherige Teilnehmen lassen, möchten aber den Rundbrief nicht mehr erhalten" oder
five nights at freddy's
friv games
happy wheels
friv games
jogos friv
Wir danken Ihnen, dass Sie diese Hoffnung mit uns teilen und diesen Schritt auf dem Pilgerweg des Vertrauens? mit uns gegangen sind.

Danke für das Teilen mit mir einige Ihrer Ideen betreffend sind die Möglichkeit des Verminderns unserer gegenwärtigen Arbeitslosigkeit
juegos friv
juegos fnaf
juegos friv
yoob games
yoob

حسام داود said...

level تسليك مجارى بالرياض
افضل شركة تنظيف بالرياض
تنظيف شقق بالرياض
تنظيف منازل بالرياض
شركة غسيل خزنات بالرياض
افضل شركة مكافحة حشرات بالرياض
رش مبيدات بالرياض
شركة تخزين عفش بالرياض
تنظيف مجالس بالرياض
تنظيف فلل بالرياض

Hảo Lê said...

Danke für das Teilen mit mir einige Ihrer Ideen betreffend sind die Möglichkeit des Verminderns unserer gegenwärtigen Arbeitslosigkeit
five nights at freddy's 6
friv 2017
friv frozen
friv happy wheels
jogos friv 2017
Danke für die Mitteilung der Information an Ihre Familie und Freunde.

wir danken euch für das bisherige Teilnehmen lassen, möchten aber den Rundbrief nicht mehr erhalten" oder
juegos de fnaf
juegos friv 100
juegos friv 4
yoob 10
yoob 4
Wir danken Ihnen, dass Sie diese Hoffnung mit uns teilen und diesen Schritt auf dem Pilgerweg des Vertrauens? mit uns gegangen sind.

Games Friv said...

When you're tired, you want to relax after a stressful working hours, you need to have time to take care of the kids active.
Please visit our website and play exciting flash games.Thanks you for sharing!
Friv 4

Obat Perangsang Wanita said...

Danke für das Teilen mit mir einige Ihrer Ideen betreffend sind die Möglichkeit des Verminderns unserer gegenwärtigen Arbeitslosigkeit

Obat Perangsang Wanita
Jual Obat Perangsang
Obat Perangsang
Obat Kuat
Obat Pembesar Penis
Viagra Asli
Klg Asli

Jual Obat Bius Obat Tidur said...

wir danken euch für das bisherige Teilnehmen lassen, möchten aber den Rundbrief nicht mehr erhalten" oder

Obat Bius
Jual Obat Bius
Obat Bius Cair
Obat Bius Hirup
Obat Bius Wanita
Obat Bius Asli
Obat Bius Semprot
Obat Tidur
Jual Obat Tidur

Games Friv said...

When you're tired, you want to relax after a stressful working hours, you need to have time to take care of the kids active.
Please visit our website and play exciting flash games.Thanks you for sharing!
Friv 4

Kizi200 Games said...

Play the Best Free Games! We've picked out the racing games, cooking games, candy crush, games shooting, fashion games, ...
Thanks for sharing !
Kizi 200
Friv 1
Y88
Y9

Mai Doan said...

This topic is interesting. This information is very useful to me. I hope there will be many articles or like this article. Thank you for sharing
head soccer unblocked is the main game in our website. To head soccer soccer heads will be played the famous game about Big Head Soccer . Big Head Football or big head basketball games as well as our favorite

Minh Vương said...

chữa thoát vị đĩa đệm
chữa thoát vị đĩa đệm ở Hà Nội
triệu chứng thoát vị đĩa đệm
nguyên nhân thoát vị đĩa đệm

Online Friv said...

You'd have time to look these kids active. Please visit our website and let us play the games interesting.
Thanks you for sharing !
Friv 100
Friv 8
Friv 2

lee anh nuooi said...

invites you to play games for a chance to win cars Corolla Altis car

Kizi 100
Games2Win
Kizi 5
Friv Games

Online Friv said...

You want to relax after a stressful working hours. Refer to our website. Hope you get the most comfort.
Thanks for sharing !
GirlsGoGames
Kizi 100
Frvi

Gamesclub Online said...

You need to have time to take care of the kids active. Please visit our website and play exciting flash games.Thanks you for sharing!
Twizl | friv2018 | y5games | friv games | ozov games

Post a Comment