【MySQL】数据库监控工具--innotop

[root@wallet04 ~]# yum -y install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-TermReadKey[root@wallet04 ~]# git clone https://github.com/innotop/innotop.gitInitialized empty Git repository in /root/innotop/.git/remote: Enumerating objects: 621, done.remote: Total 621 (delta 0), reused 0 (delta 0), pack-reused 621Receiving 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 --versioninnotop  Ver 1.11.4[root@wallet04 ~]# innotop --helpUsage: 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 StatisticsActions:   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-filtersPress any key to continueQ Query ListWhen   Load  Cxns  QPS     Slow  Se/In/Up/De%  QCacheHit  KCacheHit  BpsIn    BpsOutNow    0.02    29  365.11     0  97/ 0/ 0/ 0       0.00%    100.00%  297.38k   1.59MTotal  0.00  100   13.98    28  69/ 7/ 6/ 0       0.00%     99.99%    4.06k  23.66kCmd    ID      State  User   Host     DB      Time   QueryB InnoDB Buffers_____________________________ Buffer Pool _____________________________Size     Free Bufs  Pages  Dirty Pages  Hit Rate     Memory  Add'l Pool256.00k     179732  78992            0  100 / 100   4.09G           0____________________ Page Statistics _____________________Reads  Writes  Created  Reads/Sec  Writes/Sec  Creates/Sec73859  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/Sec8.44M                        3418      0.50          0.00I 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/Sec75091882485   75091882485  75091882485      1829529    0.00