Oct 262009

Mytop: MySQL process monitor

See whats going on under the hood of MySQL
Installing Mytop

wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
tar -zxvf mytop-1.6.tar.gz
perl Makefile.PL
make test
make install


* Perl
o Bundle::DBI
o Term::ReadKey
o Term::ANSIColor

Optional Perl module

* Time::HiRes

This optional module will give better resolution of stats (queries/second).

Mytop has started to break recently when upgrading from RHEL or CentOS 5.x to 5.3. It appears that some of the perl modules have changed

There error is:
Error in option spec: "long|!"

The fix for this is to edit the mytop script and comment out the line containing long|!
pico /usr/bin/mytop

Run a search for long|! and comment out the following line:
"long|!" => \$config{long_nums},
Start mytop and you should be fine!

 Posted by at 3:17 am

 Leave a Reply