Page 1 of 1
monitor mysql utalization
Posted: Thu Dec 27, 2007 3:38 pm
by GeXus
What tools do you use to monitor mysql utilization? I'd love to have something nice and pretty with graphs/charts and allow me to drill down to specific processes/queries.
Posted: Thu Dec 27, 2007 3:50 pm
by Inkyskin
With MySQL tools, from the MySQL folks themselves, you can see queries as they happen, see live load and query types etc:
http://dev.mysql.com/downloads/gui-tools/5.0.html
Posted: Thu Dec 27, 2007 3:56 pm
by GeXus
Last time I tried that, I couldn't get the stats because it was running on a remote server... is there a way around that?
Posted: Thu Dec 27, 2007 4:42 pm
by Inkyskin
Unfortunately I don't think there is
Posted: Thu Dec 27, 2007 11:02 pm
by GeXus
Do you know if there is a web-based version? Otherwise I'm not sure how I would use it on the production servers, I only use shell access.
Posted: Fri Dec 28, 2007 3:12 am
by onion2k
You can get a lot of information from..
I suppose it shouldn't be too hard to make an AJAX interface to a script that runs that command every so often and builds a graph from the results for the values you're interested in. Interesting little project actually.
Posted: Fri Dec 28, 2007 8:44 am
by erupt
Would it work to have phpMyAdmin set up on that remote server in order to access it?