monitor mysql utalization

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

monitor mysql utalization

Post 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.
User avatar
Inkyskin
Forum Contributor
Posts: 282
Joined: Mon Nov 19, 2007 10:15 am
Location: UK

Post 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
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post 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?
User avatar
Inkyskin
Forum Contributor
Posts: 282
Joined: Mon Nov 19, 2007 10:15 am
Location: UK

Post by Inkyskin »

Unfortunately I don't think there is
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post 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.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post by onion2k »

You can get a lot of information from..

Code: Select all

SHOW /*!50002 GLOBAL */ STATUS;
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.
erupt
Forum Commoner
Posts: 58
Joined: Sat Feb 25, 2006 10:24 am

Post by erupt »

Would it work to have phpMyAdmin set up on that remote server in order to access it?
Post Reply