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.