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.

94 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

Mourad Abdelmorite said...

Ilike this girls games مرحبا بكم في موقع ربي يختص في العاب طبخ وايضا العاب بنات تلبيس اسمه هو gamesgirlscoat

raja obat perkasa said...

with the information in here could make me greater insight, nice post.
alat bantu sex pria
alat bantu sex wanita
pembesar panjang penis permanen
obat perangsang wanita
obat kuat tahan lama
aneka kondom silikon
aneka kosmetik

Imran Hashmi said...

Amazing web blog it is.

Microsoft Office 2016
Jetbrains Webstorm 11
Adobe Creative Cloud
Corel Videostudio
Comodo Internet Security
Autocad 2016

chrisrinadi colonadu said...

Thank for share. I need it

Kizi
Ebog
Friv 2

Mai nguyễn said...

Thank you for such a sweet tutorial - all this time later, I've found it and love the end result. I appreciate the time you spent sharing your skills.
Run 3 | Run 2 | Stick Run 2 | run 3

toko sange said...

Thank you for such a sweet tutorial
Obat Perangsang Wanita Potenzol Cair
Obat Kuat Pasutri

وليد جلال said...

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

angelina jolie said...

I’m glad you enjoyed it. Those are great habits! Thank you for sharing.
Y8Y8Y8

Trần Mi said...

How often do you play games on free time or after hours of work stress? I usually come to the game as a way to balance life is full of pressure. And I would recommend to everyone that I loved the game
strike force heroes 2, strike force heroes 2 game, strike force heroes 2

Trần Mi said...

I used to play games after long day of work tired or bored. And I would recommend to everyone a very interesting game and attractive for both color and sound
run 2 , run 2 game , run 2 unblocked

Trần Mi said...

Busy life circumstances than the current world history. Must try to earn money to support themselves, their families and pay for living. But not so that you neglect your own health, but more must cherish it.
geometry dash , geometry dash game , geometry dash 2.0

huong duong said...

Whenever sadness, lost love or feel ugly, or no reason, just because today has paid or surfing facebook show this afternoon swatch beautiful son, so a girl can buy right about one lipstick each
slither.io l slitherio l slither io l slither l baixar slither.io

cho chac said...

I think there are many people like and visit it regularly, including me. I hope people visit my website.
Run 3
Run 3
Slither io

Như Quỳnh said...

Your article very well and good, bringing inspiration to many. I hope people visit my website.
Minecraft 4

Ms Linh said...

I enjoyed over read your blog post. Your blog have nice information, I hope people visit my website.
Friv 4
Kizi 100
Kizi 200

Ms Linh said...

I actually appreciate your own position and I will be sure to come back here. I hope people visit my website.
Juegos Friv 5
Friv 4
Y8

Mariani Lindaso said...

I like what you do. Thanks
Happy wheels
Twizl
dress up games
Friv 200
Kizi 10
funbrain

Malia Obama said...

Thanks for the sharing of such information we will pass it on to our readers.
Friv 2
Friv 4
Friv 3

Online Friv said...

you'd have time to look these kids active. Please visit our website and let us play the game interesting.
A10 Friv
Friv 10
Y6


Micchals said...

The best free online games for you
Friv Games/
Kizi Games

Dong Hwa said...

Thank you for your interest ! Check out my site! you can play
Kizi 100/
Friv 2017/
Kizi 2017

Linda Rose said...

You’ve written nice post, I am gonna bookmark this page, thanks for info. I actually appreciate your own position and I will be sure to come back here.

Facebook Lite | Baixar Facebook | whatsapp baixar| Outlook Entrar

frivtn100 said...

We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work.

Friv2
Friv7
Friv8
Friv9
Friv20
Friv100
Friv100
Friv10000

frivtn100 said...
This comment has been removed by the author.
friv v said...

You’ve written nice post, I am gonna bookmark this page, thanks for info. I actually appreciate your own position and I will be sure to come back here.
Friv.Com
Friv Games
Friv Games

friv v said...

You’ve written nice post, I am gonna bookmark this page, thanks for info. I actually appreciate your own position and I will be sure to come back here.
Friv2
Kizi8
Yepi2

tinh linh said...

Thank you very much for your post, So kind for you, I also hope you will make more and more excellent post and let’s more and more talk, thank you very much, dear. Friv 5000 Games is abbreviation for free flash games. Our friv games are 100% safe to play, thank you.
Friv 5000

