📋 目录概览CriticalWarning(阈值:延迟>60s / 连接使用全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-09-18

概览

实例总数up告警数
23231

Critical

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

alerts 数组仅 1 条 critical;按阈值对全量 data 复核,除上述设计内延迟从库外无新增告警。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master149.918/8192(0.2%)59.310.0199.90staging/100
8891-master1525.916/2000(0.8%)35.510.00100.0-staging/8891
8891-slave1402.84/2000(0.2%)24.360.00100.00staging/8891-slave
TD-slave1426.94/2048(0.2%)34.330.0099.90staging/TD-slave2
TD-slave-511426.94/2048(0.2%)34.390.0099.80staging/TD-slave
addcn-bee136.83/2048(0.1%)25.850.00100.0--
hk85911183.616/15000(0.1%)514.340.00100.00staging/tw8591, staging/hk8591
hk8591-slave1407.74/15000(0.0%)44.470.00100.02staging/tw8591-slave, staging/hk8591-slave
hongyan117.85/2048(0.2%)34.820.00100.0--
mcdb-master1101.428/4096(0.7%)46.810.0099.90staging/mcdb
mcdb-slave1192.85/4096(0.1%)54.270.00100.017staging/tw591-slave, staging/mcdb-slave
t1_mysql149.916/9190(0.2%)54.800.00100.00staging/100-slave
t5-ai136.89/2048(0.4%)34.790.00100.0--
t5-gateway136.83/2048(0.1%)24.550.00100.0--
t591-dealhub136.84/2048(0.2%)34.770.00100.0⚠️ IO停-
t5_master141.6733/4096(17.9%)163012.580.0299.5--
t8-ai136.84/2048(0.2%)34.770.00100.0--
t8-antifraud117.847/2048(2.3%)34.680.0091.8--
t8_mysql169.6145/15000(1.0%)1587.890.00100.00staging/tw8591, staging/hk8591
td_master1678.071/2048(3.5%)4155.950.0099.9-staging/TD
tw591-slave1426.84/2048(0.2%)44.410.01100.00staging/tw591-slave, staging/mcdb-slave
tw591-slave-lag1283.84/2048(0.2%)24.620.0099.93600(设计)staging/tw591-slave2
tw8591-slave1407.85/15000(0.0%)34.400.00100.00staging/tw8591-slave, staging/hk8591-slave

QPS Top 3

  1. t5_master — 3012.58 qps(threads_running=16,连接 733/4096)
  2. td_master — 155.95 qps
  3. t8_mysql — 87.89 qps(threads_running=15)

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