Innotop (http://code.google.com/p/innotop/) has to be one of the best InnoDB monitoring I’ve become accustomed to while wearing a DBA hat. It allows you to get everything from what queries are currently running to the number of queries per second to monitoring deadlocks to even seeing the InnoDB I/O information. One of these days I plan on going fairly in-depth with the intricacies of monitoring with innotop, but as for today all you get is an installation guide with a quick breakdown of various errors and fixes during the install process.

Installation

$ curl -O http://innotop.googlecode.com/files/innotop-1.8.1.tar.gz
$ tar -zxvf innotop-1.8.1.tar.gz
$ cd innotop-1.8.1
$ perl Makefile.PL
$ make
$ make test
$ make install

Error Solutions

# Error
-bash: perl: command not found

# Fix
$ yum install perl

# Error
Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 1.
BEGIN failed--compilation aborted at Makefile.PL line 1.

# Fix
$ yum install cpan

# Error
Warning: prerequisite DBD::mysql 1 not found.
Warning: prerequisite DBI 1.13 not found.
Warning: prerequisite Term::ReadKey 2.1 not found.

# Fix
$ yum install perl-DBI perl-DBD-MySQL perl-TermReadKey

# Error
-bash: make: command not found

# Fix
$ yum install make

# Error (during $ make test)
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/InnoDBParser.t .. Can't locate Test/More.pm in @INC (@INC contains: /root/innotop-1.8.1/blib/lib /root/innotop-1.8.1/blib/arch /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at t/InnoDBParser.t line 5.
BEGIN failed--compilation aborted at t/InnoDBParser.t line 5.
t/InnoDBParser.t .. Dubious, test returned 2 (wstat 512, 0x200)
No subtests run

Test Summary Report
-------------------
t/InnoDBParser.t (Wstat: 512 Tests: 0 Failed: 0)
Non-zero exit status: 2
Parse errors: No plan found in TAP output
Files=1, Tests=0, 0 wallclock secs ( 0.02 usr 0.02 sys + 0.00 cusr 0.01 csys = 0.05 CPU)
Result: FAIL
Failed 1/1 test programs. 0/0 subt

# Fix
$ yum install yum install perl-Test*

# Error (during $ make test)
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/InnoDBParser.t .. Can't locate Time/HiRes.pm in @INC (@INC contains: /root/innotop-1.8.1/ /root/innotop-1.8.1/blib/lib /root/innotop-1.8.1/blib/arch /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /root/innotop-1.8.1//innotop line 1372.
BEGIN failed--compilation aborted at /root/innotop-1.8.1//innotop line 1372.
Compilation failed in require at t/InnoDBParser.t line 18.
# Looks like your test exited with 2 before it could output anything.
t/InnoDBParser.t .. Dubious, test returned 2 (wstat 512, 0x200)
Failed 3/3 subtests

Test Summary Report
-------------------
t/InnoDBParser.t (Wstat: 512 Tests: 0 Failed: 0)
Non-zero exit status: 2
Parse errors: Bad plan. You planned 3 tests but ran 0.
Files=1, Tests=0, 0 wallclock secs ( 0.01 usr 0.02 sys + 0.08 cusr 0.02 csys = 0.13 CPU)
Result: FAIL
Failed 1/1 test programs. 0/0 subtests failed.
make: *** [test_dynamic] Error 2

# Fix
$ yum install perl-Time-HiRes