pmm_status 直连获取无
tw591-slave-lag seconds_behind_master=3600s —— 延迟从库(设计如此)(sql_delay=3600,PMM 侧未产生 alert,符合预期)。其余从库延迟均 ≤1s。补充观察(非阈值项):t8-antifraud BP 命中率 92.3%、uptime 仅约 3 天(近期重启过),其余实例 BP 命中率 ≥99.6%。
PMM alerts 数组为空,且按阈值全量扫描 data 后仅发现上述设计内延迟从库,无真实告警。
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|---|---|---|---|---|---|---|---|---|
| 100-master | ✅ | 35.1 | 18/8192 (0.2%) | 6 | 10.22 | 0 | 100.0 | 0 | staging/100 |
| 8891-master | ✅ | 511.1 | 16/2000 (0.8%) | 3 | 5.46 | 0.01 | 100.0 | - | staging/8891 |
| 8891-slave | ✅ | 388.0 | 4/2000 (0.2%) | 1 | 4.36 | 0 | 100.0 | 0 | staging/8891-slave |
| TD-slave | ✅ | 412.1 | 4/2048 (0.2%) | 2 | 4.03 | 0 | 99.9 | 0 | staging/TD-slave2 |
| TD-slave-51 | ✅ | 412.1 | 4/2048 (0.2%) | 2 | 4.30 | 0 | 99.9 | 0 | staging/TD-slave |
| addcn-bee | ✅ | 21.9 | 3/2048 (0.1%) | 2 | 5.73 | 0 | 100.0 | - | staging/addcn-bee |
| hk8591 | ✅ | 168.8 | 7/15000 (0.0%) | 5 | 8.93 | 0 | 100.0 | 0 | staging/hk8591 |
| hk8591-slave | ✅ | 392.9 | 5/15000 (0.0%) | 5 | 4.46 | 0 | 100.0 | 0 | staging/hk8591-slave |
| hongyan | ✅ | 3.0 | 4/2048 (0.2%) | 3 | 5.01 | 0 | 100.0 | - | staging/hongyan |
| mcdb-master | ✅ | 86.6 | 20/4096 (0.5%) | 5 | 5.38 | 0 | 100.0 | 0 | staging/mcdb |
| mcdb-slave | ✅ | 177.9 | 5/4096 (0.1%) | 5 | 4.27 | 0 | 100.0 | 0 | staging/mcdb-slave |
| t1_mysql | ✅ | 35.1 | 13/9190 (0.1%) | 4 | 5.81 | 0 | 100.0 | 0 | staging/100-slave |
| t5-ai | ✅ | 21.9 | 9/2048 (0.4%) | 3 | 4.79 | 0 | 100.0 | - | staging/t5-ai |
| t5-gateway | ✅ | 21.9 | 3/2048 (0.1%) | 2 | 4.57 | 0 | 100.0 | - | staging/t5-gateway |
| t591-dealhub | ✅ | 21.9 | 4/2048 (0.2%) | 2 | 4.82 | 0 | 100.0 | 0 | staging/t591-dealhub |
| t5_master | ✅ | 26.8 | 647/4096 (15.8%) | 15 | 2970.33 | 0 | 99.6 | - | staging/tw591 |
| t8-ai | ✅ | 21.9 | 4/2048 (0.2%) | 3 | 4.77 | 0 | 100.0 | - | staging/t8-ai |
| t8-antifraud | ✅ | 3.0 | 53/2048 (2.6%) | 3 | 4.64 | 0 | 92.3 | - | staging/t8-antifraud |
| t8_mysql | ✅ | 54.8 | 186/15000 (1.2%) | 14 | 134.28 | 0.01 | 100.0 | 0 | staging/tw8591 |
| td_master | ✅ | 663.1 | 52/2048 (2.5%) | 5 | 157.24 | 0 | 100.0 | - | staging/TD |
| tw591-slave | ✅ | 412.1 | 4/2048 (0.2%) | 3 | 4.53 | 0 | 100.0 | 0 | staging/tw591-slave |
| tw591-slave-lag | ✅ | 269.0 | 4/2048 (0.2%) | 2 | 4.64 | 0 | 100.0 | 3600 ⚠️(延迟从库,设计如此) | staging/tw591-slave2 |
| tw8591-slave | ✅ | 393.1 | 5/15000 (0.0%) | 3 | 4.43 | 0 | 100.0 | 1 | staging/tw8591-slave |
注:「-」表示该实例无复制(主库/单机);复制延迟为 seconds_behind_master。
数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:00。