Bug #46531 support keepalive timeout option
Submitted: 3 Aug 2009 15:02 Modified: 3 Aug 2009 16:03
Reporter: Vladislav Vaintroub Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: C API (client library) Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[3 Aug 2009 15:02] Vladislav Vaintroub
Description:
This is a followup to 
"Bug #31109 client on Vista does not report 'lost connection'".

It does not seem possible to detect network disconnects by the client if client stucks in recv(). So clients could hang at least until default keepalive timeout (2hours) has expired. A smaller timeout would detect a hang earlier.

So this is a feature request to support keepalive timeout 
.This can be done with WSAIoctl on windows  http://msdn.microsoft.com/en-us/library/dd877220(VS.85).aspx and setsockopt() with TCP_KEEPIDLE & Co on Unix.

How to repeat:
N/A
[28 Sep 2010 19:48] Bonny Gijzen
I vote for this feature.
More specifically: please make it an option in the ODBC connector aswell.