navicat 查询数据出现 lost connection to server during query

 
navicat 查询数据出现 lost connection to server during query:
 
网上得出的结论都是修改mysql的配置:
 
net_write_timeout
wait_timeout
max_allowed_packet

而我发现我的这些数值本来就很大,所以说应该不是这个问题。
 
通过查阅 navicat 官网文档发现问题所在:
 
If you receive Lost connection to server during query error when running long query, please try:
  1. Control-click your connection and choose Connection Properties/Edit Connection.
  2. Under Advanced tab, set the Socket Timeout (sec) to a larger value.

 
 
上面的大致意思是,编辑连接属性将 套接字超时(秒)改为一个更大的值。
 
默认是30,我将它改为300,再执行查询语句,就没有问题了。

navicat 查询数据出现 lost connection to server during query

 
传送门:http://wiki.navicat.com/wiki/index.php/Lost_connection_to_server_during_query

0 个评论

要回复文章请先登录注册