MySQL real time monitoring

January 2017




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


Published by jad05. Latest update on March 9, 2011 at 11:12 AM by jad05.
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 (ccm.net).