📋 目录概览🔴 Critical(实例 down / 复制中🟡 Warning(阈值扫描复核)全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-10-22

概览

实例总数up 数alert 数
22221

🔴 Critical(实例 down / 复制中断)

服务问题详情
t591-dealhubreplication_stoppedIO=False, SQL=True(IO 线程停止,复制中断)
深挖链路:staging/t591-dealhub (mysql-57-iomesh-t591-dealhub.database.svc.cluster.local:3306) → connect → show_active_connections / show_lock_waits;本巡检只读,未做任何处置。

🟡 Warning(阈值扫描复核)

按阈值复核全量 data:复制延迟>60s(无,全部实例 seconds_behind_master=0)、连接使用率≥80%(无,最高 td_master 3.5%)、慢查询≥1/s(无,全部 slow_qps=0)。本轮无 warning。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master✅83.928/8192 (0.3%)512.150.0100.00staging/100
8891-master✅559.918/2000 (0.9%)39.100.0100.0-staging/8891
8891-slave✅436.84/2000 (0.2%)14.310.0100.00staging/8891-slave
TD-slave✅460.94/2048 (0.2%)24.330.099.80staging/TD-slave2
TD-slave-51✅460.94/2048 (0.2%)24.410.099.90staging/TD-slave
addcn-bee✅70.82/2048 (0.1%)25.970.0100.0-staging/addcn-bee
hk8591✅217.68/15000 (0.1%)512.260.0100.00staging/hk8591
hk8591-slave✅441.75/15000 (0.0%)44.470.0100.00staging/hk8591-slave
hongyan✅51.85/2048 (0.2%)34.780.0100.0-staging/hongyan
mcdb-master✅135.449/4096 (1.2%)518.690.099.20staging/mcdb
mcdb-slave✅226.85/4096 (0.1%)44.570.0100.00staging/mcdb-slave
t1_mysql✅83.916/9190 (0.2%)47.230.0100.00staging/100-slave
t5-ai✅70.810/2048 (0.5%)34.800.0100.0-staging/t5-ai
t5-gateway✅70.82/2048 (0.1%)24.550.0100.0-staging/t5-gateway
t591-dealhub✅70.83/2048 (0.1%)24.770.0100.0⚠️ IO=Falsestaging/t591-dealhub
t8-ai✅70.84/2048 (0.2%)34.770.0100.0-staging/t8-ai
t8-antifraud✅14.046/2048 (2.2%)34.600.0100.0-staging/t8-antifraud
t8_mysql✅103.6185/15000 (1.2%)1779.510.0100.00staging/tw8591
td_master✅711.971/2048 (3.5%)5153.020.0100.0-staging/TD
tw591-slave✅460.94/2048 (0.2%)34.220.0100.0-staging/tw591-slave
tw591-slave-lag✅14.04/2048 (0.2%)24.510.0100.00staging/tw591-slave2
tw8591-slave✅441.75/15000 (0.0%)34.400.0100.00staging/tw8591-slave

注:

QPS Top 3

排名service_nameqpsthreads_running连接使用率
1td_master153.0253.5%
2t8_mysql79.51171.2%
3mcdb-master18.6951.2%

除上述 1 条 critical(t591-dealhub 复制 IO 中断)外,其余维度 ✅ 无告警。


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