Mysql监控工具小集合
时间:2022-03-14 02:22
mytop
- 类似Linux系统的top命令,专门监控Mysql的运行状态
-
监控命令:
1 mytop --host=10.20.192.109 --dbuser=root --password=123456
运行结果:1 MySQL on 10.20.192.109 (5.0.81) up 0+00:15:03 [11:51:51] 2 Queries: 35.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 00/00/00/00 qps now: 0 Slow qps: 0.0 Threads: 52 3 Key Efficiency: 96.4% Bps in/out: 0.9/114.1 Now in/out: 8.4/ 1.2k 4 Id User Host/IP DB Time Cmd Query or State 5 -- ---- ------- -- ---- --- ---------- 6 67 root vmvistcn261sp1u 0 Query show full processlist 7 6 root vmxpcn270sp2 36 Sleep 8 ……
mtop
- 类似Linux系统的top命令,专门监控Mysql的运行状态
-
监控命令:
1 mtop --host=10.20.192.109 --dbuser=root --password=123456
运行结果:1 10.20.192.109 mysqld 5.0.81 up 0 day(s), 0:05 hrs 2 52 threads: 1 running, 0 cached. Queries/slow: 5/0 Cache Hit: 100.00% 3 Opened tables: 0 RRN: 459 TLW: 0 SFJ: 0 SMP: 0 QPS: 0 4 ID USER HOST DB TIME COMMAND STATE INFO 5 28 root 10.20.212.39:522 Query show full processlist 6 ……
其它
- 相关工具还有:
- kontrollbase,始终没装起来;
- mycat,装上去居然不知怎样用。