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/
You might also enjoy:
-
To stop a MySQL server instance on an Ubuntu linux install via the command line is as simple as entering: sudo /etc/init.d/mysql stop Alternatively, to st ... -
SQLyog is an absolutely brilliant GUI front-end for MySQL databases. Delivering all functionality you could ever want to apply to a database, MySQL makes da ... -
Backing up your MySQL database or generating a copy of it to shift around is quite a simple affair thanks to the powerful mysqldump command that ships with ... -
One of the easiest ways to backup and restore your MySQL database (or even just to move databases between different servers) is to make use of MySQL's handy ... -
Just a quick note on how to permanently change your MySQL server's configuration to allow for a bigger max_allowed_packet limit, basically the variable that ...
