赞
踩
备注:本人遇到并处理的方式
Communications link failure The last packet successfully received from the server was 10,020 milliseconds ago. The last packet sent successfully to the server was 10,020 milliseconds ago.
从服务器成功接收到的最后一个数据包是10020毫秒以前。最后一个成功发送到服务器的数据包是10020毫秒前。
Communications link failure The last packet successfully received from the server was 10,020 milliseconds ago. The last packet sent successfully to the server was 10,020 milliseconds ago.
1.首先查看当前数据库全局wait_timeout的时间
show global variables like '%wait_timeout%';
2.设置
将wait_timeout 和interactive_timeout 设置的大一点。默认是8小时(28800)。
set global wait_timeout=604800;
set global interactive_timeout=604800;
3.重启数据库
重启数据库:service mysql restart
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。