[root@wallet04 ~]# yum -y install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-TermReadKey [root@wallet04 ~]# git clone https://github.com/innotop/innotop.git Initialized empty Git repository in /root/innotop/.git/ remote: Enumerating objects: 621, done. remote: Total 621 (delta 0), reused 0 (delta 0), pack-reused 621 Receiving objects: 100% (621/621), 1.17 MiB | 230 KiB/s, done. Resolving deltas: 100% (382/382), done. [root@wallet04 ~]# cd innotop [root@wallet04 innotop]# perl Makefile.PL [root@wallet04 innotop]#make [root@wallet04 innotop]#make install [root@wallet04 ~]# innotop --version innotop Ver 1.11.4 [root@wallet04 ~]# innotop --help Usage: innotop <options> <innodb-status-file> --askpass Prompt for a password when connecting to MySQL --[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 [root@wallet04 ~]# innotop --user root --askpass --host 192.168.1.201 Enter password : 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 i Toggle incremental status display q Quit innotop n Switch to the next connection 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 Q Query List When Load Cxns QPS Slow Se/In/Up/De% QCacheHit KCacheHit BpsIn BpsOut Now 0.02 29 365.11 0 97/ 0/ 0/ 0 0.00% 100.00% 297.38k 1.59M Total 0.00 100 13.98 28 69/ 7/ 6/ 0 0.00% 99.99% 4.06k 23.66k Cmd ID State User Host DB Time Query B InnoDB Buffers _____________________________ Buffer Pool _____________________________ Size Free Bufs Pages Dirty Pages Hit Rate Memory Add'l Pool 256.00k 179732 78992 0 100 / 100 4.09G 0 ____________________ Page Statistics _____________________ Reads Writes Created Reads/Sec Writes/Sec Creates/Sec 73859 922096 6753 0.00 0.00 0.00 ______________________ Insert Buffers ______________________ Inserts Merged Recs Merges Size Free List Len Seg. Size 0 0 1 1811 1813 __________________ Adaptive Hash Index __________________ Size Cells Used Node Heap Bufs Hash/Sec Non-Hash/Sec 8.44M 3418 0.50 0.00 I InnoDB I/O Info _________________________ I/O Threads __________________________ Thread Purpose Thread Status 0 insert buffer thread waiting for completed aio requests 1 log thread waiting for completed aio requests 2 read thread waiting for completed aio requests 3 read thread waiting for completed aio requests 4 read thread waiting for completed aio requests 5 read thread waiting for completed aio requests 6 write thread waiting for completed aio requests 7 write thread waiting for completed aio requests 8 write thread waiting for completed aio requests 9 write thread waiting for completed aio requests ____________________________ Pending I/O _____________________________ Async Rds Async Wrt IBuf Async Rds Sync I/Os Log Flushes Log I/Os 0 0 0 0 ________________________ File I/O Misc _________________________ OS Reads OS Writes OS fsyncs Reads/Sec Writes/Sec Bytes/Sec 74180 2867756 2094872 0.00 0.00 0 _____________________ Log Statistics ______________________ Sequence No. Flushed To Last Checkpoint IO Done IO/Sec 75091882485 75091882485 75091882485 1829529 0.00
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
