Real-time MySQL monitoring

PHP is not really the best for real time monitoring as it is (normally) transaction based (HTTP).

There is a free open source Java program called "Mysql Monitor Tool" which can monitor a MySQL (or multiple) databases in real time:

http://sourceforge.net/projects/mysqlmt/