MyTop for MySql - Installation guide on CentOS

MyTop is the console-based tool for monitoring the overall performance of a MySQL server. The installation steps are as follows

# yum install perl-TermReadKey
# wget http://www.mysqlfanboy.com/mytop/mytop-1.9.tar.gz
# tar -zxvf mytop-1.9.tar.gz
# cd mytop-1.9
# perl Makefile.PL
# make
# make test
# make install

Now we need a config file as follows

# vi ~/.mytop

user=root
pass=YOURPASSWORD
host=localhost
db=YOURDBNAME
delay=5
port=3306
socket=/tmp/mysql.sock
batchmode=0
header=1
color=1
idle=1