mysql icon indicating copy to clipboard operation
mysql copied to clipboard

Improve connection_pool connection retry strategy

Open anarthal opened this issue 1 year ago • 0 comments

  • The retry strategy is currently very simple (linear time between retries) and not configurable. When there are a lot of connections, this can saturate the network. A configurable retry strategy may be an option. An exponential backoff may be beneficial.
  • When initial_size is big, all connections attempt an establishment try at the same time. This can again cause congestion. We may want to limit this.
  • This may also cause trouble with https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_connect_errors

anarthal avatar Dec 20 '23 16:12 anarthal