====== 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