PMM MySQL 巡检日报 2026-09-09

概览

Critical(实例 down / 复制中断)

无

Warning(阈值扫描复核,alerts 为空仍扫描)

类别阈值命中情况
复制延迟 > 60sseconds_behind_master > 60tw591-slave-lag(3600s)——延迟从库(设计如此),sql_delay=3600,非异常
连接使用率 ≥ 80%used_pct ≥ 80无(最高 t5_master 14.3%)
慢查询 ≥ 1/sslow_qps ≥ 1无(最高 t5_master 0.01/s)

阈值扫描结论:除设计内的延迟从库外,无任何 warning。✅ 无告警

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master140.935/8192(0.4%)614.080.00100.00staging/100
8891-master1516.915/2000(0.8%)35.720.00100.0-staging/8891
8891-slave1393.84/2000(0.2%)24.300.00100.00staging/8891-slave
TD-slave1417.94/2048(0.2%)34.320.0099.70staging/TD-slave2
TD-slave-511417.94/2048(0.2%)34.390.0099.70staging/TD-slave
addcn-bee127.82/2048(0.1%)25.520.00100.0-(未匹配)
hk85911174.68/15000(0.1%)513.430.00100.00staging/tw8591, staging/hk8591
hk8591-slave1398.75/15000(0.0%)44.460.00100.00staging/tw8591-slave, staging/hk8591-slave
hongyan18.85/2048(0.2%)34.630.00100.0-(未匹配)
mcdb-master192.420/4096(0.5%)45.540.00100.00staging/mcdb
mcdb-slave1183.85/4096(0.1%)44.270.00100.00staging/tw591-slave, staging/mcdb-slave
t1_mysql140.914/9190(0.2%)48.500.00100.01staging/100-slave
t5-ai127.89/2048(0.4%)34.780.00100.0-(未匹配)
t5-gateway127.83/2048(0.1%)24.550.00100.0-(未匹配)
t591-dealhub127.84/2048(0.2%)14.820.00100.00(未匹配)
t5_master132.6584/4096(14.3%)103173.910.01100.0-(未匹配)
t8-ai127.84/2048(0.2%)44.770.00100.0-(未匹配)
t8-antifraud18.848/2048(2.3%)34.600.0090.7-(未匹配)
t8_mysql160.6118/15000(0.8%)1555.880.00100.00staging/tw8591, staging/hk8591
td_master1668.964/2048(3.1%)5154.550.00100.0-staging/TD
tw591-slave1417.94/2048(0.2%)34.410.00100.00staging/tw591-slave, staging/mcdb-slave
tw591-slave-lag1274.84/2048(0.2%)24.510.0099.93600staging/tw591-slave2 —— 延迟从库(设计如此)
tw8591-slave1398.95/15000(0.0%)34.400.0099.90staging/tw8591-slave, staging/hk8591-slave

注:复制延迟 - 表示该实例无复制角色(replication 为 null);t1_mysql 延迟 1s 属正常抖动。

QPS Top 3

  1. t5_master — 3173.91 qps(threads_running 10,连接使用率 14.3%,BP 命中率 100%)
  2. td_master — 154.55 qps
  3. t8_mysql — 55.88 qps

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