错误代码:2013.在查询过程中失去与 MySQL 服务器的连接

2021-11-20 00:00:00 sql database mysql mysql-workbench

当我尝试使用 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.

相关文章