| 指标 | 值 |
|---|---|
| 实例总数 | 22 |
| up 数 | 22 |
| alert 数 | 1(critical × 1) |
| 实例 | 问题 | 详情 |
|---|---|---|
| t591-dealhub | 复制中断 (replication_stopped) | IO=False, SQL=True —— IO 线程已停止,SQL 线程仍在运行,复制日志拉取中断,需尽快处理(深挖链路:matched_alias staging/t591-dealhub → connect → show_slave_status / show_active_connections) |
按阈值复核 data 全量扫描结果:
注:tw591-slave-lag(192.168.8.189)为延迟从库(设计如此),当前 sql_delay=0、seconds_behind_master=0,无异常。
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|---|---|---|---|---|---|---|---|---|
| 100-master | ✅ | 81.9 | 26/8192(0.3%) | 6 | 47.99 | 0 | 99.9 | 0 | staging/100 |
| 8891-master | ✅ | 557.9 | 15/2000(0.8%) | 3 | 10.13 | 0 | 100.0 | — | staging/8891 |
| 8891-slave | ✅ | 434.8 | 3/2000(0.1%) | 1 | 4.08 | 0 | 100.0 | 0 | staging/8891-slave |
| TD-slave | ✅ | 458.9 | 4/2048(0.2%) | 4 | 4.04 | 0 | 99.8 | 0 | staging/TD-slave2 |
| TD-slave-51 | ✅ | 458.9 | 3/2048(0.1%) | 3 | 4.14 | 0 | 99.8 | 0 | staging/TD-slave |
| addcn-bee | ✅ | 68.8 | 2/2048(0.1%) | 2 | 5.72 | 0 | 100.0 | — | staging/addcn-bee |
| hk8591 | ✅ | 215.6 | 7/15000(0.0%) | 5 | 12.40 | 0 | 100.0 | 0 | staging/hk8591 |
| hk8591-slave | ✅ | 439.7 | 5/15000(0.0%) | 4 | 4.73 | 0 | 100.0 | 0 | staging/hk8591-slave |
| hongyan | ✅ | 49.8 | 13/2048(0.6%) | 3 | 4.99 | 0 | 100.0 | — | staging/hongyan |
| mcdb-master | ✅ | 133.4 | 40/4096(1.0%) | 4 | 12.17 | 0 | 100.0 | 0 | staging/mcdb |
| mcdb-slave | ✅ | 224.8 | 5/4096(0.1%) | 4 | 4.58 | 0.01 | 100.0 | 0 | staging/mcdb-slave |
| t1_mysql | ✅ | 81.9 | 12/9190(0.1%) | 4 | 10.63 | 0 | 99.6 | 0 | staging/100-slave |
| t5-ai | ✅ | 68.8 | 9/2048(0.4%) | 3 | 4.95 | 0 | 100.0 | — | staging/t5-ai |
| t5-gateway | ✅ | 68.8 | 5/2048(0.2%) | 2 | 4.55 | 0 | 100.0 | — | staging/t5-gateway |
| t591-dealhub | ✅ | 68.8 | 4/2048(0.2%) | 2 | 4.76 | 0 | 100.0 | 0 ⚠️IO停 | staging/t591-dealhub |
| t8-ai | ✅ | 68.8 | 4/2048(0.2%) | 3 | 4.77 | 0 | 100.0 | — | staging/t8-ai |
| t8-antifraud | ✅ | 12.0 | 53/2048(2.6%) | 3 | 4.78 | 0 | 90.0 | — | staging/t8-antifraud |
| t8_mysql | ✅ | 101.6 | 182/15000(1.2%) | 17 | 53.00 | 0.01 | 100.0 | 0 | staging/tw8591 |
| td_master | ✅ | 710.0 | 88/2048(4.3%) | 5 | 155.93 | 0 | 100.0 | — | staging/TD |
| tw591-slave | ✅ | 458.9 | 5/2048(0.2%) | 3 | 3.88 | 0 | 100.0 | — | staging/tw591-slave |
| tw591-slave-lag | ✅ | 12.0 | 4/2048(0.2%) | 2 | 4.41 | 0 | 100.0 | 0(延迟从库,设计如此) | staging/tw591-slave2 |
| tw8591-slave | ✅ | 439.7 | 5/15000(0.0%) | 3 | 4.18 | 0 | 99.8 | 0 | staging/tw8591-slave |
其余 warning 项:无(t8-antifraud BP 命中率 90.0% 偏低,但未达告警阈值,建议关注)。
数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:50。