【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.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-创新互联
标题URL：http://scyanting.com/article/ddgegh.html
