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.

39 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

alatsex terbaru said...

saya suka bisa datang berkunjungi ke sini, dan mohon ijin sberbagi info tentang toko alat bantu, yg jual alat sex, alat bantu sex pria, alat bantu sex wanita.

muhammad nurul qolbi said...

It was nice to land on this website post and to see such superb stuff. Your website is choked with authentic and highly-researched knowledge that's price reading. I’ll sure enough advocate your website to my fellows! Desain Ruang Tamu Kecil Minimalis | Gambar Design Kamar Mandi Kecil | Contoh Desain Dapur Modern 2015 | Gambar Desain Kamar Mandi Mungil Minimalis | Model Rumah Minimalis 2015

marina peter said...



visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here

visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here
visit here

Grosir Kosmetika said...

Kosmetik Online Halal Wardah
http://website.informer.com/grosirkosmetika.com
http://grosirkosmetika.com.cutestat.com/
http://grosirkosmetika.com.ipaddress.com/
https://www.reviewoursites.net/domain/grosirkosmetika.com
http://www.who.is/whois/grosirkosmetika.com
https://www.woorank.com/en/www/grosirkosmetika.com
http://www.scamaudit.com/domain/grosirkosmetika.com
http://www.pricearea.com/harga/kesehatan-dan-kecantikan/kosmetik?&merchant=grosirkosmetika.com
http://grosirkosmetika.com.webstatsdomain.org/
https://mawords.com/grosirkosmetika.com
http://oxodomain.com/whois/grosirkosmetika.com
http://www.quora.com/search?q=grosirkosmetika.com
http://whatmyip.co/info/whois/49.128.177.81/k/294934286/website/grosirkosmetika.com
http://onlinewebtool.com/analysis/grosirkosmetika.com
http://www.similarto.us/grosirkosmetika.com/
http://veewhois.com/grosirkosmetika.com

Toko Obat said...

thanks nice rticle jual obat bius

evi wintari said...

batik murah
mouse murah
tas murah
kerajinan souvenir nikah murah
celana murah
dompet murah
jersey murah
jilbab murah
kaos murah
komputer peripheral murah
lingerie murah
memori handphone murah
parfum murah
tongsis murah
buku murah
modem murah
keyboard murah
aksesoris handphone murah
power bank murah
flashdisk murah

Modem Murah said...

Jasa Tugas Akhir Skripsi Teknik Informatika
jasa pembuatan website toko online murah
Jasa Buat Website Murah
Jasa Skripsi Teknik Informatika
Jasa Skripsi Teknik Informatika
Jasa Skripsi Teknik Informatika
Jasa Skripsi Teknik Informatika
Jasa Skripsi Teknik Informatika
Modem Murah
Jasa Pembuatan Website Murah
Jasa Pembuatan Website Murah

Jasa Pembuatan & Bimbingan Tugas Akhir Skripsi Teknik Informatika
Jasa Skripsi Teknik Informatika
Jasa Skripsi Teknik Informatika
Jasa Skripsi Teknik Informatika
Jasa Pembuatan Website Murah
Jasa Pembuatan Website Murah

Paket Wisata said...

site direktori dofollow
jasa tugas akhir skripsi
jasa buat website murah
alamat tempat
umroh haji murah
hotel murah
cara cepat
modem murah
paket wisata murah
sewa apartemen harian
tips hidup sehat

Paket Wisata said...

jasa skripsi teknik informatika
jasa skripsi teknik informatika
jasa seo
jasa buat website
jasa skripsi sistem informasi
jasa jahit baju
jasa jahit seragam sekolah
jasa jahit
jasa buat toko online murah
deposit pulsa murah

Muhammad Riduan said...

Agen Judi Poker Online Indonesia
Kontes SEO Poker Online Indonesia
Shinchanpoker.com Agen Poker Dan Domino Terbaik Di Indonesia
Ipoker8 Situs Agen Judi Poker Dan Domino Online Terpercaya Indonesia
ituDewa.net Agen Judi Poker Domino QQ Ceme Online Indonesia
Agen Judi Poker Dan Domino Online Terpercaya Uang Asli Indonesia

Toko Obat said...

jual obat tidur
jual obat bius
obat bius
obat tidur wanita
obat tidur
obat tidur pria
obat tidur alami
obat tidur murah
obat tidur aman
obat tidur cair

