MySQL Workbench:如何使连接保持活动状态 [英] MySQL Workbench: How to keep the connection alive

问题描述

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

我正在使用MySQL Workbench.另外，我正在运行一批插入件，总共约1000行(例如INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4乘以1000次)，每批插入都花费相当多的时间，其中一些超过600秒.

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

我如何配置工作台，使其在一夜之间继续工作，而又不停止且不丢失连接?

推荐答案

从现在开始

From the now unavailable internet archive:

转到编辑"->首选项"->"SQL编辑器"，然后将此参数设置为较高的值:DBMS连接读取超时(以秒为单位).例如:86400.

Go to Edit -> Preferences -> SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds). For instance: 86400.

关闭并重新打开MySQL Workbench.取消您先前的查询 可能正在运行，然后再次运行查询.

Close and reopen MySQL Workbench. Kill your previously query that probably is running and run the query again.

这篇关于MySQL Workbench:如何使连接保持活动状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！