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

PMM MySQL 巡检日报 2026-09-22

数据源:PMM (192.168.8.52:8443) VictoriaMetrics 秒级采样,经 MCP (192.168.8.75:8200) 直连获取
生成时间:2026-09-22 02:11:11(数据快照 generated_at)

概览

🔴 Critical

实例问题详情
t591-dealhub (mynode)复制中断 replication_stoppedIO=False, SQL=True —— IO 线程已停,从主库拉取 binlog 中断,需尽快排查网络/认证/主库 binlog

其余实例均 up,无实例下线。

🟡 Warning

复核说明:alerts 数组仅 1 条(t591-dealhub),按阈值扫描 data 复核未发现额外 warning。另观察项:t8-antifraud 缓冲池命中率 95.7%,为全场最低,暂未达告警口径,建议关注。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master154.013/8192 (0.2%)59.040.00100.00staging/100
8891-master1529.930/2000 (1.5%)211.750.00100.0-staging/8891
8891-slave1406.84/2000 (0.2%)14.360.0099.90staging/8891-slave
TD-slave1431.14/2048 (0.2%)24.320.0099.80staging/TD-slave2
TD-slave-511431.14/2048 (0.2%)24.380.0099.70staging/TD-slave
addcn-bee140.82/2048 (0.1%)25.420.00100.0--
hk85911187.79/15000 (0.1%)514.890.00100.00staging/tw8591, staging/hk8591
hk8591-slave1411.95/15000 (0.0%)44.460.00100.00staging/tw8591-slave, staging/hk8591-slave
hongyan121.84/2048 (0.2%)35.580.0099.8--
mcdb-master1105.524/4096 (0.6%)45.760.00100.00staging/mcdb
mcdb-slave1196.85/4096 (0.1%)44.270.00100.00staging/tw591-slave, staging/mcdb-slave
t1_mysql154.012/9190 (0.1%)44.920.00100.00staging/100-slave
t5-ai140.814/2048 (0.7%)34.800.00100.0--
t5-gateway140.84/2048 (0.2%)24.550.00100.0--
t591-dealhub140.84/2048 (0.2%)24.770.00100.0IO中断-
t5_master145.61479/4096 (36.1%)162961.580.0299.9--
t8-ai140.84/2048 (0.2%)34.770.00100.0--
t8-antifraud121.850/2048 (2.4%)24.660.0095.7--
t8_mysql173.6114/15000 (0.8%)1683.730.00100.00staging/tw8591, staging/hk8591
td_master1682.074/2048 (3.6%)5163.250.00100.0-staging/TD
tw591-slave1431.15/2048 (0.2%)34.440.01100.00staging/tw591-slave, staging/mcdb-slave
tw591-slave-lag1287.84/2048 (0.2%)14.690.00100.03600 ⚙️staging/tw591-slave2
tw8591-slave1412.25/15000 (0.0%)34.400.00100.00staging/tw8591-slave, staging/hk8591-slave

注:⚙️ tw591-slave-lag 延迟 3600s = sql_delay(设计如此),延迟从库;「-」表示无复制角色或该指标不适用。

QPS Top 3

  1. t5_master — 2961.58 qps(threads_running 16,连接 36.1%,全场最繁忙)
  2. td_master — 163.25 qps
  3. t8_mysql — 83.73 qps

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