MySQL Bugs: #6577: autoReconnect retry delay time increase should be improved

Bug #6577	autoReconnect retry delay time increase should be improved
Submitted:	11 Nov 2004 13:25	Modified:	28 Nov 2005 16:52
Reporter:	Oliver Wagner	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / J	Severity:	S4 (Feature request)
Version:	3.0.15	OS:	Java
Assigned to:	Mark Matthews	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When autoReconnect is set to true, the driver uses an increasing delay between connection attempts. The time starts out at initialTimeout and doubles for every failed connect attempt. However, this causes the delay time to quickly grow very large (2s, 4s, 8s, 16s, 32s, 64s, 128s, 256s, 512s...), possibly uncessarily extending the downtime.

How to repeat:
-

Suggested fix:
Two possible solutions to improve the behavior:

-- provide a "cap" setting on the timeout (i.e. 30s)
-- provide a mode which doesn't increase the timeout at all, or at least not exponentially

We've removed the increase of timeouts completely for 3.1.12 and 5.0.0. Thanks for the bug report.