monitor mysql utalization
Moderator: General Moderators
monitor mysql utalization
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.
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
http://dev.mysql.com/downloads/gui-tools/5.0.html
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.
Code: Select all
SHOW /*!50002 GLOBAL */ STATUS;