Hi All,
This is my second post i am planning to participate in GSOC 10 i would love to do charts in server status page. I have one question i hope you guys will give me feedback on that. Adding graphs to run time information is good will help DBA a lot but how about adding certain diagnostic tools like combining explain with this charts showing what mysql parameters one can change like buffer size, indexes for queries and giving ballpark range of how this can improve the performance of certain resource intensive queries and showing all this in a bar graph. Basically comparing the query time at present with query time if the changes are done. I see this can help because when some large query is run on tables with millions of data many times DBA have problem to pin point why server response time is low and what corrective measures he has to take.
Thanks and Regards, Shreyas
Shreyas Ahir a écrit :
Hi All,
This is my second post i am planning to participate in GSOC 10 i would love to do charts in server status page. I have one question i hope you guys will give me feedback on that. Adding graphs to run time information is good will help DBA a lot but how about adding certain diagnostic tools like combining explain with this charts showing what mysql parameters one can change like buffer size, indexes for queries and giving ballpark range of how this can improve the performance of certain resource intensive queries and showing all this in a bar graph. Basically comparing the query time at present with query time if the changes are done. I see this can help because when some large query is run on tables with millions of data many times DBA have problem to pin point why server response time is low and what corrective measures he has to take.
Thanks and Regards, Shreyas
Hi, on the "Runtime information" page we already show some figures in red, indicating possible problems. I'm not sure how this could be effectively represented on a graph.
On Sun, Mar 28, 2010 at 3:45 PM, Marc Delisle marc@infomarc.info wrote:
Shreyas Ahir a écrit :
Hi All,
This is my second post i am planning to participate in GSOC 10 i would
love
to do charts in server status page. I have one question i hope you guys will give me feedback on that. Adding graphs to run time information is good will help DBA a lot but how about adding certain diagnostic tools like combining explain with this charts showing what mysql parameters one can change like buffer size, indexes
for
queries and giving ballpark range of how this can improve the performance
of
certain resource intensive queries and showing all this in a bar graph. Basically comparing the query time at present with query time if the
changes
are done. I see this can help because when some large query is run on
tables
with millions of data many times DBA have problem to pin point why server response time is low and what corrective measures he has to take.
Thanks and Regards, Shreyas
Hi, on the "Runtime information" page we already show some figures in red, indicating possible problems. I'm not sure how this could be effectively represented on a graph.
On the "Runtime Information" page, we have records of the number of queries processed like "select", "update", etc so we can store this information somewhere and generate graphs based on this data?
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Neeraj Agarwal a écrit :
On the "Runtime Information" page, we have records of the number of queries processed like "select", "update", etc so we can store this information somewhere and generate graphs based on this data?
This page sends SHOW GLOBAL STATUS and the server returns the exact number of each command it has received at this point, for example
Com_select 15897667
But SHOW GLOBAL STATUS is sent from phpMyAdmin when someone looks at this page. It's a web page, triggered by a human so we cannot predict at which point in time phpMyAdmin would be invoked, to generate/store the current stats.
On Sun, Mar 28, 2010 at 4:04 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On the "Runtime Information" page, we have records of the number of
queries
processed like "select", "update", etc so we can store this information somewhere and generate graphs based on this data?
This page sends SHOW GLOBAL STATUS and the server returns the exact number of each command it has received at this point, for example
Com_select 15897667
But SHOW GLOBAL STATUS is sent from phpMyAdmin when someone looks at this page. It's a web page, triggered by a human so we cannot predict at which point in time phpMyAdmin would be invoked, to generate/store the current stats.
We can have a cron job installed.
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 4:04 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On the "Runtime Information" page, we have records of the number of
queries
processed like "select", "update", etc so we can store this information somewhere and generate graphs based on this data?
This page sends SHOW GLOBAL STATUS and the server returns the exact number of each command it has received at this point, for example
Com_select 15897667
But SHOW GLOBAL STATUS is sent from phpMyAdmin when someone looks at this page. It's a web page, triggered by a human so we cannot predict at which point in time phpMyAdmin would be invoked, to generate/store the current stats.
We can have a cron job installed.
I know, but isn't this outside the scope of phpMyAdmin? I mean, not everyone has this level of access to his server, and not all servers support cron anyway (might be a non-Linux server).
I cannot forbid you to put this in your proposal, though :)
On Sun, Mar 28, 2010 at 4:13 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 4:04 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
On the "Runtime Information" page, we have records of the number of
queries
processed like "select", "update", etc so we can store this information somewhere and generate graphs based on this data?
This page sends SHOW GLOBAL STATUS and the server returns the exact number of each command it has received at this point, for example
Com_select 15897667
But SHOW GLOBAL STATUS is sent from phpMyAdmin when someone looks at this page. It's a web page, triggered by a human so we cannot predict at which point in time phpMyAdmin would be invoked, to generate/store the current stats.
We can have a cron job installed.
I know, but isn't this outside the scope of phpMyAdmin? I mean, not everyone has this level of access to his server, and not all servers support cron anyway (might be a non-Linux server).
Most of the hosting providers provide cron support and we can ask the user to set it up for us if he wants to enjoy this feature and I guess he will do that for the extra benefits he get! After all everybody needs diagnostics.
I cannot forbid you to put this in your proposal, though :)
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Marc Delisle -
Neeraj Agarwal -
Shreyas Ahir