[Phpmyadmin-devel] GSOC 2010

[Neeraj Agarwal]

On Sun, Mar 28, 2010 at 3:45 PM, Marc Delisle <marc at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20100328/1f5814b6/attachment.html>