Obat Bius | Jual Obat Bius Dan Obat Tidur
Obat Bius Cair Terbaru~Women Dildo
Obat Bius Cair~ Hirup dan Serbuk | Agen Resmi Jual Obat Bius
Obat Tidur Luquid
Obat Bius Serbuk Wanita
obat tidur aman
Obat Bius~Obat Tidur
Obat Bius LQuid Sex
Obat Bius Spary
Obat Bius Trivam
Obat Bius Cair
Obat Tidur Royhipnol
Obat Bius Hirup
Obat Tidur
Obat Tidur
Jual Obat Tidur
Jual Obat Bius
Jual Alat Bantu Sex Pria Dan Wanita
Obat Bius Power Sex
Jual Obat Bius,Jual Obat Tidur Cair,Serbuk,Hirup
Jual Obat Bius,Jual Obat Tidur Cair,Hirup,Semprot
Jual Obat Pembesar Penis,Obat Pembesar Penis,Pembesar Penis
Jual Obat Perangsang Wanita Cair,Serbuk,Hirup,Spray


wasirdenature said...

obat kemaluan keluar nanah obat kemaluan keluar nanah Obat kemaluan keluar nanah penis keluar nanah obat untuk kemaluan yang keluar nanah dan perih saat kencing obat kemaluan keluar cairan nanah dan perih saat kencing penyebab penis keluar nanah penyebab penis keluar nanah

OBAT HERBAL DE NATURE said...

obat wasir
obat kutil kelamin
kutil kelamin di kemaluan
obat kutil kelamin di batang penis
obat kutil kelamin herbal
bagaimana cara mengobati kutil kelamin
obat kutil kelamin yang paling manjur
obat wasir herbal
cara efektif mengobati penis
obat tradisional untuk kutil kelamin
obat wasir yang paling manjur untuk ibu hamil
cara mengobati kanker payudara secara herbal
bagaimana mengobati kutil kelamin
obat sipilis herbal manjur
obat yang manjur untuk wasir
wasir pada ibu hamil
pengobatan kutil kelamin
obat eksim

herbal gonore said...

kemaluan keluar cairan nanahmengapa cairan nanah keluar dari kemaluan mengapa cairan nanah keluar dari kemaluan mengapa kemaluan keluar nanah mengapa kemaluan keluar nanah ujung kemaluan keluar nanah ujung kemaluan keluar nanah obat kemaluan keluar nanah obat kemaluan keluar nanah obat penis keluar cairan nanah mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kelamin keluar nanah mengobati kelamin keluar nanah mengobati kemaluan pria yang keluar nanah nanah keluar dari kemaluan nanah keluar dari kemaluan kencing perih dan keluar cairan nanah cairan nanah keluar dari kemaluan cairan nanah keluar dari kemaluan obat ujung kemaluan keluar cairan nanah obat ujung kemaluan keluar cairan nanah

lionelmessi10 said...

kemaluan keluar cairan nanahmengapa cairan nanah keluar dari kemaluan mengapa cairan nanah keluar dari kemaluan mengapa kemaluan keluar nanah mengapa kemaluan keluar nanah ujung kemaluan keluar nanah ujung kemaluan keluar nanah obat kemaluan keluar nanah obat kemaluan keluar nanah obat penis keluar cairan nanah mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kelamin keluar nanah mengobati kelamin keluar nanah mengobati kemaluan pria yang keluar nanah nanah keluar dari kemaluan nanah keluar dari kemaluan kencing perih dan keluar cairan nanah cairan nanah keluar dari kemaluan cairan nanah keluar dari kemaluan obat ujung kemaluan keluar cairan nanah obat ujung kemaluan keluar cairan nanah

lionelmessi10 said...

kemaluan keluar cairan nanahmengapa cairan nanah keluar dari kemaluan mengapa cairan nanah keluar dari kemaluan mengapa kemaluan keluar nanah mengapa kemaluan keluar nanah ujung kemaluan keluar nanah ujung kemaluan keluar nanah obat kemaluan keluar nanah obat kemaluan keluar nanah obat penis keluar cairan nanah mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kelamin keluar nanah mengobati kelamin keluar nanah mengobati kemaluan pria yang keluar nanah nanah keluar dari kemaluan nanah keluar dari kemaluan kencing perih dan keluar cairan nanah cairan nanah keluar dari kemaluan cairan nanah keluar dari kemaluan obat ujung kemaluan keluar cairan nanah obat ujung kemaluan keluar cairan nanah

Kang Yudi said...

This information is really useful for me, thank you so much.
iklan gratis

Lan Linh said...

Great! Thanks for sharing the information. That is very helpful for increasing my knowledge in this field.
pacman
happy wheels
my little pony games
hulk games
mickey mouse games
car games
bike games
fun games

