Home » WHM/cPanel » Mytop open source tool to monitor Mysql

Mytop open source tool to monitor Mysql

Mytop is the most excellent open source tool to monitor Mysql strength, current running queries, no of sleep process, mysql load etc. To install Mytop open source tool to monitor Mysql use the following steps.
First of all , we need to install few prerequisites to maintain mytop script.
SSH the server as root user and perform the following commands :

#/scripts/realperlinstaller –force Term::ReadKey
#/scripts/realperlinstaller –force DBD::mysql
#/scripts/realperlinstaller –force Getopt::Long
#/scripts/realperlinstaller –force DBI


Note:- Basically all of above modules already installed on cPanel server.

To Download the latest mytop tool perform the following command.

#wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
#tar zxpfv mytop-1.6.tar.gz
#cd mytop-1.6
#perl Makefile.PL && make && make install

After complete the installation perform the below command.

#mytop
If you get error “Error in option spec: “long|!” message you are trying to perform the mytop command. To resolve the issue follow the below stesp.

Edit the mysql script file through your favorite editor.

#vi /usr/bin/mytop

Search the line “long|!” => \$config{long_nums},” and comment it.
It must look like as

# “long|!” => \$config{long_nums},

About

I am founder and webmaster of www.linuxpcfix.com and working as a Sr. Linux Administrator (Expertise on Linux/Unix & Cloud Server) and have been in the industry from last 7 years.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload the CAPTCHA.

Categorized Tag Cloud