Installing mytop on cpanel

abstract computer network in 3d over a white b...

MyTop is one of the best MySQL monitoring tools available, written by a MySQL guru, Jeremy Zawodny.

Its vital for monitoring your MySQL health, especially in a shared hosting environment.

Installation on a CentOS (for cPanel) server is quite straight forward with this guide.
First off, we need a few perl modules, cPanel’s realperlinstaller comes in handy, if you aren’t on cPanel, you’ll need to CPAN or manually install these modules.

[codesyntax lang=”bash”]
/scripts/realperlinstaller –force Getopt::Long
/scripts/realperlinstaller –force DBI
/scripts/realperlinstaller –force DBD::mysql
/scripts/realperlinstaller –force Term::ReadKey

Now, we download and install mytop.

[codesyntax lang=”bash”]
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

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

Search for the line in Makefile.PL

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

Change it to by commenting using #

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

Easy fix.

Now you can run mytop

[codesyntax lang=”bash”]
mytop -d mysql

Done!

Author: Kieran Barnes

Kieran is a PHP developer with 15 years commercial experience. Specialist in WordPress, CakePHP, CubeCart and all things PHP.

One thought on “Installing mytop on cpanel”

Leave a Reply

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