kieranbarnes Independent PHP, WordPress & CubeCart Programmer

Installing mytop on cpanel

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.

/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.

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

mytop -d mysql

Done!

Related posts

1. Upgrading to MySQL 5.1 in cPanel/WHM
   Upgrading to MySQL 5.1 in cPanel is currently not the easiest thing in the world....
2. Installing memcached on CentOS (cPanel)
   Welcome to hell. No really, compared to installing memcached on Ubuntu, CentOSs really sucks. CentOS...
3. Getting mytop to work on CentOS/Redhat
   Screw all these AJAXified, buzz-wordified MySQL monitors. I'm old school. I use the fantastic mytop...
4. Installing mod_evasive on cPanel and/or Apache
   This guide details how to install mod_evasive on cPanel to help protect against DDOS attacks,...
5. Installing nginx & PHP-FPM securely on CentOS
   I won't go into the reasons why you should install nginx, if you're here, you've...