PMM MySQL 巡检日报 2026-10-21
- 数据源：PMM (192.168.8.52:8443) VictoriaMetrics 秒级采样，经 MCP (192.168.8.75:8200)
pmm_status 直连获取
- 数据生成时间：2026-10-21 02:04:11 UTC（北京时间 2026-10-21 10:04）
- 报告生成时间：2026-10-21 10:04 (Asia/Shanghai)
概览
Critical 告警
| 实例 | 问题 | 详情 |
|---|
| t591-dealhub | replication_stopped | 复制 IO 线程已停止（IO=False, SQL=True），binlog 拉取中断，需人工介入 START SLAVE IO_THREAD 前先排查中断原因 |
Warning 汇总（阈值扫描复核）
按阈值复核全量 data：复制延迟>60s、连接使用率≥80%、慢查询≥1/s —— 无命中项。
- 复制延迟 >60s：无（所有从库 seconds_behind_master 均为 0）
- 连接使用率 ≥80%：无（最高为 t8-antifraud 2.6%）
- 慢查询 ≥1/s：无（最高 slow_qps 为 hk8591 0.03/s）
全实例明细
| service_name | up | uptime(天) | 连接 used/max(pct%) | threads_running | qps | slow_qps | BP命中率% | 复制延迟s | matched_alias |
|---|
| 100-master | ✅ | 82.9 | 15/8192 (0.2%) | 5 | 30.73 | 0.01 | 100.0 | 0 | staging/100 |
| 8891-master | ✅ | 559.0 | 16/2000 (0.8%) | 3 | 6.38 | 0.00 | 99.9 | — | staging/8891 |
| 8891-slave | ✅ | 435.8 | 3/2000 (0.1%) | 1 | 4.36 | 0.00 | 100.0 | 0 | staging/8891-slave |
| TD-slave | ✅ | 460.0 | 4/2048 (0.2%) | 2 | 4.03 | 0.00 | 99.4 | 0 | staging/TD-slave2 |
| TD-slave-51 | ✅ | 460.0 | 4/2048 (0.2%) | 3 | 4.10 | 0.00 | 99.3 | 0 | staging/TD-slave |
| addcn-bee | ✅ | 69.8 | 3/2048 (0.1%) | 2 | 6.77 | 0.00 | 100.0 | — | staging/addcn-bee |
| hk8591 | ✅ | 216.7 | 12/15000 (0.1%) | 5 | 20.98 | 0.03 | 99.9 | 0 | staging/hk8591 |
| hk8591-slave | ✅ | 440.9 | 5/15000 (0.0%) | 4 | 4.65 | 0.00 | 100.0 | 0 | staging/hk8591-slave |
| hongyan | ✅ | 50.8 | 5/2048 (0.2%) | 3 | 4.70 | 0.00 | 100.0 | — | staging/hongyan |
| mcdb-master | ✅ | 134.4 | 36/4096 (0.9%) | 4 | 12.96 | 0.00 | 100.0 | 0 | staging/mcdb |
| mcdb-slave | ✅ | 225.8 | 5/4096 (0.1%) | 4 | 4.57 | 0.00 | 100.0 | 0 | staging/mcdb-slave |
| t1_mysql | ✅ | 82.9 | 15/9190 (0.2%) | 4 | 12.29 | 0.00 | 100.0 | 0 | staging/100-slave |
| t5-ai | ✅ | 69.8 | 10/2048 (0.5%) | 3 | 4.79 | 0.00 | 100.0 | — | staging/t5-ai |
| t5-gateway | ✅ | 69.8 | 4/2048 (0.2%) | 2 | 4.55 | 0.00 | 100.0 | — | staging/t5-gateway |
| t591-dealhub | ✅ | 69.8 | 4/2048 (0.2%) | 1 | 4.77 | 0.00 | 100.0 | ⚠️ IO停止 | staging/t591-dealhub |
| t8-ai | ✅ | 69.8 | 4/2048 (0.2%) | 3 | 4.78 | 0.00 | 100.0 | — | staging/t8-ai |
| t8-antifraud | ✅ | 13.0 | 54/2048 (2.6%) | 3 | 4.84 | 0.00 | 90.9 | — | staging/t8-antifraud |
| t8_mysql | ✅ | 102.6 | 119/15000 (0.8%) | 16 | 119.27 | 0.02 | 100.0 | 0 | staging/tw8591 |
| td_master | ✅ | 711.0 | 69/2048 (3.4%) | 5 | 160.60 | 0.02 | 99.9 | — | staging/TD |
| tw591-slave | ✅ | 460.0 | 4/2048 (0.2%) | 4 | 4.12 | 0.00 | 100.0 | — | staging/tw591-slave |
| tw591-slave-lag | ✅ | 13.0 | 4/2048 (0.2%) | 1 | 4.71 | 0.00 | 100.0 | 0 | staging/tw591-slave2（延迟从库，设计如此；当前 sql_delay=0） |
| tw8591-slave | ✅ | 441.0 | 5/15000 (0.0%) | 3 | 4.43 | 0.00 | 100.0 | 0 | staging/tw8591-slave |
注：「—」表示该实例无复制角色（replication 为 null）。t8-antifraud BP 命中率 90.9% 偏低（实例仅启动 13 天，仍处预热阶段）；tw591-slave-lag 历史峰值连接 2049 曾触及 max 2048。
QPS Top 3
| 排名 | 实例 | QPS | threads_running |
|---|
| 1 | td_master | 160.60 | 5 |
| 2 | t8_mysql | 119.27 | 16 |
| 3 | 100-master | 30.73 | 5 |
数据源 PMM(192.168.8.52:8443)，经 MCP(8.75:8200) 直连获取，下轮明日 09:50。