MySQL real time monitoring

Last update on August 10, 2009 11:43 AM by jak58
Published by jad05

MySQL real time monitoring







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 using the link below:

http://mtop.sourceforge.net/

Installation:

Decompress archive file.

Type in the following command to install: 

Perl Makefile.PL
make
make install
Best answers for « MySQL real time monitoring » in :
[Apache]Monitoring web traffic in real-time Show [Apache]Monitoring web traffic in real-time There are tool endemic to Apache web server allowing a real-time analysis of the web traffic: Log files can be used by specialized software to develop a comprehensive and complete analysis of...
Monitoring the traffic activity in real-time Show Monitoring the traffic activity in real-time To know the bandwidth used by your Linux machine, in addition to standard tools for most distributions (not permitting the display in real time), there are two particularly useful...
[ MySQL]Linux Monitoring port 3306 Show [MySQL]Linux Monitoring port 3306 To monitor port 3306 on Linux you can use the command: tcpdump -i eth0 -nN -vvv -xX -s 1500 port 3306 Where s is the length of the packet.
Viewing connections in real time ShowViewing connections in real time Linux Windows Linux Under Linux, to view your outgoing network connections in real time, open a terminal and type the following commands: sudo watch lsof-i It will display: The name of the...
See connections in a real time enviroment ShowSee connections in a real time enviroment Under Linux Under Windows Under Linux In order to observe your outgoing network connections and open ports, type in a terminal in real time: sudo watch lsof -i Items displayed: The...
Mktime() - Timestamp yesterday, last month, etc.). ShowMktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
Download AV Webcam Morpher Show
Download NBA Scoreboard 2009 ShowDo not miss any news from NBA ! NBA Scoreboard gives you directly the results of the recent matches or to come, the summaries of the previous matches or of the day but also the programs of the next matches. The program also gives you real-time...
Download Sys Monitor Show
Operating system ShowDescription of the operating system For a computer to be able to operate a computer programme (sometimes known as application or software), the machine must be able to perform a certain number of preparatory operations to ensure exchange between...
Chat ShowChat A "Chat" area, or "chatroom," is a space where multiple Internet users can engage in written discussion in real time. The term "chatting" is generally reserved for communication systems included on a web site, as opposed to the term "instant...
The Wi-Fi link layer ShowData link layer The data link layer of the 802.11 standard is composed of two sublayers: the Logical Link Control layer (or LLC for short), and the Media Access Control layer (or MAC). The MAC layer defines two different access methods: The...
They need your help