On Tue, Jun 03, 2014 at 04:20:25PM +0800, Colin Charles wrote:
Hi all,
Recently there was chat about how PERFORMANCE_SCHEMA was enabled by mistake and it should be disabled in the 10.0 series. I'm curious - how many of you are using PERFORMANCE_SCHEMA? Is it a problem to turn it on, if you use it?
I'm referring to: https://mariadb.atlassian.net/browse/MDEV-6249
Looking from the webscalesql list, there are examples of performance degradation: https://groups.google.com/d/msg/webscalesql/B-4bPIb8mHI/eUNsl0lSfbMJ https://groups.google.com/d/msg/webscalesql/B-4bPIb8mHI/-YZMMCuPw3QJ
quote: "Our perf testing agrees with your assessment (we see about a 5%-6% perf hit when it's included and on, and a 2%-3% hit when it's included but off)"
Please discuss this, either here or on MDEV-6249
I have P_S enabled even for production servers even with no settings at all, If needed I can easy turn on instrumentations without restarting the server. Coze restarting a server in production ..... /me P_S fanboy -- über den grenzen muß die freiheit wohl wolkenlos sein