How can I execute SQL queries that take longer 99,999 seconds on MySQL Workbench?
mysql-workbench
Solution
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.
Problem
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)):