You are administrating a MySQL database and you want to analyze in real time the operations taking place in order to have a diagnostics over probable problems, errors or to monitor server activity.
PhpMyAdmin allow you to see the variables of the MySQL server, to define the parameters or to list the processes taking place, but can't be considered as a real time monitoring.
There exist a simple freeware allowing the real time monitoring of MySQL server: Mtop
If you have an account on a PC on which the MySQL is running, simply download Mtop.
Decompress archive file.
Type in the following command to install:
For unlimited offline reading, you can download this article for free in PDF format: