📋 目录概览🔴 Critical(1 条)🟡 Warning全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-11-06

数据源:PMM (192.168.8.52:8443) VictoriaMetrics 秒级采样,经 MCP (192.168.8.75:8200) pmm_status 获取
生成时间:2026-11-06 10:00 (Asia/Shanghai),快照采样时间 2026-11-06 10:00:07

概览

🔴 Critical(1 条)

实例问题详情
t591-dealhub复制中断 replication_stoppedIO=False, SQL=True(IO 线程已停止,中继日志仍在回放,秒级延迟显示 0)

建议:matched_alias: staging/t591-dealhub → connect 后 SHOW SLAVE STATUS 确认 Last_IO_Error,排查主库连通性/账号权限后 START SLAVE IO_THREAD(本巡检只读未操作)。

🟡 Warning

无(alerts 中无 warning;按阈值扫描 data 复核:延迟均 0s、连接使用率最高 16.1%、slow_qps 最高 0.01,均未达阈值)。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master198.962/8192 (0.8%)619.370.00100.00.0staging/100
8891-master1574.928/2000 (1.4%)3245.540.00100.0-staging/8891
8891-slave1451.84/2000 (0.2%)14.330.00100.00.0staging/8891-slave
TD-slave1475.94/2048 (0.2%)34.330.0099.90.0staging/TD-slave2
TD-slave-511475.94/2048 (0.2%)34.390.0099.80.0staging/TD-slave
addcn-bee185.83/2048 (0.1%)25.680.00100.0-staging/addcn-bee
hk85911232.69/15000 (0.1%)512.370.00100.00.0staging/hk8591
hk8591-slave1456.75/15000 (0.0%)416.060.00100.00.0staging/hk8591-slave
hongyan166.87/2048 (0.3%)35.490.00100.0-staging/hongyan
mcdb-master1150.440/4096 (1.0%)426.630.00100.00.0staging/mcdb
mcdb-slave1241.85/4096 (0.1%)44.570.00100.00.0staging/mcdb-slave
t1_mysql198.913/9190 (0.1%)45.040.0099.80.0staging/100-slave
t5-ai185.89/2048 (0.4%)44.770.00100.0-staging/t5-ai
t5-gateway185.84/2048 (0.2%)24.550.00100.0-staging/t5-gateway
t591-dealhub185.84/2048 (0.2%)24.760.00100.00.0 ⚠️IO停staging/t591-dealhub
t5_master16.2659/4096 (16.1%)144703.170.0099.8-staging/tw591
t8-ai185.84/2048 (0.2%)34.770.00100.0-staging/t8-ai
t8-antifraud129.046/2048 (2.2%)44.590.00100.0-staging/t8-antifraud
t8_mysql1118.6124/15000 (0.8%)1781.160.01100.00.0staging/tw8591
td_master1726.978/2048 (3.8%)5146.270.00100.0-staging/TD
tw591-slave1475.94/2048 (0.2%)34.080.00100.0-staging/tw591-slave
tw591-slave-lag129.04/2048 (0.2%)14.410.00100.00.0staging/tw591-slave2
tw8591-slave1457.05/15000 (0.0%)34.420.0099.90.0staging/tw8591-slave

注:「-」表示该实例未开启复制(replication 为 null);tw591-slave-lag 本轮 sql_delay=0,未标注延迟从库。

QPS Top 3

  1. t5_master(staging/tw591,192.168.8.117:3306)— 4703.17 qps,连接 659/4096 (16.1%),threads_running 14
  2. 8891-master(staging/8891,192.168.8.84:3306)— 245.54 qps
  3. td_master(staging/TD,192.168.8.37:3306)— 146.27 qps

数据源 PMM(192.168.8.52:8443),经 MCP(8.75:8200) 直连获取,下轮明日 09:50。