PMM MySQL 巡检日报 2026-10-27
- 数据源:PMM(192.168.8.52:8443),经 MCP(192.168.8.75:8200)
pmm_status 直连获取(只读)
- 数据时间:2026-10-27 02:00:13 UTC(北京 10:00) | 报告生成:2026-10-27 10:00 Asia/Shanghai
概览
Critical
| 实例 | 问题 | 详情 |
|---|
| t591-dealhub (staging/t591-dealhub) | 复制中断 replication_stopped | IO=False, SQL=True —— IO 线程已停止,主从同步断开 |
Warning(阈值:延迟>60s / 连接使用率≥80% / 慢查询≥1/s)
- 复制延迟>60s:无(最大 tw8591-slave 1s,属正常抖动)
- 连接使用率≥80%:无(最高 t8_mysql 1.4%;注意 tw591-slave-lag 历史峰值 max_used 2049 曾超 max 2048,当前 0.2%)
- 慢查询≥1/s:无(最高 t8_mysql / mcdb-slave 0.01/s)
全实例明细
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|
| 100-master | ✅ | 88.9 | 21/8192(0.3%) | 6 | 9.08 | 0.00 | 100.0 | 0 | staging/100 |
| 8891-master | ✅ | 564.9 | 23/2000(1.1%) | 3 | 8.86 | 0.00 | 97.0 | - | staging/8891 |
| 8891-slave | ✅ | 441.8 | 4/2000(0.2%) | 1 | 4.33 | 0.00 | 100.0 | 0 | staging/8891-slave |
| TD-slave | ✅ | 465.9 | 4/2048(0.2%) | 3 | 4.33 | 0.00 | 99.8 | 0 | staging/TD-slave2 |
| TD-slave-51 | ✅ | 465.9 | 4/2048(0.2%) | 3 | 4.36 | 0.00 | 99.8 | 0 | staging/TD-slave |
| addcn-bee | ✅ | 75.8 | 2/2048(0.1%) | 2 | 4.27 | 0.00 | 100.0 | - | staging/addcn-bee |
| hk8591 | ✅ | 222.6 | 8/15000(0.1%) | 5 | 10.60 | 0.00 | 100.0 | 0 | staging/hk8591 |
| hk8591-slave | ✅ | 446.7 | 5/15000(0.0%) | 4 | 4.46 | 0.00 | 100.0 | 0 | staging/hk8591-slave |
| hongyan | ✅ | 56.8 | 6/2048(0.3%) | 3 | 4.10 | 0.00 | 100.0 | - | staging/hongyan |
| mcdb-master | ✅ | 140.4 | 55/4096(1.3%) | 4 | 26.98 | 0.00 | 100.0 | 0 | staging/mcdb |
| mcdb-slave | ✅ | 231.8 | 4/4096(0.1%) | 3 | 4.56 | 0.01 | 100.0 | 0 | staging/mcdb-slave |
| t1_mysql | ✅ | 88.9 | 12/9190(0.1%) | 4 | 4.96 | 0.00 | 99.8 | 0 | staging/100-slave |
| t5-ai | ✅ | 75.8 | 16/2048(0.8%) | 3 | 4.26 | 0.00 | 100.0 | - | staging/t5-ai |
| t5-gateway | ✅ | 75.8 | 5/2048(0.2%) | 2 | 3.85 | 0.00 | 100.0 | - | staging/t5-gateway |
| t591-dealhub | ✅ | 75.8 | 4/2048(0.2%) | 2 | 4.07 | 0.00 | 100.0 | 🔴 IO stopped | staging/t591-dealhub |
| t8-ai | ✅ | 75.8 | 2/2048(0.1%) | 2 | 4.07 | 0.00 | 100.0 | - | staging/t8-ai |
| t8-antifraud | ✅ | 19.0 | 48/2048(2.3%) | 4 | 3.95 | 0.00 | 92.3 | - | staging/t8-antifraud |
| t8_mysql | ✅ | 108.6 | 215/15000(1.4%) | 19 | 105.70 | 0.01 | 100.0 | 0 | staging/tw8591 |
| td_master | ✅ | 717.0 | 78/2048(3.8%) | 5 | 147.63 | 0.00 | 99.9 | - | staging/TD |
| tw591-slave | ✅ | 465.9 | 3/2048(0.1%) | 3 | 4.04 | 0.00 | 100.0 | - | staging/tw591-slave |
| tw591-slave-lag | ✅ | 19.0 | 4/2048(0.2%) | 2 | 4.38 | 0.00 | 100.0 | 0(延迟从库,设计如此) | staging/tw591-slave2 |
| tw8591-slave | ✅ | 447.0 | 5/15000(0.0%) | 3 | 4.39 | 0.00 | 100.0 | 1 | staging/tw8591-slave |
注:"-" 表示非从库(无复制)。tw591-slave-lag 当前 sql_delay=0、seconds_behind_master=0。
QPS Top 3
- td_master 147.63 qps(staging/TD,threads_running 5)
- t8_mysql 105.70 qps(staging/tw8591,threads_running 19)
- mcdb-master 26.98 qps(staging/mcdb)
数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:50。