[Phpmyadmin-devel] GSOC 2010

[Marc Delisle]

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.

-- 
Marc Delisle
http://infomarc.info