当前位置:   article > 正文

The last packet successfully received from the server was 0 millis

the last packet successfully received from the server was 10,020 millisecond

备注:本人遇到并处理的方式

1.问题

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

2.处理

1.首先查看当前数据库全局wait_timeout的时间

	show global variables like '%wait_timeout%'; 
  • 1

2.设置

	将wait_timeout 和interactive_timeout 设置的大一点。默认是8小时(28800)。
	set global wait_timeout=604800;
	set global interactive_timeout=604800;
  • 1
  • 2
  • 3

3.重启数据库

	重启数据库:service mysql restart 
  • 1
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/weixin_40725706/article/detail/634775
推荐阅读
相关标签
  

闽ICP备14008679号