title: How can I execute SQL queries that take longer 99,999 seconds on MySQL Workbench?
body: <p>UPDATE: the issue is now <a href="https://stackoverflow.com/a/33490832/395857">fixed</a>.</p>
  
  <hr>
  
  <p>I would like to execute a query that takes more than 99,999 seconds to execute (e.g. <code>SELECT SLEEP(150000);</code>). To change the timeout in MySQL Workbench, we have to go to <em>Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds)</em>. However, the <code>DBMS connection read time out</code> 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: <code>Error Code: 2013. Lost connection to MySQL server during query</code></p>
  
  <p>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.</p>
  
  <p>The <code>DBMS connection read time out</code> field:
  <img src="https://i.stack.imgur.com/fVEQt.png" alt="enter image description here"></p>
  
  <p>Timeout issue (0 is equivalent to the default parameter (600 seconds)):
  <img src="https://i.stack.imgur.com/V6CfD.png" alt="enter image description here"></p>