📋 目录概览🔴 Critical🟡 Warning(阈值:延迟>60s / 连接全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-09-16

数据源:PMM (192.168.8.52:8443) VictoriaMetrics 秒级采样,经 MCP (192.168.8.75:8200) pmm_status 获取
生成时间:2026-09-16 02:00:14(数据快照时间) / 报告生成于运行当日

概览

🔴 Critical

实例问题详情
t591-dealhub复制中断 replication_stoppedIO=False, SQL=True(IO 线程停止,中继日志仍在回放)
t591-dealhub 无 matched_alias,需在 PMM/宿主机 mynode 上进一步确认 IO 线程停止原因(如网络、主库权限、relay 损坏),本巡检只读不做修复。

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

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master147.921/8192(0.3%)612.630.01100.00staging/100
8891-master1523.916/2000(0.8%)36.020.0099.8-staging/8891
8891-slave1400.84/2000(0.2%)24.370.00100.00staging/8891-slave
TD-slave1424.84/2048(0.2%)34.320.0099.80staging/TD-slave2
TD-slave-511424.84/2048(0.2%)44.400.0099.80staging/TD-slave
addcn-bee134.83/2048(0.1%)26.390.00100.0-(无)
hk85911181.88/15000(0.1%)512.220.00100.00staging/tw8591, staging/hk8591
hk8591-slave1405.75/15000(0.0%)44.470.00100.00staging/tw8591-slave, staging/hk8591-slave
hongyan115.87/2048(0.3%)36.190.00100.0-(无)
mcdb-master199.422/4096(0.5%)56.810.00100.00staging/mcdb
mcdb-slave1190.85/4096(0.1%)34.270.00100.07staging/tw591-slave, staging/mcdb-slave
t1_mysql147.914/9190(0.2%)46.980.0099.90staging/100-slave
t5-ai134.89/2048(0.4%)34.780.00100.0-(无)
t5-gateway134.83/2048(0.1%)24.560.00100.0-(无)
t591-dealhub134.84/2048(0.2%)14.780.00100.0IO=False(无)
t5_master139.6628/4096(15.3%)133461.990.0399.8-(无)
t8-ai134.84/2048(0.2%)34.770.00100.0-(无)
t8-antifraud115.849/2048(2.4%)44.670.0092.7-(无)
t8_mysql167.6168/15000(1.1%)1768.450.00100.00staging/tw8591, staging/hk8591
td_master1675.968/2048(3.3%)8163.770.00100.0-staging/TD
tw591-slave1424.94/2048(0.2%)44.420.00100.00staging/tw591-slave, staging/mcdb-slave
tw591-slave-lag1281.84/2048(0.2%)14.610.0099.93601staging/tw591-slave2 — 延迟从库(设计如此)
tw8591-slave1405.75/15000(0.0%)34.410.00100.00staging/tw8591-slave, staging/hk8591-slave

QPS Top 3

  1. t5_master — 3461.99 qps(threads_running 13,连接 15.3%,慢查询 0.03/s)
  2. td_master — 163.77 qps
  3. t8_mysql — 68.45 qps

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