📋 目录概览CriticalWarning全实例明细QPS Top 3

PMM MySQL 巡检日报 2026-11-04

概览

Critical

实例问题详情
t591-dealhub复制中断 (replication_stopped)IO=False, SQL=True — IO 线程已停止,主从数据不再同步

其余实例均正常在线,无实例 down。

Warning

按阈值复核(复制延迟 >60s、连接使用率 ≥80%、慢查询 ≥1/s):无。

全实例明细

service_nameupuptime(天)连接 used/max(pct%)threads_runningqpsslow_qpsBP命中率%复制延迟smatched_alias
100-master196.954/8192 (0.7%)628.020.00100.00staging/100
8891-master1572.926/2000 (1.3%)3167.410.09100.0-staging/8891
8891-slave1449.84/2000 (0.2%)14.360.00100.00staging/8891-slave
TD-slave1473.94/2048 (0.2%)34.330.0099.90staging/TD-slave2
TD-slave-511473.93/2048 (0.1%)24.390.0099.80staging/TD-slave
addcn-bee183.83/2048 (0.1%)25.450.00100.0-staging/addcn-bee
hk85911230.68/15000 (0.1%)510.740.00100.00staging/hk8591
hk8591-slave1454.75/15000 (0.0%)44.470.00100.00staging/hk8591-slave
hongyan164.84/2048 (0.2%)34.640.00100.0-staging/hongyan
mcdb-master1148.440/4096 (1.0%)423.700.00100.00staging/mcdb
mcdb-slave1239.85/4096 (0.1%)44.570.00100.00staging/mcdb-slave
t1_mysql196.917/9190 (0.2%)412.180.0099.90staging/100-slave
t5-ai183.89/2048 (0.4%)34.780.00100.0-staging/t5-ai
t5-gateway183.84/2048 (0.2%)24.550.00100.0-staging/t5-gateway
t591-dealhub183.84/2048 (0.2%)24.760.00100.00staging/t591-dealhub
t5_master14.2756/4096 (18.5%)125326.320.0099.8-staging/tw591
t8-ai183.84/2048 (0.2%)34.770.00100.0-staging/t8-ai
t8-antifraud127.045/2048 (2.2%)44.650.0092.0-staging/t8-antifraud
t8_mysql1116.6208/15000 (1.4%)17115.790.00100.00staging/tw8591
td_master1725.263/2048 (3.1%)5157.090.0099.8-staging/TD
tw591-slave1473.94/2048 (0.2%)34.040.00100.0-staging/tw591-slave
tw591-slave-lag127.04/2048 (0.2%)24.370.00100.00staging/tw591-slave2
tw8591-slave1454.95/15000 (0.0%)34.420.0099.90staging/tw8591-slave

注:

QPS Top 3

  1. t5_master (staging/tw591) — 5326.32 qps
  2. 8891-master (staging/8891) — 167.41 qps
  3. td_master (staging/TD) — 157.09 qps

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