问题描述
当我尝试使用 MySQL Workbench 将索引添加到表时，我收到 错误代码:2013.在查询期间丢失与 MySQL 服务器的连接错误.我还注意到，每当我运行长查询时它就会出现.
I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query.
是否可以增加超时值?
推荐答案
新版本的 MySQL WorkBench 有一个选项可以更改特定的超时时间.
New versions of MySQL WorkBench have an option to change specific timeouts.
对我来说是在编辑 → 首选项 → SQL 编辑器 → DBMS 连接读取超时(以秒为单位):600
For me it was under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600
将值更改为 6000.
Changed the value to 6000.
还有未检查的限制行，因为每次我想搜索整个数据集时都设置一个限制会让人厌烦.
Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome.
这篇关于错误代码:2013.在查询过程中失去与 MySQL 服务器的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！