| 实例 | 问题 | 详情 |
|---|---|---|
| t591-dealhub (mynode) | replication_stopped | 复制 IO 线程已停止：IO=False, SQL=True |
深挖链路：staging/t591-dealhub→ connect →show_slave_status/show_active_connections（本次巡检只读未执行）。
按阈值扫描 data（复制延迟>60s / 连接使用率≥80% / 慢查询≥1/s），alerts 之外的复核结果：
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|---|---|---|---|---|---|---|---|---|
| 100-master | ✅ | 91.9 | 80/8192 (1.0%) | 7 | 20.54 | 0 | 100.0 | 0 | staging/100 |
| 8891-master | ✅ | 567.9 | 19/2000 (0.9%) | 2 | 19.30 | 0 | 100.0 | - | staging/8891 |
| 8891-slave | ✅ | 444.8 | 3/2000 (0.1%) | 2 | 4.34 | 0 | 100.0 | 0 | staging/8891-slave |
| TD-slave | ✅ | 468.9 | 4/2048 (0.2%) | 3 | 4.33 | 0 | 99.8 | 0 | staging/TD-slave2 |
| TD-slave-51 | ✅ | 468.9 | 4/2048 (0.2%) | 3 | 4.39 | 0 | 99.8 | 0 | staging/TD-slave |
| addcn-bee | ✅ | 78.8 | 3/2048 (0.1%) | 2 | 5.50 | 0 | 100.0 | - | staging/addcn-bee |
| hk8591 | ✅ | 225.6 | 19/15000 (0.1%) | 7 | 13.86 | 0 | 100.0 | 0 | staging/hk8591 |
| hk8591-slave | ✅ | 449.7 | 5/15000 (0.0%) | 4 | 4.46 | 0 | 100.0 | 0 | staging/hk8591-slave |
| hongyan | ✅ | 59.8 | 4/2048 (0.2%) | 3 | 4.61 | 0 | 100.0 | - | staging/hongyan |
| mcdb-master | ✅ | 143.4 | 62/4096 (1.5%) | 4 | 25.85 | 0 | 100.0 | 0 | staging/mcdb |
| mcdb-slave | ✅ | 234.8 | 5/4096 (0.1%) | 5 | 4.57 | 0 | 100.0 | 0 | staging/mcdb-slave |
| t1_mysql | ✅ | 91.9 | 17/9190 (0.2%) | 4 | 5.43 | 0 | 100.0 | 0 | staging/100-slave |
| t5-ai | ✅ | 78.8 | 9/2048 (0.4%) | 4 | 4.79 | 0 | 100.0 | - | staging/t5-ai |
| t5-gateway | ✅ | 78.8 | 4/2048 (0.2%) | 2 | 4.56 | 0 | 100.0 | - | staging/t5-gateway |
| t591-dealhub | ✅ | 78.8 | 4/2048 (0.2%) | 2 | 4.77 | 0 | 100.0 | - (IO停) | staging/t591-dealhub |
| t8-ai | ✅ | 78.8 | 3/2048 (0.1%) | 3 | 4.78 | 0 | 100.0 | - | staging/t8-ai |
| t8-antifraud | ✅ | 22.0 | 44/2048 (2.1%) | 4 | 4.64 | 0 | 92.1 | - | staging/t8-antifraud |
| t8_mysql | ✅ | 111.6 | 288/15000 (1.9%) | 17 | 100.82 | 0 | 100.0 | 0 | staging/tw8591 |
| td_master | ✅ | 720.0 | 71/2048 (3.5%) | 6 | 153.50 | 0 | 99.9 | - | staging/TD |
| tw591-slave | ✅ | 468.9 | 3/2048 (0.1%) | 2 | 4.04 | 0 | 100.0 | - | staging/tw591-slave |
| tw591-slave-lag | ✅ | 22.0 | 4/2048 (0.2%) | 2 | 4.40 | 0 | 100.0 | 0 | staging/tw591-slave2 |
| tw8591-slave | ✅ | 449.7 | 5/15000 (0.0%) | 3 | 4.41 | 0 | 100.0 | 0 | staging/tw8591-slave |
注：tw591-slave-lag 为延迟从库（设计如此）；「-」表示该实例无复制角色（非从库）。另观察到 tw591-slave-lag 历史峰值连接 max_used=2049 已略超 max=2048，当前使用率仅 0.2%，暂不构成告警，可留意。
数据源 PMM(192.168.8.52:8443)，经 MCP(8.75:8200) 直连获取，下轮明日 09:50。