Bug #63493 Configurable MySQL Workbench Timeout
Submitted: 30 Nov 2011 2:04 Modified: 16 Dec 2011 17:43
Reporter: Alex Herron Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: timeout

[30 Nov 2011 2:04] Alex Herron 
Description:
The current client side timeout of 600 sec to complete query is too restrictive.  It would be best if this was a configurable parameter.  I would understand if a server side value per connection could override the client value to allow the database admins to limit connection time, but the default should be configurable client side as well if no server side max value is set.  This could be similar to the way the max rows returned is currently configured.

How to repeat:
Run a query that takes longer than 600 secs.
[13 Dec 2011 16:10] Armando Lopez Valencia 
Hello Alex.
Can you please try modifying the "DBMS connection keep-alive interval (in seconds)" and the "DBMS connection read time-out (in seconds)" located in:
Edit->Preferences->SQL Editor tab?
Thanks.
[16 Dec 2011 17:43] Alex Herron 
That worked!  I was a version or two behind so I didn't have both of those settings.  Upgraded and set both to 3000 and have not timed out since.  Thanks.
[5 Oct 2017 10:58] Chiranjeevi Battula 
http://bugs.mysql.com/bug.php?id=87904  marked as duplicate of this one.