(866) 366-3640 - support@sagonet.com
Sago Logo
Banner

   
Log in / create account Page Discussion History Go to the site toolbox
Mytop - SQL Monitor

Updated

Now install mytop now in less than a minute.

I wrote a script to do the steps below using the current versions of the required perl dependencies.

If it does not work then you can do the steps below, which are pretty easy

Superfast method:

1) wget ks.sagonet.com/mytop/mytopinstall.sh 
2) bash mytopinstall.sh
3) There is no step three.

This appears to work fine on CentOS 4.6 & Cpanel boxes. If not, it's not hard to do - read on.

Installing mytop in Less Than :10 Minutes

mytop is a process monitor for MySQL, similar to TOP. It is very useful, but is rather a pain in the ass to install as it has a lot of perl module dependencies and of course they may in fact be installed but trying to install mytop will likely say they are not . . this can be solved with Correcting Perl Module Dependencies Fail

You can't just install the perl modules in Cpanel, as they won't be registered in the RPM database, so you will still get errors when you try to install mytop.

You can install this very quickly as all the dependencies can be resolved quickly using this method.

The fast way of resolving the dependencies is . . .

Installing mytop:

1) Ensure perl* is not listed in exclusions in /etc/yum.conf (Remove it temporarily and put it back in when done)

2) Now install perl-DBI just from base

yum install perl-DBI

(It should find it fine - if so install from here other wise add the repos below, it is also in Dag.)

3) Install perl-TermReadKey-2.30-1.i386.rpm

 wget ks.sagonet.com/mytop/perl-TermReadKey-2.30-1.i386.rpm

(Or build it yourself using cpan2rpm, etc.)

Updated Repo Setup:

Steps 4 and 5 are updated as follows: Rather than manually entering the repos for dag ane dries you can now just install an RPM to set up rpmforge.

Set up the rpmforge repo - just wget the proper rpmforge rpm from here:
 
https://rpmrepo.org/RPMforge/Using 

Import the GPG key for rpmforge for you CentOS version: 

http://wiki.centos.org/Repositories/RPMForge#head-b2e1db5c8b5c90cbd2e854ee070ba1e0da8824dd

4) Add dag and weirs to /etc/yum/conf like this: (Remove these when done, or set enable=0)

# PUT YOUR REPOS HERE OR IN separate files named file.repo
# in /etc/yum.repos.d


[dag]
name=Dag RPM Repository for Red Hat Enterprise Linux
baseurl=http://apt.sw.be/redhat/el$releasever/en/$basearch/dag
gpgcheck=1
enabled=1


[dries]
name=Extra Fedora rpms dries - $releasever - $basearch
baseurl=http://ftp.belnet.be/packages/dries.ulyssis.org/redhat/el4/en/i386/dries/RPMS
gpgcheck=1
enabled=1

5) Install the GPG key for Dag:

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

6) Finally - install mytop

yum install mytop

It should find and install it from Dag fine now.

Some color output features have additional perl module dependencies. Now that it is installed you should be able to install those with cpan, yum, or cpan2rpm

7) Cleanup - Remove/disable Dag and Dries from /etc/yum.conf and put perl* back in exclusions.

Now, have fun with mytop !