【MySQL】数据库监控工具--innotop
发表于:2024-11-30 作者:千家信息网编辑
千家信息网最后更新 2024年11月30日,[root@wallet04 ~]# yum -y install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-TermReadKey[root@wall
千家信息网最后更新 2024年11月30日【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
工具
数据
数据库
监控
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
网站服务器公司
动漫制作和软件开发
数据库调优方法
局域网 ftp服务器
双十一云服务器图片
数据库全局分区索引
数据库现今发展状况
郑州我游网络技术
创造软件开发环境
吉林太阳线软件开发价格
吉林祥云网络技术公司
软件开发首付款多少
行政单位软件开发保密协议
阿里服务器设备价值
国外学者网络技术的发展历史
海淀区正规软件开发差异
我的世界租借服务器能开模组么
微众银行软件开发工资
网络安全吗骁睿
nature数据库网址
网络安全测试众测平台有哪些
育碧服务器现在如何
网络安全专员总结
网络技术规范采用哪两种协议
数据库全局分区索引
<网络安全法>解读
数据库的定义及意义
asp提交数据库代码怎么写
学校网络安全责任
数据库的安全性保护