mysqldump备份大量数据时出现丢失连接

==Error: failed to execute query ‘SHOW MASTER STATUS’: 2013 (HY000) Lost connection to MySQL server during query==

解决办法

1.首先查看max_allow_packet如果是默认值修改配置文件新增如下

max_allow_packet  =  1024M   #配置为最大的1G，超过默认算1G并重启服务

2.如果上面无法解决，查看连接状态读写超时时间是否配置过小，默认net_read_timeout 30s,net_write_timeout 60s

#查看
show variables like '%timeout%';
#修改
set global net_read_timeout=1200;
set global net_write_timeout=9000;