Recherche
Ask a question »

MySQL real time monitoring

March 2015


MySQL real time monitoring




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

For unlimited offline reading, you can download this article for free in PDF format:
Mysql-real-time-monitoring.pdf

See also

In the same category

MySQL - Cómo monitorear MySQL en tiempo real
By Carlos-vialfa on January 13, 2009
Come monitorare MySQL in tempo reale
By zig@ on March 3, 2010
MySQL - Como monitorar o MySQL em tempo real
By pintuda on March 21, 2012
Original article published by Jeff. Translated by jad05.
This document entitled « MySQL real time monitoring » from Kioskea (en.kioskea.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.