Mysql Database 性能监控工具： Innotop
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Mysql Database 性能监控工具： Innotop，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5271字，纯文字阅读大概需要8分钟。
内容图文
https://github.com/innotop/innotop [root@gscf01 ~]# yum -y install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-TermReadKey [root@gscf01 ~]# unzip innotop-master [root@gscf01 ~]# cd innotop-master [root@gscf01 innotop-master]# perl Makefile.PL [root@gscf01 innotop-master]#make [root@gscf01 innotop-master]#make install [root@gscf01 ~]# innotop --version innotop Ver 1.11.4 [root@gscf01 ~]# innotop --help Usage: innotop <options> <innodb-status-file> --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 innotop is a MySQL and InnoDB transaction/status monitor, like 'top' for MySQL. It displays queries, InnoDB transactions, lock waits, deadlocks, foreign key errors, open tables, replication status, buffer information, row operations, logs, I/O operations, load graph, and more. You can monitor many servers at once with innotop. [root@gscf01 ~]# innotop --user root --askpass --host 192.168.30.60 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 1000 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 1000 / 1000 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 Database 性能监控工具： Innotop全部内容，希望文章能够帮你解决Mysql Database 性能监控工具： Innotop所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】