MySQL Forums
Forum List  »  MyISAM

Re: 2013 Errors and long Api Timeout (Aborted Cnx)
Posted by: Bertrand Lepoittevin
Date: July 04, 2006 03:47AM

The problem comes with the TCP parameters "KeepAliveTime" which is set to 7200000 ms by default (2 hours) in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.

Setting this parameter to a small value allow the TCP/IP Stack to refresh all the TCP sessions, and then the mysql client "knows" quicker the tcp session is KO, and returns 2013 error.

The best way could be to set a "KeepAliveTimer" parameter at the mysql connection, is this parameter can be added in the next futures relases of Mysql ?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.