innotop MySql tools.

Description:innotop monitors MySQL servers. Each of its modes shows you a different
aspect of what's happening in the server. For example, there's a mode for
monitoring replication, one for queries, and one for transac-tions.
innotop refreshes its data periodically, so you see an updating view.
innotop has lots of features for power users, but you can start and run it with virtually no configuration. If you're just getting started, see "QUICK-START". Press '?' at any time while running innotop for context-sensitive help.
How to install the innotop:
1. 下載 innotop 1.7
2. 解開，並執行
tar zxpf innotop-1.7.0.tar.gz
cd innotop-1.7.0
perl Makefile.PL
make
make install
3. 如果看到以下的message, 請到step 4
Warning: prerequisite Term::ReadKey 2.1 not found.
4. 安裝 perl 的相關套件，請執行以下指令，也請確保你的網路是通的..它需要下載套件下來安裝，並且gcc有安裝:
perl -MCPAN -eshell
install Term::ReadKey
install DBI
install DBD::mysql
5. 若沒有安裝default mysql package 會發現 install DBD::mysql 會失敗，這時請執行以下的方法安裝:

cd ~/.cpan/build/DBD-mysql-4.013

perl Makefile.PL --with-mysql=/opt/FlexMaster/3rdparty/mysql/mysql-enterprise-5.0.52-linux-x86_64-glibc23 --mysql_config=/opt/FlexMaster/3rdparty/mysql/mysql-enterprise-5.0.52-linux-x86_64-glibc23/bin/mysql_config

make
make test
make install

若是使用redhat 可以安裝rpm 檔
rpm -ivh perl-DBI-1.52-1.fc6.x86_64.rpm perl-DBD-MySQL-3.0007-1.fc6.x86_64.rpm mysql-5.0.22-2.1.x86_64.rpm
6. 若安裝完Step 4，請再執行Step2
7. 執行innotop
innotop --password admin --socket /opt/FlexMaster/3rdparty/mysql/mysql-enterprise-5.0.52-linux-x86_64-glibc23/mysql.sock

[root@localhost innotop-1.7.2]# innotop --password admin --socket /opt/FlexMaster/3rdparty/mysql/mysql-enterprise-5.0.52-linux-x86_64-glibc23/mysql.sock

http://crazytoon.com/2008/05/21/mysql-how-do-you-install-innotop-to-monitor-innodb-in-real-time/
http://crazytoon.com/2007/05/21/perl-how-do-i-install-perl-modules-eg-installing-lwp-module-for-perl/
http://www.lamp-tips.com/man-pages/innotop/