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