MySQL Bugs: #46531: support keepalive timeout option

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

I vote for this feature.
More specifically: please make it an option in the ODBC connector aswell.