MySQL real time monitoring

December 2016




Intro


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.

Installation:

  • Decompress archive file.
  • Type in the following command to install:


Perl Makefile.PL  
make  
make install


Related :

This document entitled « MySQL real time monitoring » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.