数据源:PMM (192.168.8.52:8443) VictoriaMetrics 秒级采样,经 MCP (192.168.8.75:8200) 直连获取
生成时间:2026-09-22 02:11:11(数据快照 generated_at)
| 实例 | 问题 | 详情 |
|---|---|---|
| t591-dealhub (mynode) | 复制中断 replication_stopped | IO=False, SQL=True —— IO 线程已停,从主库拉取 binlog 中断,需尽快排查网络/认证/主库 binlog |
其余实例均 up,无实例下线。
复核说明:alerts 数组仅 1 条(t591-dealhub),按阈值扫描 data 复核未发现额外 warning。另观察项:t8-antifraud 缓冲池命中率 95.7%,为全场最低,暂未达告警口径,建议关注。
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|---|---|---|---|---|---|---|---|---|
| 100-master | 1 | 54.0 | 13/8192 (0.2%) | 5 | 9.04 | 0.00 | 100.0 | 0 | staging/100 |
| 8891-master | 1 | 529.9 | 30/2000 (1.5%) | 2 | 11.75 | 0.00 | 100.0 | - | staging/8891 |
| 8891-slave | 1 | 406.8 | 4/2000 (0.2%) | 1 | 4.36 | 0.00 | 99.9 | 0 | staging/8891-slave |
| TD-slave | 1 | 431.1 | 4/2048 (0.2%) | 2 | 4.32 | 0.00 | 99.8 | 0 | staging/TD-slave2 |
| TD-slave-51 | 1 | 431.1 | 4/2048 (0.2%) | 2 | 4.38 | 0.00 | 99.7 | 0 | staging/TD-slave |
| addcn-bee | 1 | 40.8 | 2/2048 (0.1%) | 2 | 5.42 | 0.00 | 100.0 | - | - |
| hk8591 | 1 | 187.7 | 9/15000 (0.1%) | 5 | 14.89 | 0.00 | 100.0 | 0 | staging/tw8591, staging/hk8591 |
| hk8591-slave | 1 | 411.9 | 5/15000 (0.0%) | 4 | 4.46 | 0.00 | 100.0 | 0 | staging/tw8591-slave, staging/hk8591-slave |
| hongyan | 1 | 21.8 | 4/2048 (0.2%) | 3 | 5.58 | 0.00 | 99.8 | - | - |
| mcdb-master | 1 | 105.5 | 24/4096 (0.6%) | 4 | 5.76 | 0.00 | 100.0 | 0 | staging/mcdb |
| mcdb-slave | 1 | 196.8 | 5/4096 (0.1%) | 4 | 4.27 | 0.00 | 100.0 | 0 | staging/tw591-slave, staging/mcdb-slave |
| t1_mysql | 1 | 54.0 | 12/9190 (0.1%) | 4 | 4.92 | 0.00 | 100.0 | 0 | staging/100-slave |
| t5-ai | 1 | 40.8 | 14/2048 (0.7%) | 3 | 4.80 | 0.00 | 100.0 | - | - |
| t5-gateway | 1 | 40.8 | 4/2048 (0.2%) | 2 | 4.55 | 0.00 | 100.0 | - | - |
| t591-dealhub | 1 | 40.8 | 4/2048 (0.2%) | 2 | 4.77 | 0.00 | 100.0 | IO中断 | - |
| t5_master | 1 | 45.6 | 1479/4096 (36.1%) | 16 | 2961.58 | 0.02 | 99.9 | - | - |
| t8-ai | 1 | 40.8 | 4/2048 (0.2%) | 3 | 4.77 | 0.00 | 100.0 | - | - |
| t8-antifraud | 1 | 21.8 | 50/2048 (2.4%) | 2 | 4.66 | 0.00 | 95.7 | - | - |
| t8_mysql | 1 | 73.6 | 114/15000 (0.8%) | 16 | 83.73 | 0.00 | 100.0 | 0 | staging/tw8591, staging/hk8591 |
| td_master | 1 | 682.0 | 74/2048 (3.6%) | 5 | 163.25 | 0.00 | 100.0 | - | staging/TD |
| tw591-slave | 1 | 431.1 | 5/2048 (0.2%) | 3 | 4.44 | 0.01 | 100.0 | 0 | staging/tw591-slave, staging/mcdb-slave |
| tw591-slave-lag | 1 | 287.8 | 4/2048 (0.2%) | 1 | 4.69 | 0.00 | 100.0 | 3600 ⚙️ | staging/tw591-slave2 |
| tw8591-slave | 1 | 412.2 | 5/15000 (0.0%) | 3 | 4.40 | 0.00 | 100.0 | 0 | staging/tw8591-slave, staging/hk8591-slave |
注:⚙️ tw591-slave-lag 延迟 3600s = sql_delay(设计如此),延迟从库;「-」表示无复制角色或该指标不适用。
数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:50。