Spotlight on MySQL, or Spotlight for short, is a fantastic tool for monitoring the status of all your MySQL databases via one single screen display.
It basically allows you to specify a number of MySQL connection strings to various databases that you control and once connected, displays a host of valuable, real time information on a nice big black and green screen. It highlights essentially all database activity, from data flowing to and from the database, the number of active sessions, sql statments being executed and a host of more, indepth views of just what exactly is going on inside your MySQL server installation.
On top of all this, it also features a number of other graphical reports detailing various aspects of the MySQL server’s usage and allows you to set certain thresholds, triggering alarms when those thresholds do get crossed if you so wish.
An essential tool in monitoring the performance and stability of your MySQL installation, this really is one of those indispensable applications that you beg your boss to put up on a big screen over your work area, just so that someone at least can keep an eye on the all important backbone of your operation!
Oh, and in case you were wondering, Spotlight works on MySQL server versions 5.0.3 and up (or else basically any that employ the InnoDB storage engine).
Also, although you can purchase the product for Commercial usage, there is a freeware version available for download which you can grab here.
Related Link: http://www.quest.com/spotlight-on-mysql/