How To Install MyTOP – a top clone for MySQL

In this howto i will describe how to install mytop package on CentOS 5.3. MyTOP is top command clone to monitor mysql performance including queries, threads etc. You can get source of it from here to build or you can use rpmforge repositories for pre-build rpms. The machine i used to demonstrte is in production and getting very high mysql access, its running on CentOS 5.3.

1 Setting Up RPMForge Repository

RPMForge repository (http://dag.wieers.com) is the biggest rpm respository for RHEL, CentOS for all versions. To enable RPMForge respository run following command. The following command directly install rpm from http://dag.wieers.com site.

rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm

This rpm will add necessary files in our repository configuration and can be viewed at /etc/yum.repos.d/rpmforge.repo

2 Install MyTOP

Use yum to install mytop on your machine

yum -y install mytop

It will install mytop with all necessary pre-requisite to run mytop.

3 Running MyTOP

To run use

mytop

if you have restricted access using password then

mytop -u root -p <password> -h localhost

NOTE: You may get following error in CentOS 5.3
Error in option spec: “long|!”

To fix this do following.

chmod 755 /usr/bin/mytop
vi /usr/bin/mytop

Search for the line

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

Change it to by commenting using #

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

Now run the command again and it will run fine and you can see mytop giving all the information about you mysql server.

mytop