Pages

Showing posts with label disable. Show all posts
Showing posts with label disable. Show all posts

Wednesday, April 19, 2017

Another reason to disable performance schema

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 dont 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.

Available link for download

Read more »