pmm_status 直连获取| 实例总数 | up | alert |
|---|---|---|
| 22 | 22 | 1 |
| 实例 | 问题 | 详情 |
|---|---|---|
| t591-dealhub | replication_stopped | IO=False, SQL=True(IO 线程停止,复制中断,数据不再从主库同步) |
无(阈值扫描复核:复制延迟最高 7s(hk8591-slave / mcdb-slave / tw8591-slave,<60s);连接使用率最高 3.0%(td_master);慢查询最高 0.01/s(100-master、t8_mysql),均未触发阈值)。
延迟从库说明:本快照中无 sql_delay>0 实例;tw591-slave-lag 为设计延迟从库,当前 seconds_behind_master=0。
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|---|---|---|---|---|---|---|---|---|
| 100-master | 1 | 89.9 | 20/8192 (0.2%) | 6 | 9.37 | 0.01 | 100.0 | 0 | staging/100 |
| 8891-master | 1 | 566.1 | 19/2000 (0.9%) | 3 | 14.03 | 0.00 | 100.0 | - | staging/8891 |
| 8891-slave | 1 | 442.8 | 4/2000 (0.2%) | 2 | 4.33 | 0.00 | 100.0 | 0 | staging/8891-slave |
| TD-slave | 1 | 466.9 | 4/2048 (0.2%) | 2 | 4.32 | 0.00 | 99.7 | 0 | staging/TD-slave2 |
| TD-slave-51 | 1 | 466.9 | 4/2048 (0.2%) | 3 | 4.39 | 0.00 | 99.6 | 0 | staging/TD-slave |
| addcn-bee | 1 | 76.8 | 3/2048 (0.1%) | 2 | 6.17 | 0.00 | 100.0 | - | staging/addcn-bee |
| hk8591 | 1 | 223.6 | 13/15000 (0.1%) | 5 | 17.30 | 0.00 | 100.0 | 0 | staging/hk8591 |
| hk8591-slave | 1 | 447.4 | 5/15000 (0.0%) | 4 | 4.47 | 0.00 | 100.0 | 2 | staging/hk8591-slave |
| hongyan | 1 | 57.8 | 7/2048 (0.3%) | 3 | 4.88 | 0.00 | 100.0 | - | staging/hongyan |
| mcdb-master | 1 | 141.4 | 41/4096 (1.0%) | 5 | 24.10 | 0.00 | 100.0 | 0 | staging/mcdb |
| mcdb-slave | 1 | 232.8 | 5/4096 (0.1%) | 3 | 4.57 | 0.00 | 100.0 | 7 | staging/mcdb-slave |
| t1_mysql | 1 | 89.9 | 14/9190 (0.2%) | 4 | 4.98 | 0.00 | 100.0 | 0 | staging/100-slave |
| t5-ai | 1 | 76.8 | 9/2048 (0.4%) | 4 | 4.78 | 0.00 | 100.0 | - | staging/t5-ai |
| t5-gateway | 1 | 76.8 | 6/2048 (0.3%) | 2 | 4.55 | 0.00 | 100.0 | - | staging/t5-gateway |
| t591-dealhub | 1 | 76.8 | 4/2048 (0.2%) | 2 | 4.77 | 0.00 | 100.0 | 0* | staging/t591-dealhub |
| t8-ai | 1 | 76.8 | 3/2048 (0.1%) | 3 | 4.77 | 0.00 | 100.0 | - | staging/t8-ai |
| t8-antifraud | 1 | 20.0 | 45/2048 (2.2%) | 3 | 4.67 | 0.00 | 92.8 | - | staging/t8-antifraud |
| t8_mysql | 1 | 109.6 | 249/15000 (1.7%) | 17 | 108.98 | 0.01 | 100.0 | 0 | staging/tw8591 |
| td_master | 1 | 718.0 | 61/2048 (3.0%) | 5 | 145.45 | 0.00 | 100.0 | - | staging/TD |
| tw591-slave | 1 | 466.9 | 4/2048 (0.2%) | 4 | 4.04 | 0.00 | 100.0 | - | staging/tw591-slave |
| tw591-slave-lag | 1 | 20.0 | 3/2048 (0.1%) | 2 | 4.40 | 0.00 | 99.9 | 0 | staging/tw591-slave2(延迟从库,设计如此) |
| tw8591-slave | 1 | 447.5 | 5/15000 (0.0%) | 3 | 4.40 | 0.00 | 99.9 | 7 | staging/tw8591-slave |
注:t591-dealhub 标 0* —— IO 线程已停止,seconds_behind_master 不再增长但复制实际中断;「-」表示无复制上下文(主库/单机)。t8-antifraud BP 命中率 92.8% 偏低(重启约 20 天,属缓冲池预热阶段,暂观察)。
数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:50。