错误代码:2013.查询期间丢失与 MySQL 服务器的连接
当我尝试使用 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.
有没有办法增加超时值?
Is there away to increase the timeout value?
推荐答案
新版本的 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.
相关文章