blocks|key|190602|text|来自now+unavailable互联网档案：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|190603|190604|转到编辑->首选项->+SQL编辑器，并将此参数设置为更高的值:+DBMS+connection+read+time+(以秒为单位)。例如:+86400。|blockquote|190605|190606|关闭并重新打开MySQL工作台。终止之前可能正在运行的查询，然后再次运行该查询。|190607|entityMap|0|LINK|mutability|MUTABLE|url|https://web.archive.org/web/20130322031356/http://www.hassmann-software.de/mysql-workbench-lost-connection-to-mysql-server-after-600-seconds^0|6|B|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|-4|5|6|7|W|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|X|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

From the now <a href="https://web.archive.org/web/20130322031356/http://www.hassmann-software.de/mysql-workbench-lost-connection-to-mysql-server-after-600-seconds" rel="noreferrer">unavailable</a> internet archive:

<blockquote>
 Go to Edit -> Preferences -> SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds). For instance: 86400.
 
 Close and reopen MySQL Workbench. Kill your previously query that
 probably is running and run the query again.
</blockquote>

blocks|key|3028488|text|如果您使用的是"Standard+TCP/IP+over+SSH“类型的连接，则在”Preferences“”->“”Other“下有"SSH+KeepAlive”字段。我花了很长时间才找到它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028489|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you are using a "Standard TCP/IP over SSH" type of connection, under "Preferences"->"Others" there is "SSH KeepAlive" field. It took me quite a while to find it :(

blocks|key|192433|text|在5.2.47中(至少在mac上)，go首选项的位置是:+MySQLWorkbench->+preferences+->SQL+Editor|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192434|然后你会看到这两个：|192435|DBMS连接保持活动间隔(秒)：DBMS连接读取超时(秒)：|192436|后者是您想要将限制从600提高到更多的地方。|192437|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

In 5.2.47 (at least on mac), go the location of the preferences is: MySQLWorkbench->Preferences->SQL Editor

Then you'll see both:

DBMS connection keep-alive interval (in seconds):
DBMS connection read time out (in seconds):

The latter is where you'll want to up the limit from 600 to something a bit more.

blocks|key|192809|text|在我的例子中，在尝试在命令行和本地服务器设置中设置SSH超时之后。@Ljubitel解决方案解决了我的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192810|需要注意的一点是，在Workbench+6.2中，该设置现在位于advanced下|192811|​|192812|📷|atomic|offset|length|192813|192814|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/182a24d7cad8f6987147d23843765784.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

In my case after trying to set the SSH timeout on the command line and in the local server settings. @Ljubitel solution solved the issue form me. 

One point to note is that in Workbench 6.2 the setting is now under advanced

<a href="https://i.stack.imgur.com/hshuQ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/hshuQ.png" alt="enter image description here"></a>

blocks|key|192594|text|我也遇到过类似的问题，CREATE+FULLTEXT在30秒后超时：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|192595|​|192596|📷|atomic|192597|192598|在编辑->首选项下，将数据库管理系统连接读取超时间隔设置为0，->+SQL编辑器为我修复了这个问题：|192599|192600|192601|192602|而且，我不需要重启mysql工作台就能正常工作。|192603|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/55c7366802ee5580e27d1c0499591039.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/0b23e55d375e11a01a5432a00fee8e1a.png^0|B|F|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|16|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|17|8|@]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|K|3|G|5|6|7|1B|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1C|8|@]|D|@]|E|$]]|$1|N|3|G|5|6|7|1D|8|@]|D|@]|E|$]]|$1|O|3|I|5|J|7|1E|8|@]|D|@$9|1F|A|1G|1|1H]]|E|$]]|$1|P|3|G|5|6|7|1I|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1J|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1K|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z|10|-4]]|11|$5|V|W|X|E|$Y|12|10|-4]]]]

I had a similar problem where <code>CREATE FULLTEXT</code> timed out after 30 seconds:

<img src="https://i.stack.imgur.com/jd09f.png" alt="error">

Setting DBMS connection read timeout interval to 0 under Edit -> Preferences -> SQL Editor fixed the issue for me:

<img src="https://i.stack.imgur.com/vjRNM.png" alt="fix error">

Also, I did not have to restart mysql workbench for this to work.

blocks|key|192439|text|如果您使用的是"Standard+TCP/IP+over+SSH“类型的连接，则可能是ssh服务器持续超时，在这种情况下，您必须在服务器上的/etc/ssh/sshd中编辑与TCPKeepAlive相关的设置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192440|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you are using a "Standard TCP/IP over SSH" type of connection, it might be the ssh server that keeps timing out, in which case, you would have to edit TCPKeepAlive related settings in /etc/ssh/sshd_config on your server.

blocks|key|190639|text|我在2013年收到了这个错误，上面的首选项更改都没有解决这个问题。我重新启动了mysql服务，问题就消失了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190640|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was getting this error 2013 and none of the above preference changes did anything to fix the problem. I restarted mysql service and the problem went away.

blocks|key|3028532|text|好的--这个问题一直让我抓狂--+Ubuntu+Linux上的v6.3.6。上面的解决方案对我来说都不起作用。以前，连接到本地主机mysql服务器总是运行良好。连接到远程服务器总是超时-大约在60秒后，有时超时，有时超时。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028533|最终对我起作用的是将Workbench升级到6.3.9+--没有更多的连接中断。|3028534|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

OK - so this issue has been driving me crazy - v 6.3.6 on Ubuntu Linux. None of the above solutions worked for me. Connecting to localhost mysql server previously always worked fine. Connecting to remote server always timed out - after about 60 seconds, sometimes after less time, sometimes more.

What finally worked for me was upgrading Workbench to 6.3.9 - no more dropped connections.

blocks|key|2816170|text|在mysql-workbech5.7中，编辑->首选项->+SSH连接超时(适用于->+DB连接)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2816171|📷|atomic|offset|length|2816172|​|2816173|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/6de2afafdaa2294ec0bc2168cfeab87b.png|imageAlt^0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@$E|T|F|U|1|V]]|A|$]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P|Q|-4]]]]

in mysql-workbech 5.7 edit->preference-> SSH -> SSH Connect timeout (for SSH DB connection)
<a href="https://i.stack.imgur.com/6vusC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6vusC.png" alt="enter image description here"></a>

Error Code: 2013. Lost connection to MySQL server during query

I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. <code>INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4</code> multiplied 1000 times) Each batch takes a considerable amount of time, some of them, more than 600 seconds.

How can I configure workbench, to continue working overnight, without stopping and without losing the connection?

MySQL Workbench: How to keep the connection alive

数据库管理系统

数据库管理

数据库

服务器

Ubuntu

MySQL

Linux

错误码: 2013。在查询期间丢失与MySQL服务器的连接我正在使用MySQL工作台。另外，我正在运行一批插入，总共大约1000行(例如：INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4乘以1000倍)每批需要相当多的时间

问MySQL工作台:如何保持连接处于活动状态
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL工作台:如何保持连接处于活动状态EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL工作台:如何保持连接处于活动状态
EN