📋 目录概览Critical 告警Warning 汇总(阈值:延迟>60s / 连全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-11-03

概览

实例总数UP告警数
23231

Critical 告警

实例问题详情
t591-dealhub复制中断 (replication_stopped)IO=False, SQL=True(IO 线程已停止,relay 日志不再拉取)
建议排查链路:matched_alias staging/t591-dealhub(mysql-57-iomesh-t591-dealhub.database.svc.cluster.local:3306)→ SHOW SLAVE STATUS 确认 Last_IO_Error → 修复后 START SLAVE IO_THREAD。

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

本轮无 warning。alerts 数组仅 1 条 critical(见上);阈值复核 data 数组未发现越限项。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master195.965/8192 (0.8%)621.950.0100.00staging/100
8891-master1571.923/2000 (1.1%)2155.870.0399.9-staging/8891
8891-slave1448.83/2000 (0.1%)14.360.0100.00staging/8891-slave
TD-slave1472.94/2048 (0.2%)34.330.099.80staging/TD-slave2
TD-slave-511472.93/2048 (0.1%)34.360.099.80staging/TD-slave
addcn-bee182.82/2048 (0.1%)25.690.0100.0-staging/addcn-bee
hk85911229.68/15000 (0.1%)411.690.0100.00staging/hk8591
hk8591-slave1453.75/15000 (0.0%)44.460.0100.00staging/hk8591-slave
hongyan163.84/2048 (0.2%)35.090.0100.0-staging/hongyan
mcdb-master1147.460/4096 (1.5%)428.040.0100.00staging/mcdb
mcdb-slave1238.85/4096 (0.1%)44.570.0100.00staging/mcdb-slave
t1_mysql195.912/9190 (0.1%)46.770.099.90staging/100-slave
t5-ai182.89/2048 (0.4%)44.790.0100.0-staging/t5-ai
t5-gateway182.84/2048 (0.2%)24.560.0100.0-staging/t5-gateway
t591-dealhub182.84/2048 (0.2%)24.780.0100.0IO停止staging/t591-dealhub
t5_master13.2568/4096 (13.9%)134667.780.099.9-staging/tw591
t8-ai182.84/2048 (0.2%)34.770.0100.0-staging/t8-ai
t8-antifraud126.045/2048 (2.2%)44.660.092.8-staging/t8-antifraud
t8_mysql1115.6218/15000 (1.5%)16101.640.0100.00staging/tw8591
td_master1723.967/2048 (3.3%)5154.90.099.9-staging/TD
tw591-slave1472.94/2048 (0.2%)34.040.0100.0-staging/tw591-slave
tw591-slave-lag126.03/2048 (0.1%)14.370.0100.00staging/tw591-slave2
tw8591-slave1453.95/15000 (0.0%)34.40.0100.00staging/tw8591-slave

(复制延迟列为 - 表示非从库/无复制;IO停止 见 critical 说明)

QPS Top 3

  1. t5_master(staging/tw591, 192.168.8.117:3306)— 4667.78 qps,threads_running 13,连接使用率 13.9%
  2. 8891-master(staging/8891, 192.168.8.84:3306)— 155.87 qps
  3. td_master(staging/TD, 192.168.8.37:3306)— 154.9 qps

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