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 14:25	Modified:	28 Nov 2005 17:52
Reporter:	Oliver Wagner
Status:	Closed
Category:	Connector/J	Severity:	S4 (Feature request)
Version:	3.0.15	OS:	Java
Assigned to:	Mark Matthews	Target Version:
Triage:	D5 (Feature request)

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

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.