[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
--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
让客户满意是我们工作的目标，不断超越客户的期望值来自于我们对这个行业的热爱。我们立志把好的技术通过有效、简单的方式提供给客户，将通过不懈努力成为客户在信息化领域值得信任、有价值的长期合作伙伴，公司提供的服务项目有：
主机域名、虚拟空间、营销软件、网站建设、
文昌网站维护、网站推广。
另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
本文题目：【MySQL】数据库监控工具--innotop-创新互联
网站网址：
http://www.cdkjz.cn/article/ddgegh.html
