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