大家好,请教slave延迟问题
本帖最后由 scosure 于 2015-06-26 15:36 编辑大家好,
从库:show slave status;
slave IO_running与 SQL_running都正常,但slave延迟问题,发现是master的binlog日志没发送过来Waiting for master to send event *.*.*.* repl_remote 3306 60 mysql-bin.000042 349757827 relay-bin.000043 349757899 mysql-bin.000042 Yes Yes mysql.%,test.% 0 0 349757736 349758217 None 0 No 2084 No 0 0 1 587e61ed-f892-11e4-9d16-ccccc6bff5d0 mysql.slave_master_info 0 Slave has read all relay log; waiting for the slave I/O thread to update it 86400 0
Waiting for master to send event *.*.*.* repl_remote 3306 60 mysql-bin.000042 349757827 relay-bin.000043 349757899 mysql-bin.000042 Yes Yes mysql.%,test.% 0 0 349757736 349758217 None 0 No 2106 No 0 0 1 587e61ed-f892-11e4-9d16-ccccc6bff5d0 mysql.slave_master_info 0 Slave has read all relay log; waiting for the slave I/O thread to update it 86400 0
Waiting for master to send event *.*.*.* repl_remote 3306 60 mysql-bin.000042 349757827 relay-bin.000043 349757899 mysql-bin.000042 Yes Yes mysql.%,test.% 0 0 349757736 349758217 None 0 No 2260 No 0 0 1 587e61ed-f892-11e4-9d16-ccccc6bff5d0 mysql.slave_master_info 0 Slave has read all relay log; waiting for the slave I/O thread to update it 86400 0
Waiting for master to send event *.*.*.* repl_remote 3306 60 mysql-bin.000042 349757827 relay-bin.000043 349757899 mysql-bin.000042 Yes Yes mysql.%,test.% 0 0 349757736 349758217 None 0 No 2926 No 0 0 1 587e61ed-f892-11e4-9d16-ccccc6bff5d0 mysql.slave_master_info 0 Slave has read all relay log; waiting for the slave I/O thread to update it 86400 0
想请教大家如何处理,为什么会这样,谢谢了 检查一下网络 如果是内网,一般不会出现什么延迟的,基本上是秒传。是否是通过公网传输,主从之间是否存在较高的延迟。 是公网传,网络是正常的,我认为网络延迟,至少会将master的binlog日志发送过来吧(哪怕一个字节也好),观察发现一段时间内一个字节也没发送。
(mysql-bin.000042 349757827 )一直是这个,从库relay-bin没见增长。
有什么配置参数可以优化吗 看下主库的负载和防火墙 防火墙没问题,之前同步正常,从库可以正常用复制账号连接上去。主库负载也不高(100%内) loadavge多少 平均1.5 左右 看来主从还是最好建立在内网我上。
页:
[1]