innotop是一个通过文本模式显示MySQL和InnoDB存储引擎的监测工具。innotop是用perl语言开发，这是它能更加灵活的使用在各种操作平台之上，它能详细的的监控出当前mysql和innodb存储引擎运行的状态，以便维护人员根据结果合理的优化数据库，让数据库更稳定更高效的运行，innotop依赖于系统的perl-ExtUtils-MakeMaker软件包。
1.安装perl依赖包
[root@linuxidc ~]# yum install perl-ExtUtils-MakeMaker
[root@linuxidc ~]# rpm -aq | grep perl-ExtUtils-MakeMaker
perl-ExtUtils-MakeMaker-6.55-136.el6_6.1.x86_64
[root@linuxidc ~]#
2.下载安装innotop监控工具
[root@linuxidc ~]# wget http://innotop.googlecode.com/files/innotop-1.9.0.tar.gz
[root@linuxidc ~]# tar xvf innotop-1.9.0.tar.gz -C /usr/local/
[root@linuxidc ~]# cd /usr/local/innotop-1.9.0/
[root@linuxidc innotop-1.9.0]# perl Makefile.PL
Checking if your kit is complete...
Looks good
Writing Makefile for innotop
[root@linuxidc innotop-1.9.0]# make install
cp innotop blib/script/innotop
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/innotop
Manifying blib/man1/innotop.1
Installing /usr/local/share/man/man1/innotop.1
Installing /usr/local/bin/innotop
Appending installation info to /usr/lib64/perl5/perllocal.pod
[root@linuxidc innotop-1.9.0]# echo $?
0
[root@linuxidc innotop-1.9.0]#
?
3.innotop使用帮助和监控实例
[root@linuxidc innotop-1.9.0]# ./innotop? --help
Usage: innotop
? --[no]color? -C? Use terminal coloring (default)
? --config? ? ? -c? Config file to read
? --count? ? ? ? ? ? Number of updates before exiting
? --delay? ? ? -d? Delay between updates in seconds
? --help? ? ? ? ? ? Show this help message
? --host? ? ? ? -h? Connect to host
? --[no]inc? ? -i? Measure incremental differences
? --mode? ? ? ? -m? Operating mode to start in
? --nonint? ? ? -n? Non-interactive, output tab-separated fields
? --password? ? -p? Password to use for connection
? --port? ? ? ? -P? Port number to use for connection
? --skipcentral -s? Skip reading the central configuration file
? --socket? ? ? -S? MySQL socket to use for connection
? --spark? ? ? ? ? ? Length of status sparkline (default 10)
? --timestamp? -t? Print timestamp in -n mode (1: per iter; 2: per line)
? --user? ? ? ? -u? User for login if not current user
? --version? ? ? ? ? Output version information and exit
? --write? ? ? -w? Write running configuration into home directory if no config files were loaded
innotop is a MySQL and InnoDB transaction/status monitor, like 'top' for
MySQL.? It displays queries, InnoDB transactions, lock waits, deadlocks,
foreign key errors, open tables, replication status, buffer information,
row operations, logs, I/O operations, load graph, and more.? You can
monitor many servers at once with innotop.
[root@linuxidc innotop-1.9.0]# ./innotop? -u root -psystem -h localhost -S /tmp/mysql.sock
[RO] Dashboard (? for? ? ? ? help)? ? ? ? ? ? --输入?或htlp查看帮助信息
Uptime? MaxSQL? ReplLag? Cxns? Lock? QPS? QPS? Run? Run? Tbls? Repl? SQL
? ? 6d? ? ? ? ? ? ? ? ? ? ? 1? ? 0? 0.40? ^_____? _____? 551? Off? ? ?
? ?
输入?号可看帮助信息
Switch to a different mode:
? A? Dashboard? ? ? ? I? InnoDB I/O Info? ? Q? Query List
? B? InnoDB Buffers? ? K? InnoDB Lock Waits? R? InnoDB Row Ops
? C? Command Summary? L? Locks? ? ? ? ? ? ? S? Variables & Status
? D? InnoDB Deadlocks? M? Replication Status? T? InnoDB Txns
? F? InnoDB FK Err? ? O? Open Tables? ? ? ? U? User Statistics
Actions:
? d? Change refresh interval? ? ? ? p? Pause innotop
? k? Kill a query's connection? ? ? q? Quit innotop
? n? Switch to the next connection? x? Kill a query
Other:
?TAB? Switch to the next server group? /? Quickly filter what you see
? !? Show license and warranty? ? ? ? =? Toggle aggregation
? #? Select/create server groups? ? ? @? Select/