PMM MySQL 巡检日报 2026-09-03

概览

Critical(实例 down / 复制中断)

无

Warning(按阈值扫描 data 复核)

补充观察(非阈值项):t8-antifraud BP 命中率 92.3%、uptime 仅约 3 天(近期重启过),其余实例 BP 命中率 ≥99.6%。

✅ 无告警

PMM alerts 数组为空,且按阈值全量扫描 data 后仅发现上述设计内延迟从库,无真实告警。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master✅35.118/8192 (0.2%)610.220100.00staging/100
8891-master✅511.116/2000 (0.8%)35.460.01100.0-staging/8891
8891-slave✅388.04/2000 (0.2%)14.360100.00staging/8891-slave
TD-slave✅412.14/2048 (0.2%)24.03099.90staging/TD-slave2
TD-slave-51✅412.14/2048 (0.2%)24.30099.90staging/TD-slave
addcn-bee✅21.93/2048 (0.1%)25.730100.0-staging/addcn-bee
hk8591✅168.87/15000 (0.0%)58.930100.00staging/hk8591
hk8591-slave✅392.95/15000 (0.0%)54.460100.00staging/hk8591-slave
hongyan✅3.04/2048 (0.2%)35.010100.0-staging/hongyan
mcdb-master✅86.620/4096 (0.5%)55.380100.00staging/mcdb
mcdb-slave✅177.95/4096 (0.1%)54.270100.00staging/mcdb-slave
t1_mysql✅35.113/9190 (0.1%)45.810100.00staging/100-slave
t5-ai✅21.99/2048 (0.4%)34.790100.0-staging/t5-ai
t5-gateway✅21.93/2048 (0.1%)24.570100.0-staging/t5-gateway
t591-dealhub✅21.94/2048 (0.2%)24.820100.00staging/t591-dealhub
t5_master✅26.8647/4096 (15.8%)152970.33099.6-staging/tw591
t8-ai✅21.94/2048 (0.2%)34.770100.0-staging/t8-ai
t8-antifraud✅3.053/2048 (2.6%)34.64092.3-staging/t8-antifraud
t8_mysql✅54.8186/15000 (1.2%)14134.280.01100.00staging/tw8591
td_master✅663.152/2048 (2.5%)5157.240100.0-staging/TD
tw591-slave✅412.14/2048 (0.2%)34.530100.00staging/tw591-slave
tw591-slave-lag✅269.04/2048 (0.2%)24.640100.03600 ⚠️(延迟从库,设计如此)staging/tw591-slave2
tw8591-slave✅393.15/15000 (0.0%)34.430100.01staging/tw8591-slave

注:「-」表示该实例无复制(主库/单机);复制延迟为 seconds_behind_master。

QPS Top 3

  1. t5_master (staging/tw591):2970.33 qps,threads_running=15,连接使用率 15.8%
  2. td_master (staging/TD):157.24 qps
  3. t8_mysql (staging/tw8591):134.28 qps,threads_running=14

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