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.