PMM MySQL 巡检日报 2026-09-08

概览

Critical(实例 down / 复制中断)

无

Warning(阈值扫描复核)

PMM alerts 数组为空,另按阈值全量复核 data:

✅ 无告警

PMM 无活动告警,阈值复核亦未发现需处理的异常项(延迟从库为设计行为)。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master139.913/8192(0.2%)510.740.0100.00staging/100
8891-master1515.917/2000(0.9%)25.600.0100.0-staging/8891
8891-slave1392.84/2000(0.2%)14.300.0100.00staging/8891-slave
TD-slave1416.94/2048(0.2%)24.330.099.90staging/TD-slave2
TD-slave-511416.94/2048(0.2%)34.390.099.90staging/TD-slave
addcn-bee126.83/2048(0.1%)25.480.0100.0-staging/addcn-bee
hk85911173.68/15000(0.1%)512.470.0100.00staging/hk8591
hk8591-slave1397.75/15000(0.0%)44.470.0100.00staging/hk8591-slave
hongyan17.85/2048(0.2%)34.750.0100.0-staging/hongyan
mcdb-master191.433/4096(0.8%)47.630.0100.00staging/mcdb
mcdb-slave1182.85/4096(0.1%)44.270.0100.00staging/mcdb-slave
t1_mysql139.99/9190(0.1%)57.760.099.90staging/100-slave
t5-ai126.88/2048(0.4%)34.780.0100.0-staging/t5-ai
t5-gateway126.83/2048(0.1%)24.550.0100.0-staging/t5-gateway
t591-dealhub126.84/2048(0.2%)24.830.0100.00staging/t591-dealhub
t5_master131.6586/4096(14.3%)112660.870.0199.6-staging/tw591
t8-ai126.84/2048(0.2%)34.770.0100.0-staging/t8-ai
t8-antifraud17.847/2048(2.3%)34.610.090.7-staging/t8-antifraud
t8_mysql159.692/15000(0.6%)1537.650.0100.00staging/tw8591
td_master1668.060/2048(2.9%)5151.260.0100.0-staging/TD
tw591-slave1416.93/2048(0.1%)34.410.0100.00staging/tw591-slave
tw591-slave-lag1273.84/2048(0.2%)14.510.0100.03601(延迟从库,设计如此)staging/tw591-slave2
tw8591-slave1397.75/15000(0.0%)34.400.099.90staging/tw8591-slave

注:「-」表示无复制通道(非从库)或指标不适用。

QPS 前 3 实例

  1. t5_master(staging/tw591,192.168.8.117:3306):2660.87 qps,threads_running=11,连接 14.3%,BP 命中率 99.6%
  2. td_master(staging/TD,192.168.8.37:3306):151.26 qps,threads_running=5,连接 2.9%,BP 命中率 100%
  3. t8_mysql(staging/tw8591,192.168.8.27:3306):37.65 qps,threads_running=15,连接 0.6%,BP 命中率 100%

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