[Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

older
[Maria-discuss] New Question: How...

Colin Charles

3 Jun 2014 3 Jun '14

10:20 a.m.

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

Show replies by date

Jean Weisbuch

3 Jun 3 Jun

11:24 a.m.

New subject: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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

Roberto Spadim

4:50 p.m.

New subject: [Maria-discuss] 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 :

...

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

Sergei Golubchik

7 p.m.

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

7:02 p.m.

New subject: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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 :

...

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

Roberto Spadim

7:03 p.m.

New subject: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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 :

...

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

Jocelyn Fournier

5:03 p.m.

New subject: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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

Pavel Ivanov

7:10 p.m.

New subject: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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

Roberto Spadim

7:29 p.m.

New subject: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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 :

...

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

Sergei Golubchik

7:50 p.m.

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

Roberto Spadim

8:38 p.m.

New subject: [Maria-discuss] [Maria-developers] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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 :

...

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

erkan yanar

7:32 p.m.

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

Federico Razzoli

10:09 p.m.

New subject: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

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 escribió: Asunto: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12) Para: "Maria Discuss" , 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

3758

Age (days ago)

3758

Last active (days ago)

List overview

Download

12 comments

8 participants

participants (8)

Colin Charles
erkan yanar
Federico Razzoli
Jean Weisbuch
Jocelyn Fournier
Pavel Ivanov
Roberto Spadim
Sergei Golubchik

[Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

tags

participants (8)