[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
本文标题:【MySQL】数据库监控工具--innotop
URL地址:
http://cxhlcq.com/article/jeiedd.html