mysql
mysql copied to clipboard
Improve connection_pool connection retry strategy
- 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_sizeis 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