mysql 600秒,如何在MySQL Workbench上执行耗时99,999秒的SQL查询？

UPDATE: the issue is now fixed.

I would like to execute a query that takes more than 99,999 seconds to execute (e.g. SELECT SLEEP(150000);). To change the timeout in MySQL Workbench, we have to go to Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds). However, the DBMS connection read time out field only accept up to 5 figures, and setting the field to 0 is equivalent to the default parameter (600 seconds). If the query takes more time than the timeout, I get the error message: Error Code: 2013. Lost connection to MySQL server during query

Hence my question: is it possible to increase this limit to over 99,999 seconds?

I use Windows 7 64-bit Ultimate with MySQL Workbench 5.2.47 CE.

The DBMS connection read time out field:

Timeout issue (0 is equivalent to the default parameter (600 seconds)):

解决方案

Probably nobody ever thought you'd need such a high timeout, so you are limited to what is settable currently. But open a feature request on http://bugs.mysql.com to suggest either having 0 disable the timeout entirely or allow bigger values.