binlog2sql icon indicating copy to clipboard operation
binlog2sql copied to clipboard

Published 20 hours ago • verified publisher icon danfengcao

(2013, 'Lost connection to MySQL server during query')

Open yangzan66 opened this issue 4 years ago • 1 comments

binlog2sql 连接时间长了，总会断开连接， bnilog2sql报错：(2013, 'Lost connection to MySQL server during query')

是为什么啊？

yangzan66 avatar Jan 07 '21 05:01 yangzan66

HI，mysql 超时时间设置太短了 ，把一些常见的timeout 给临时调大 set session wait_timeout = 432000 ; set session connect_timeout=200 ; set session net_write_timeout=72000; # 读大表时网络阻塞超时

fengbinddr avatar Jan 11 '21 06:01 fengbinddr