[Maria-discuss] User feedback statistics
Hi,
http://mariadb.org/feedback_plugin/ in question -- where do we find out information about storage engines in use? List of loaded plugins?
So far I see: http://mariadb.org/feedback_plugin/stats/features/ - which has some information but clearly not all information
Can we also get access to all the information like if people are using the threadpool or not? I know that information is generated and we're receiving it, but we're just not exposing it (I mean I see this from SELECT * FROM information_schema.feedback;)
Its also a good way to see if users are using something like the PERFORMANCE_SCHEMA
Let me know how one can access this information (and even better how this can be exposed in the web interface)
cheers, -colin
-- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/%7C t: +6-012-204-3201 | Skype: colincharles
Hi, Colin!
On Jun 21, Colin Charles wrote:
Hi,
http://mariadb.org/feedback_plugin/ in question -- where do we find out information about storage engines in use? List of loaded plugins?
List of loaded plugins and plugin usage counters, you can see them in SELECT * FROM information_schema.feedback;
So far I see: http://mariadb.org/feedback_plugin/stats/features/ - which has some information but clearly not all information
Yes. I believe one can extract a lot more information from this data, than what we have online in charts. Ideas are always welcome :)
Can we also get access to all the information like if people are using the threadpool or not? I know that information is generated and we're receiving it, but we're just not exposing it (I mean I see this from SELECT * FROM information_schema.feedback;)
Its also a good way to see if users are using something like the PERFORMANCE_SCHEMA
Plugin stats will show that, I suppose.
Let me know how one can access this information (and even better how this can be exposed in the web interface)
That's for Bryan.
Regards, Sergei
That page is interesting! Can I suggest a couple more information to show? I see that you collect stats about fulltext and GIS - if possible, it would be interesting to know which storage engines people use for these features.
Regards Federico
-------------------------------------------- El sáb, 21/6/14, Sergei Golubchik serg@mariadb.org escribió:
Asunto: Re: [Maria-discuss] User feedback statistics Para: "Colin Charles" colin@mariadb.org CC: "Bryan Alsdorf" bryan@mariadb.com, "MariaDB discuss" maria-discuss@lists.launchpad.net Fecha: sábado, 21 de junio, 2014 22:15
Hi, Colin!
On Jun 21, Colin Charles wrote:
Hi,
question -- where do we find
out
information about storage engines in use? List of loaded plugins?
List of loaded plugins and plugin usage counters, you can see them in SELECT * FROM information_schema.feedback;
So far I see: http://mariadb.org/feedback_plugin/stats/features/
-
which has some information but
clearly not all information
Yes. I believe one can extract a lot more information from this data, than what we have online in charts. Ideas are always welcome :)
Can we also get access to
all the information like if people are using
the threadpool or not? I know that
information is generated and we're
receiving it, but we're just not exposing it
(I mean I see this from SELECT * FROM
information_schema.feedback;)
Its also a good way to see if users are
using something like the
PERFORMANCE_SCHEMA
Plugin stats will show that, I suppose.
Let me know how one can access this
information (and even better how
this
can be exposed in the web interface)
That's for Bryan.
Regards, Sergei
_______________________________________________ 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
Hi Serg,
On 22 Jun 2014, at 04:15, Sergei Golubchik serg@mariadb.org wrote:
Hi, Colin!
On Jun 21, Colin Charles wrote:
Hi,
http://mariadb.org/feedback_plugin/ in question -- where do we find out information about storage engines in use? List of loaded plugins?
List of loaded plugins and plugin usage counters, you can see them in SELECT * FROM information_schema.feedback;
So far I see: http://mariadb.org/feedback_plugin/stats/features/ - which has some information but clearly not all information
Yes. I believe one can extract a lot more information from this data, than what we have online in charts. Ideas are always welcome :)
1. Storage engines used 2. Optimizer switches - how many use default, how many don't (and whats on) 3. Query cache on/off? (got to be careful here when displaying - we have it as ON with 0 allocated size so its effectively disabled) 4. Is threadpool enabled?
I'm sure others will come up with other interesting bits, but as I said, this is just to satisfy general curiosity and to see how our features are being used in the wild (and if they're not, maybe making more content to draw users into it)
Can we also get access to all the information like if people are using the threadpool or not? I know that information is generated and we're receiving it, but we're just not exposing it (I mean I see this from SELECT * FROM information_schema.feedback;)
Its also a good way to see if users are using something like the PERFORMANCE_SCHEMA
Plugin stats will show that, I suppose.
It does (38 lines of info sent in a typical report)
Let me know how one can access this information (and even better how this can be exposed in the web interface)
That's for Bryan.
OK, thanks for keeping Bryan on CC - let's see if there's time for him to extend/display this info -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/%7C t: +6-012-204-3201 | Skype: colincharles
participants (3)
-
Colin Charles -
Federico Razzoli -
Sergei Golubchik