I am a MySQL DBA role as usual check the problems and seek a
solution.
On one of the production host (MySQL v5.1.53), I started
getting errors in this series:
[Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binlog.000942' at postion 45042
[ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
[Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binlog.000928' at postition
[ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
…
Some expert says you should increase the slave_net_timeout and some says to check value of relay_log_space_limit but it is default already
slave_net_timeout = 3600 relay_log_space_limit = 0 (unlimited) max_allowed_packet = 128MB
I can see no heavy queries …
[Read more]