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.
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:
This document, titled « MySQL real time monitoring », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM