Re: [Maria-discuss] performance_schema

2015-05-15 Thread Sergei Golubchik
Hi, Rhys! On May 14, Rhys Campbell wrote: Hi All, Does anyone know if the performance_schema guarantees that every statement executed will appear in the events_statement_summary_by_digest table (excluding those that could be pushed out due to size restrictions). Or is it a best effort

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

2014-06-03 Thread 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

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

2014-06-03 Thread Roberto Spadim
i only use it at development, at production it's not used 2014-06-03 6:24 GMT-03:00 Jean Weisbuch j...@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

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

2014-06-03 Thread Jocelyn Fournier
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

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

2014-06-03 Thread 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

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

2014-06-03 Thread Roberto Spadim
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 s...@mariadb.org: Hi, Roberto! On Jun 03, Roberto Spadim wrote: i only use it at development, at production

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

2014-06-03 Thread Roberto Spadim
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 s...@mariadb.org: Hi, Roberto! On Jun 03, Roberto Spadim

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

2014-06-03 Thread 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

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

2014-06-03 Thread Roberto Spadim
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 piva...@google.com: I personally

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

2014-06-03 Thread 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

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

2014-06-03 Thread Federico Razzoli
: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12) Para: Maria Discuss maria-discuss@lists.launchpad.net, maria-develop...@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