Workbench : lost connection to mysql during query

分类: 文章 • 2024-07-03 20:12:16

MySQL Workbench对大表执行复杂操作时报错如下：Error Code: 2013. Lost connection to MySQL server during query

解决办法：

Edit->Preference->SQL Editor

将下图DBMS connection read time out(in seconds)适当调大

Workbench : lost connection to mysql during query

根据自己测试：240可以承受万条插入。