← Back to team overview

maria-discuss team mailing list archive

Re: PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

 

i only use it at development, at production it's not used


2014-06-03 6:24 GMT-03:00 Jean Weisbuch <jean@xxxxxxxxxx>:

> I personally never had time to give much looks to P_S, i gave it some
> looks but never seriously dug onto and really had to keep it enabled on a
> production server, its a nice feature but i think that if someone knows it
> and needs it, they will be able to enable it but most of the "common" users
> wont use it so it feels better to me not to enable it be defaut, as its
> easy to disable.
>
>
> On 03/06/2014 10:20, 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
>>
>> Thanks
>>
>> cheers,
>> -colin
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

Follow ups

References