目次

innotop

Download

https://code.google.com/archive/p/innotop/
― Download
―― innotop-1.9.1-1.el6.noarch.rpm
※CentOS6 + MySQL 5.6までなら、上記からDLできるrpmで動作可能。

https://github.com/innotop/innotop
※MySQL5.7など、最新版は上記からDLしてインストール

Install

# git clone https://github.com/innotop/innotop.git
# cd innotop
# yum install perl-DBI
# yum install perl-DBD-mysql
# yum install perl-ExtUtils-MakeMaker
# yum install perl-Time-HiRes
# yum install perl-TermReadKey
# perl Makefile.PL
# make install

実行

# innotop

Enter password for 'root' on localhost:

Help

Command Summary (? for help) localhost, 1h5m, 3.40 QPS, 4/1/1 con/run/cac thds, 5.7.12-log

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        q  Quit innotop
   n  Switch to the next connection  s  Choose variable prefix
   p  Pause innotop                  

Other:
 TAB  Switch to the next server group   /  Quickly filter what you see
   !  Show license and warranty         =  Toggle aggregation
   #  Select/create server groups       @  Select/create server connections
   $  Edit configuration settings       \  Clear quick-filters
Press any key to continue