📋 目录概览CriticalWarning全实例明细QPS Top 3告警状态小结

PMM MySQL 巡检日报 2026-09-20

概览

实例总数up 数alert 数
23231

Critical

实例问题详情
t591-dealhub复制中断 (replication_stopped)IO=False, SQL=True(IO 线程已停止,中继日志仍在回放;待 IO=False 恢复或数据不再增长需人工确认)

Warning

按阈值复核全部 23 实例 data(延迟>60s、连接使用率≥80%、慢查询≥1/s):

结论:除 1 条 critical 外,无 warning 级问题。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master151.917/8192(0.2%)59.080.01100.00staging/100
8891-master1527.916/2000(0.8%)25.820.00100.0-staging/8891
8891-slave1404.84/2000(0.2%)24.360.00100.00staging/8891-slave
TD-slave1428.94/2048(0.2%)34.330.0099.80staging/TD-slave2
TD-slave-511428.94/2048(0.2%)34.400.0099.80staging/TD-slave
addcn-bee138.83/2048(0.1%)25.610.00100.0-(无匹配)
hk85911185.616/15000(0.1%)713.150.0099.90staging/tw8591, staging/hk8591
hk8591-slave1409.75/15000(0.0%)44.470.00100.02staging/tw8591-slave, staging/hk8591-slave
hongyan119.85/2048(0.2%)35.070.0099.6-(无匹配)
mcdb-master1103.420/4096(0.5%)46.840.0099.90staging/mcdb
mcdb-slave1194.85/4096(0.1%)44.270.00100.06staging/tw591-slave, staging/mcdb-slave
t1_mysql151.915/9190(0.2%)44.930.00100.00staging/100-slave
t5-ai138.89/2048(0.4%)34.780.00100.0-(无匹配)
t5-gateway138.83/2048(0.1%)24.560.00100.0-(无匹配)
t591-dealhub138.84/2048(0.2%)24.780.00100.00 (IO=False)(无匹配)
t5_master143.6608/4096(14.8%)182739.570.0399.8-(无匹配)
t8-ai138.84/2048(0.2%)34.770.00100.0-(无匹配)
t8-antifraud119.847/2048(2.3%)34.690.0091.7-(无匹配)
t8_mysql171.6162/15000(1.1%)1794.060.00100.00staging/tw8591, staging/hk8591
td_master1679.561/2048(3.0%)5165.540.00100.0-staging/TD
tw591-slave1428.94/2048(0.2%)34.410.00100.00staging/tw591-slave, staging/mcdb-slave
tw591-slave-lag1285.84/2048(0.2%)24.620.00100.03601(延迟从库,设计如此)staging/tw591-slave2
tw8591-slave1410.05/15000(0.0%)34.430.00100.06staging/tw8591-slave, staging/hk8591-slave

注:复制延迟为 - 表示非从库(replication 为空);t591-slave 相关双别名因同机多实例共享节点。

QPS Top 3

排名实例QPSthreads_running连接使用率
1t5_master2739.571814.8%
2td_master165.5453.0%
3t8_mysql94.06171.1%

告警状态小结

⚠️ 1 条 critical(t591-dealhub 复制 IO 线程停止);无 warning 级新增问题(tw591-slave-lag 1 小时延迟为设计行为)。


数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:50。