MySQL Workbench出现：Error Code: 2013. Lost connection to MySQL server during query的问题解决_error code 2013

问题描述;

1.表规模是 150万行，每行18列。 执行查询语句：

selectcount(DeviceId) from(select DeviceId, count(distinct SubdeviceMac) as MACnumfrom wide_table_all_row where TIMESTAMPP LIKE "%2017-10-13%" group by DeviceId HAVING MACnum >= 5 and MACnum <= 10) as tmp;

报Error Code: 2013. Lost connectionto MySQL server during query。 每次都是等待30s报错误。 

按照网上的经验，修改mysql服务器的配置文件，my.ini的timeout时间，发现问题仍然存在。 

后来换mysql安装自带的cmd命令行客户端，没有超时问题。 怀疑是mysql workbench 客户端原因。 

后来再MySQL workbench Q&A找到原因，链接如下  https://dev.mysql.com/doc/workbench/en/workbench-faq.html#faq-workbench-error-lost-connection

Yes, go to