Toko Obat said...


jual obat tidur
jual obat bius
obat bius
obat tidur wanita
obat tidur
obat tidur pria
obat tidur alami
obat tidur murah
obat tidur aman
obat tidur cair
cs;082221617575
Obat Bius | Jual Obat Bius Dan Obat Tidur
Obat Bius Cair Terbaru~Women Dildo
Obat Bius Cair~ Hirup dan Serbuk | Agen Resmi Jual Obat Bius
Obat Tidur Luquid
Obat Bius Serbuk Wanita
obat tidur aman
Obat Bius~Obat Tidur
Obat Bius LQuid Sex
Obat Bius Spary
Obat Bius Trivam
Obat Bius Cair
Obat Tidur Royhipnol
Obat Bius Hirup
Obat Tidur
Obat Tidur
Jual Obat Tidur
Jual Obat Bius
Jual Alat Bantu Sex Pria Dan Wanita
Obat Bius Power Sex

Whatsapp Descargar said...

Very interesting! Thanks you
Signature:
download free Descargar Whatsapp Para Android and download baixar whatsapp para celular online and descargar whatsapp , baixar whatsapp gratis

Frozen Juegos said...

Great post,Thanks for providing us this great knowledge,Keep it up.
A good blog.
Signature:
Jugar juegos de frozen gratis en línea gratis, los nuevos de princesa de Disney juegos frozen - la princesa encantadora y linda. Divertirse frozen!

Facebook Descargar said...

Thank you for sharing valuable information. Nice post. I enjoyed reading this post.
Signature:
download descarga facebook gratis para Android celular and download free descargar facebook gratis and descargar facebook gratis , descarga facebook

Su Su said...

Thank you very much for your post, it makes us have more and more discs in our life, 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.
unblocked games| unblockedgames| unblocked games at school| unblocked games for kids
friv| friv4school| friv 4 school| monster high games| monster high| monster high drees up
happy wheels| happywheels| happy wheels demo| happy wheels unblocked| happy wheels hacked
shooting games| shooting| tetris| tetris unblocked| tetris game| tetris online

games unblocked said...

Any way I'll be subscribing to your feed and I hope you post again soon.
kids games online
friv 2
unblocked games
juegos de un show mas

Khương Hoàng Gia said...

Hút bể phốt tại hà nội
Hút bể phốt tại cầu giấy
Hút bể phốt tại tây hồ
Hút bể phốt tại hai bà trưng
Hút bể phốt tại đống đa
Hút bể phốt tại thanh xuân
Hút bể phốt tại hoàn kiếm
Hút bể phốt tại long biên
Hút bể phốt tại hà đông
Hút bể phốt tại mỹ đình
Hút bể phốt tại bà đình
Hút bể phốt tại hoàng mai
Hút bể phốt tại KCN
Cách thông tắc bồn cầu
Cách thông tắc toilet
Cách thông tắc bể phốt
Cách thông tắc bệ xí
Cách khử mùi nhà vệ sinh
Cách thông tắc toilet không có pittong

sửa khóa
dọn nhà theo giờ
máy lọc không khí
mở tài khoản Forex
Máy lọc không khí Airocide
mở tai khoản IronFX
Vận chuyển hàng hóa bắc nam
Nước uống đóng bình
Sửa khóa tại nhà Hà Nội
Thuốc hỗ trợ điều trị ung thư, sữa cho bệnh ung thư
Máy lọc không khí gia đình

Sugeng raharjo said...

cara mengobati kutil pada kemaluan pria
cara mengobati kutil di kemaluan pria
cara mengabati kutil di kelamin pria
cara mengobati kutil di batang penis dengan obat herbal
cara mengobati kutil pada kemaluan pria dengan obat herbal
salep untuk kutil di kemaluan
toko online yang menjual obat kutil kemaluan
bagaimana cara mengobati kutil di sekitar kemaluan
obat apa yang paling manjur untuk mengobati kutil di kemaluan
mengobati kutil di sekitar kemaluan
tips rahasia mengobati kutil kelamin atau kutil di kemaluan
metode pengobatan kutil kelamin atau kutil di kemaluan
obat sipilis/raja singa di apotik
obat herbal untuk raja singa
obat alami untuk raja singa
obat tradisional untuk sipilis/raja singa
cara mengobati raja singa
cara mengobati sipilis
artikel tentang raja singa
bagaimana cara mengobati raja singa/sipilis
apa nama obat sipilis di apotik
apa nama obat raja singa yang manjur

Post a Comment