Mytop (MySQL Database Monitoring) in RHEL/CentOS 6.3/5.6 and Fedora 17/12

Mytop is an open source and free monitoring program for MySQL databases was written by Jeremy Zawodny using Perl language. It is much similar in look and feel of the most famous Linux system monitoring tool called top.

Mytop program provides a command-line shell interface to monitor real time MySQL threads, queries per second, process list and performance of databases and gives a idea for the database administrator to better optimize the server to handle heavy load.

Install Mytop MySQL Monitoring

By default Mytop tool is included in the Fedora repositories, so you just have to issue “yum install mytop” on the command line. If you are using RHEL/CentOS distributions, then you need to enable third party repositories like RPMForge or EPEL repository to install it. For other Linux distributions you may get source package from the http://jeremy.zawodny.com/mysql/mytop/

In this MySQL monitoring tutorial, we will show you how to install Mytop program under RHEL 6.3/6.2/6.1/6/5.8/5.6, CentOS 6.3/6.2/6.1/6/5.8/5.6 and Fedora 17,16,15,14,13,12 systems. Please note you must have running MySQL Server on the system to install and use Mytop.

Install Mytop in RHEL, CentOS and Fedora

To install Mytop, run the following command. Make sure you must have RPMForge or EPEL repository under RHEL/CentOS systems. Fedora user’s don’t need to add. Simply run the below command.

# yum install mytop

Sample Output :

Loaded plugins: fastestmirror, refresh-packagekit
Loading mirror speeds from cached hostfile
Setting up Install Process
Resolving Dependencies
Dependencies Resolved
=======================================================================================
Package   Arch  Version     Repository   Size
=======================================================================================
Installing:
mytop              noarch       1.7-3.b737f60.el6      epel                32 k
Transaction Summary
=======================================================================================
Install       1 Package(s)
Total download size: 32 k
Installed size: 68 k
Is this ok [y/N]: y
Downloading Packages:
mytop-1.7-3.b737f60.el6.noarch.rpm                          |  32 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mytop-1.7-3.b737f60.el6.noarch         1/1
Verifying  : mytop-1.7-3.b737f60.el6.noarch         1/1
Installed:
mytop.noarch 0:1.7-3.b737f60.el6
Complete!

How to use Mytop to Monitor MySQL

Mytop needs MySQL login credentials to monitor MySQL databases, simply run the following command to start the Mytop shell. Please provide your root MySQL password when it asks for.

      ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

                                                    ► Read more: http://adf.ly/1n6ZI4

      ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