| 实例总数 | up 数 | alert 数 |
|---|---|---|
| 23 | 23 | 1 |
| 实例 | 问题 | 详情 |
|---|---|---|
| t591-dealhub | 复制中断 (replication_stopped) | IO=False, SQL=True(IO 线程已停止,中继日志仍在回放;待 IO=False 恢复或数据不再增长需人工确认) |
按阈值复核全部 23 实例 data(延迟>60s、连接使用率≥80%、慢查询≥1/s):
结论:除 1 条 critical 外,无 warning 级问题。
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|---|---|---|---|---|---|---|---|---|
| 100-master | 1 | 51.9 | 17/8192(0.2%) | 5 | 9.08 | 0.01 | 100.0 | 0 | staging/100 |
| 8891-master | 1 | 527.9 | 16/2000(0.8%) | 2 | 5.82 | 0.00 | 100.0 | - | staging/8891 |
| 8891-slave | 1 | 404.8 | 4/2000(0.2%) | 2 | 4.36 | 0.00 | 100.0 | 0 | staging/8891-slave |
| TD-slave | 1 | 428.9 | 4/2048(0.2%) | 3 | 4.33 | 0.00 | 99.8 | 0 | staging/TD-slave2 |
| TD-slave-51 | 1 | 428.9 | 4/2048(0.2%) | 3 | 4.40 | 0.00 | 99.8 | 0 | staging/TD-slave |
| addcn-bee | 1 | 38.8 | 3/2048(0.1%) | 2 | 5.61 | 0.00 | 100.0 | - | (无匹配) |
| hk8591 | 1 | 185.6 | 16/15000(0.1%) | 7 | 13.15 | 0.00 | 99.9 | 0 | staging/tw8591, staging/hk8591 |
| hk8591-slave | 1 | 409.7 | 5/15000(0.0%) | 4 | 4.47 | 0.00 | 100.0 | 2 | staging/tw8591-slave, staging/hk8591-slave |
| hongyan | 1 | 19.8 | 5/2048(0.2%) | 3 | 5.07 | 0.00 | 99.6 | - | (无匹配) |
| mcdb-master | 1 | 103.4 | 20/4096(0.5%) | 4 | 6.84 | 0.00 | 99.9 | 0 | staging/mcdb |
| mcdb-slave | 1 | 194.8 | 5/4096(0.1%) | 4 | 4.27 | 0.00 | 100.0 | 6 | staging/tw591-slave, staging/mcdb-slave |
| t1_mysql | 1 | 51.9 | 15/9190(0.2%) | 4 | 4.93 | 0.00 | 100.0 | 0 | staging/100-slave |
| t5-ai | 1 | 38.8 | 9/2048(0.4%) | 3 | 4.78 | 0.00 | 100.0 | - | (无匹配) |
| t5-gateway | 1 | 38.8 | 3/2048(0.1%) | 2 | 4.56 | 0.00 | 100.0 | - | (无匹配) |
| t591-dealhub | 1 | 38.8 | 4/2048(0.2%) | 2 | 4.78 | 0.00 | 100.0 | 0 (IO=False) | (无匹配) |
| t5_master | 1 | 43.6 | 608/4096(14.8%) | 18 | 2739.57 | 0.03 | 99.8 | - | (无匹配) |
| t8-ai | 1 | 38.8 | 4/2048(0.2%) | 3 | 4.77 | 0.00 | 100.0 | - | (无匹配) |
| t8-antifraud | 1 | 19.8 | 47/2048(2.3%) | 3 | 4.69 | 0.00 | 91.7 | - | (无匹配) |
| t8_mysql | 1 | 71.6 | 162/15000(1.1%) | 17 | 94.06 | 0.00 | 100.0 | 0 | staging/tw8591, staging/hk8591 |
| td_master | 1 | 679.5 | 61/2048(3.0%) | 5 | 165.54 | 0.00 | 100.0 | - | staging/TD |
| tw591-slave | 1 | 428.9 | 4/2048(0.2%) | 3 | 4.41 | 0.00 | 100.0 | 0 | staging/tw591-slave, staging/mcdb-slave |
| tw591-slave-lag | 1 | 285.8 | 4/2048(0.2%) | 2 | 4.62 | 0.00 | 100.0 | 3601(延迟从库,设计如此) | staging/tw591-slave2 |
| tw8591-slave | 1 | 410.0 | 5/15000(0.0%) | 3 | 4.43 | 0.00 | 100.0 | 6 | staging/tw8591-slave, staging/hk8591-slave |
注:复制延迟为 - 表示非从库(replication 为空);t591-slave 相关双别名因同机多实例共享节点。
| 排名 | 实例 | QPS | threads_running | 连接使用率 |
|---|---|---|---|---|
| 1 | t5_master | 2739.57 | 18 | 14.8% |
| 2 | td_master | 165.54 | 5 | 3.0% |
| 3 | t8_mysql | 94.06 | 17 | 1.1% |
⚠️ 1 条 critical(t591-dealhub 复制 IO 线程停止);无 warning 级新增问题(tw591-slave-lag 1 小时延迟为设计行为)。
数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:50。