Unknown said...

I love all the posts, I really enjoyed,would like more information about this, because it is very nice, Thanks for sharing.
ABCya
ABCya
ABCya 3
ABCya 4
ABCya 5

frivtn100 said...

We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work.
Friv1
Friv Games
Friv Games

Vũ Diệu Linh said...

Thank you very much for the information you shared, it's all I've been looking for. Today is a beautiful day, do you want to participate in games? It will help your become more comfortable, i feel very great, please visit my website, to feel.
Friv 4

Video Kids Fun said...

I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always searching like this type blog post. I hope I will see again
Friv 100
Friv Games
Friv 10000

frivtn100 said...

I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always searching like this type blog post. I hope I will see again
Friv8
Friv9
Friv20
Www Friv

Trái Xoan said...

I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. Please visit my website.
Friv

Video Kids Fun said...

I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always searching like this type blog post. I hope I will see again
Friv 100
Friv Games
Friv 10000

Bella Swan said...

Thank you for giving posts and articles were very amazing. I really liked as a part of the article. With a nice and interesting topics. Thanks for posting.
I like play games Y8

frivtn100 said...

I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always searching like this type blog post. I hope I will see again
Friv2
Kizi8
Yepi2

Renesmee Foy said...

I don't know what to say, I liked your article and I hope you will have many entries or more, thanks for taking the time to show us.
Friv Unblocked
Y8 Unblocked
Kizi Unblocked

Jon Don said...

Office Setup
www.office.com/setup
Office Com Setup
Printer Tech Support
www.norton.com/setup

Jason Borne said...

Thanks
Avast Support | Avast Help
Norton Support | Norton Help
Gmail Customer Support

Emma Watson said...

Thank you so much for taking the time to share your experiences and talents. I hope your story will inspire others...
Unblocked Games
A10 Unblocked
PUnblocked Games

axilo roberte said...

I would like to thank your article. A great content. I hope to have more good posts in the future
Kizi
Ebog
Kizi 3
yepi 100
Abcya 2
Friv 2
Friv

Sky Clouds said...

Really impressive post. I liked your article and I hope you will have many entries or more. I enjoyed your article and planning to rewrite it on my own blog.
You can play games online my website
Friv 4 School
Friv 4 School
Friv 8

Bella Swan said...

Thanks for your great post.I like what your blog stands for.I'm a freelance computer programmer. You can play games online my website.
Friv 3000
Friv 4000

frivtn100 said...

I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always searching like this type blog post. I hope I will see again
jogos friv 2
juegos kizi 8
juegos yepi 2
friv 5
friv6
juegos y8
juegos 5

john wick said...

Office Setup

office.com/setup

www.office.com/setup

Office Com Setup

Printer Tech Support

www.norton.com/setup

hp Printer Tech Support

Printer Technical Support number

www.norton.com/setup

norton com setup

For Me said...

Really impressive post. I liked your article and I hope you will have many entries or more. I enjoyed your article and planning to rewrite it on my own blog.
You can play games online my website
Friv Unblocked
Y8 Unblocked
Kizi Unblocked

Love Me said...

I love all the posts, I really enjoyed,would like more information about this, because it is very nice, Thanks for sharing.
ABCya
ABCya
ABCya 3
ABCya 4
ABCya 5

frivtn100 said...

I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always searching like this type blog post. I hope I will see again
FRIV100 GAMES
FRIV - Friv 100 - Friv 100 Game - Friv games
FRIV10000 | FRIV1000 | FRIV100 GAMES

frivtn100 said...

We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work.thanks
Juegos Yepi 2
Kizi2
Kongregate Game
Money Movers 2
Parking Mania
Red Ball Games
Super Fighter 2
Tanki Online Games
Truck Driving Game

frivtn100 said...

We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work.
yepi3
friv baby game
friv racing game
friv shooting game
game for girl 2
girl games 3
girl game school

My Tomorrow said...

This is a great web site, Good sparkling user interface and, very informative blogs. I have found it enormously useful. Thanks you very good !
Kizi 9
Kizi 8
Kizi 7

Jenliskal said...

You need entertainment. Refer to our website. hope you get the most comfortable
Friv 5
Kizi 2
Kizi 10
Kizi 100
Friv 100

Post a Comment