Shulou(Shulou.com)06/01 Report--

[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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.