- 积分
- 74
- UID
- 15661
- 阅读权限
- 20
- 注册时间
- 2014-5-17
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
公司数据库偶尔出现订单主从服务器延迟现象,而当时通过show slave status \G查看时,看到Seconds_Behind_Master: 0
但确实是主从查询不一致,于是想进一步查看主从延迟情况,采用了mk-heartbeat工具
但具体显示的信息不是很明白,还请知道的给予解释下,多谢各位
问题:从服务器输入检测命令后显示的信息具体含义是什么
开始没有数据传输,延迟为0,每列和每行数据代表什么意思呢?
具体检测命令如下:
主服务器: mk-heartbeat -D mm --update -h10.72.16.85 -uroot -padmin --daemonize
从服务器: mk-heartbeat -D mm --monitor -h10.72.16.86 -uroot -padmin123
从服务器显示信息如下:
0s [ 0.00s, 0.00s, 0.00s ]
0s [ 0.00s, 0.00s, 0.00s ]
0s [ 0.00s, 0.00s, 0.00s ]
0s [ 0.00s, 0.00s, 0.00s ]
0s [ 0.00s, 0.00s, 0.00s ]
0s [ 0.00s, 0.00s, 0.00s ]
1s [ 0.02s, 0.00s, 0.00s ]
2s [ 0.05s, 0.01s, 0.00s ]
3s [ 0.10s, 0.02s, 0.01s ]
4s [ 0.17s, 0.03s, 0.01s ]
5s [ 0.25s, 0.05s, 0.02s ]
6s [ 0.35s, 0.07s, 0.02s ]
7s [ 0.47s, 0.09s, 0.03s ]
8s [ 0.60s, 0.12s, 0.04s ]
9s [ 0.75s, 0.15s, 0.05s ]
10s [ 0.92s, 0.18s, 0.06s ]
11s [ 1.10s, 0.22s, 0.07s ]
12s [ 1.30s, 0.26s, 0.09s ]
13s [ 1.52s, 0.30s, 0.10s ]
14s [ 1.75s, 0.35s, 0.12s ]
15s [ 2.00s, 0.40s, 0.13s ]
16s [ 2.27s, 0.45s, 0.15s ]
17s [ 2.55s, 0.51s, 0.17s ]
18s [ 2.85s, 0.57s, 0.19s ]
19s [ 3.17s, 0.63s, 0.21s ]
20s [ 3.50s, 0.70s, 0.23s ]
21s [ 3.85s, 0.77s, 0.26s ]
22s [ 4.22s, 0.84s, 0.28s ]
23s [ 4.60s, 0.92s, 0.31s ]
24s [ 5.00s, 1.00s, 0.33s ]
25s [ 5.42s, 1.08s, 0.36s ]
|
|