[Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)
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 -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles
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
i only use it at development, at production it's not used 2014-06-03 6:24 GMT-03:00 Jean Weisbuch <jean@phpnet.org>:
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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
Hi, Roberto! On Jun 03, Roberto Spadim wrote:
i only use it at development, at production it's not used
And what performance-schema related options do you have in your development my.cnf file? Is it only performance-schema=1 or something more involved?
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?
Regards, Sergei
i will check but i compile every production binary from source, i think it's a compile time option not my.cnf file, i will check and return 2014-06-03 14:00 GMT-03:00 Sergei Golubchik <serg@mariadb.org>:
Hi, Roberto!
On Jun 03, Roberto Spadim wrote:
i only use it at development, at production it's not used
And what performance-schema related options do you have in your development my.cnf file? Is it only performance-schema=1 or something more involved?
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?
Regards, Sergei
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
oh sorry, at development just performacnce-schema=1 and sometimes when i need more information i try two others plugins to check query times and query cache informations (hit rate per query) 2014-06-03 14:00 GMT-03:00 Sergei Golubchik <serg@mariadb.org>:
Hi, Roberto!
On Jun 03, Roberto Spadim wrote:
i only use it at development, at production it's not used
And what performance-schema related options do you have in your development my.cnf file? Is it only performance-schema=1 or something more involved?
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?
Regards, Sergei
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
Hi, Never used it on production. From my point of view, it should be disabled by default, but included. The whole purpose of this variable is to have a way to analyze/optimize performances easily, when needed; if it's enable by default, we have a perf hit, so that's counterproductive. I assume it should be possible to work to remove the performance hit when disabled but included ? Thanks, Jocelyn Le 03/06/2014 10:20, Colin Charles a écrit :
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
-- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I personally would prefer if MariaDB had performance schema not compiled in by default. Then we wouldn't be frustrated every time we upgrade and find out that the tarball doesn't compile without performance schema (yes, 10.0.11 doesn't compile). On Tue, Jun 3, 2014 at 1:20 AM, Colin Charles <colin@mariadb.org> 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
-- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
hum, maybe a "-debug" package and a "-production" package could be better if someone what a developer version get the -debug, for production use "-production" is it easy to create two kinds of packages at mariadb release time? 2014-06-03 14:10 GMT-03:00 Pavel Ivanov <pivanof@google.com>:
I personally would prefer if MariaDB had performance schema not compiled in by default. Then we wouldn't be frustrated every time we upgrade and find out that the tarball doesn't compile without performance schema (yes, 10.0.11 doesn't compile).
On Tue, Jun 3, 2014 at 1:20 AM, Colin Charles <colin@mariadb.org> 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
-- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
Hi, Pavel! On Jun 03, Pavel Ivanov wrote:
I personally would prefer if MariaDB had performance schema not compiled in by default. Then we wouldn't be frustrated every time we upgrade and find out that the tarball doesn't compile without performance schema (yes, 10.0.11 doesn't compile).
This is easy to fix. I'll change one of our builders (that doesn't do release packages) to compile without performance schema. Regards, Sergei
hi sergei, i think it's easy too maybe we could have some kind of servers, one for debug, one for production with instrumentations features and a clean server without intrumentations, just an idea, i think some time ago mysql was releasing mysql-dev, mysql-debug, mysql-xxx i'm wrong? 2014-06-03 14:50 GMT-03:00 Sergei Golubchik <serg@mariadb.org>:
Hi, Pavel!
On Jun 03, Pavel Ivanov wrote:
I personally would prefer if MariaDB had performance schema not compiled in by default. Then we wouldn't be frustrated every time we upgrade and find out that the tarball doesn't compile without performance schema (yes, 10.0.11 doesn't compile).
This is easy to fix. I'll change one of our builders (that doesn't do release packages) to compile without performance schema.
Regards, Sergei
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
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
I don't use it in production, but this may change in the future. The problem is that I cannot enable it when I need it, if I don't want to restart the server. Regards Federico -------------------------------------------- El mar, 3/6/14, Colin Charles <colin@mariadb.org> escribió: Asunto: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12) Para: "Maria Discuss" <maria-discuss@lists.launchpad.net>, maria-developers@lists.launchpad.net Fecha: martes, 3 de junio, 2014 10:20 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 -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (8)
-
Colin Charles -
erkan yanar -
Federico Razzoli -
Jean Weisbuch -
Jocelyn Fournier -
Pavel Ivanov -
Roberto Spadim -
Sergei Golubchik