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
make install
Dependencies
* MySQL
* 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:
#mytop
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!
