Diagnose MySQL in real-time: Spotlight on MySQL

http://www.quest.com/spotlight-on-mysql/

Here’s a quick one for you…if you maintain any MySQL databases (IT admins, you know who you are), then you can drill down on potential issues and performance counters using Quest Software’s awesome Spotlight tool (they also make Spotlight on Windows – a fantastic troubleshooting and monitoring tool).

Aside from looking cool, the tool has some useful features.

Like Spotlight on Windows (actually, the MySQL piece runs in the same parent ‘Spotlight’ instance), you can see a quick overview of important performance counters and statistics, which in turn allow you to drill down to additional information about that particular counter.

You can view (if enabled), the slow, general and error logs in a tabbed display, check out performance graphs of SQL execution rates, row access, sessions, etc. and much more.  Also, as before, you can get audible or visual notifications if an item hits a defined threshold (see the program preferences).

This is a must have if you have a need to keep a *ahem* spotlight on your MySQL databases.

One caveat, though – you must have MySQL 5.0.3 or later running the InnoDB storage engine (not ISAM).  Also, be sure the user account you use for monitoring has all the proper permissions in MySQL.

Anyone know of any other great MySQL monitoring tools?  I actually need one to watch ISAM-based databases - - and I am not a MySQL guy, so any help here is appreciated!