📋 目录概览CriticalWarning全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-10-28

概览

实例总数upalert
22221

Critical

实例问题详情
t591-dealhubreplication_stoppedIO=False, SQL=True(IO 线程停止,复制中断,数据不再从主库同步)

Warning

无(阈值扫描复核:复制延迟最高 7s(hk8591-slave / mcdb-slave / tw8591-slave,<60s);连接使用率最高 3.0%(td_master);慢查询最高 0.01/s(100-master、t8_mysql),均未触发阈值)。

延迟从库说明:本快照中无 sql_delay>0 实例;tw591-slave-lag 为设计延迟从库,当前 seconds_behind_master=0。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master189.920/8192 (0.2%)69.370.01100.00staging/100
8891-master1566.119/2000 (0.9%)314.030.00100.0-staging/8891
8891-slave1442.84/2000 (0.2%)24.330.00100.00staging/8891-slave
TD-slave1466.94/2048 (0.2%)24.320.0099.70staging/TD-slave2
TD-slave-511466.94/2048 (0.2%)34.390.0099.60staging/TD-slave
addcn-bee176.83/2048 (0.1%)26.170.00100.0-staging/addcn-bee
hk85911223.613/15000 (0.1%)517.300.00100.00staging/hk8591
hk8591-slave1447.45/15000 (0.0%)44.470.00100.02staging/hk8591-slave
hongyan157.87/2048 (0.3%)34.880.00100.0-staging/hongyan
mcdb-master1141.441/4096 (1.0%)524.100.00100.00staging/mcdb
mcdb-slave1232.85/4096 (0.1%)34.570.00100.07staging/mcdb-slave
t1_mysql189.914/9190 (0.2%)44.980.00100.00staging/100-slave
t5-ai176.89/2048 (0.4%)44.780.00100.0-staging/t5-ai
t5-gateway176.86/2048 (0.3%)24.550.00100.0-staging/t5-gateway
t591-dealhub176.84/2048 (0.2%)24.770.00100.00*staging/t591-dealhub
t8-ai176.83/2048 (0.1%)34.770.00100.0-staging/t8-ai
t8-antifraud120.045/2048 (2.2%)34.670.0092.8-staging/t8-antifraud
t8_mysql1109.6249/15000 (1.7%)17108.980.01100.00staging/tw8591
td_master1718.061/2048 (3.0%)5145.450.00100.0-staging/TD
tw591-slave1466.94/2048 (0.2%)44.040.00100.0-staging/tw591-slave
tw591-slave-lag120.03/2048 (0.1%)24.400.0099.90staging/tw591-slave2(延迟从库,设计如此)
tw8591-slave1447.55/15000 (0.0%)34.400.0099.97staging/tw8591-slave

注:t591-dealhub 标 0* —— IO 线程已停止,seconds_behind_master 不再增长但复制实际中断;「-」表示无复制上下文(主库/单机)。t8-antifraud BP 命中率 92.8% 偏低(重启约 20 天,属缓冲池预热阶段,暂观察)。

QPS Top 3

  1. td_master — 145.45
  2. t8_mysql — 108.98
  3. mcdb-master — 24.10

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