📋 目录Critical(实例 down / 复制中断)Warning(延迟>60s / 连接使用率≥8全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-11-05

Critical(实例 down / 复制中断)

实例问题详情
t591-dealhub (staging/t591-dealhub)🔴 replication_stopped复制 IO 线程已停止(IO=False, SQL=True),主从数据不再同步。深挖链路:matched_alias staging/t591-dealhub → connect → show_active_connections / show_lock_waits

Warning(延迟>60s / 连接使用率≥80% / 慢查询≥1/s)

按阈值复核全量 data 后:无

注:tw591-slave-lag 当前 sql_delay=0、seconds_behind_master=0,快照时未呈现延迟,不标注延迟从库。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master197.974/8192 (0.9%)524.550.0100.00staging/100
8891-master1573.923/2000 (1.1%)4117.900.0100.0-staging/8891
8891-slave1450.84/2000 (0.2%)24.330.0100.00staging/8891-slave
TD-slave1475.14/2048 (0.2%)34.330.099.80staging/TD-slave2
TD-slave-511475.14/2048 (0.2%)34.380.099.80staging/TD-slave
addcn-bee184.83/2048 (0.1%)25.500.0100.0-staging/addcn-bee
hk85911231.68/15000 (0.1%)512.310.0100.00staging/hk8591
hk8591-slave1455.75/15000 (0.0%)416.070.0100.00staging/hk8591-slave
hongyan165.89/2048 (0.4%)34.730.0100.0-staging/hongyan
mcdb-master1149.450/4096 (1.2%)524.370.099.40staging/mcdb
mcdb-slave1240.85/4096 (0.1%)54.570.0100.00staging/mcdb-slave
t1_mysql197.910/9190 (0.1%)45.150.099.90staging/100-slave
t5-ai184.89/2048 (0.4%)34.790.0100.0-staging/t5-ai
t5-gateway184.83/2048 (0.1%)24.550.0100.0-staging/t5-gateway
t591-dealhub184.83/2048 (0.1%)24.790.0100.0🔴 复制IO停止staging/t591-dealhub
t5_master15.2682/4096 (16.7%)124785.370.099.7-staging/tw591
t8-ai184.84/2048 (0.2%)34.770.0100.0-staging/t8-ai
t8-antifraud128.043/2048 (2.1%)34.610.0100.0-staging/t8-antifraud
t8_mysql1117.6120/15000 (0.8%)1786.360.0100.00staging/tw8591
td_master1726.478/2048 (3.8%)5149.070.0100.0-staging/TD
tw591-slave1475.14/2048 (0.2%)23.980.0100.0-staging/tw591-slave
tw591-slave-lag128.04/2048 (0.2%)24.310.099.90staging/tw591-slave2
tw8591-slave1455.95/15000 (0.0%)34.430.0100.00staging/tw8591-slave

QPS Top 3

  1. t5_master (staging/tw591):4785.37 qps,threads_running 12,连接 16.7%,BP 命中率 99.7%
  2. td_master (staging/TD):149.07 qps,threads_running 5,连接 3.8%
  3. 8891-master (staging/8891):117.90 qps,threads_running 4,连接 1.1%

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