MySQL Workbench:如何保持连接有效

MySQL Workbench: How to keep the connection alive(MySQL Workbench:如何保持连接有效)

问题描述

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

我正在使用 MySQL 工作台.另外，我正在运行一批插入，总共大约 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:如何保持连接有效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！