diff options
| author | Jenkins <jenkins@review.openstack.org> | 2016-02-24 14:44:20 +0000 |
|---|---|---|
| committer | Gerrit Code Review <review@openstack.org> | 2016-02-24 14:44:21 +0000 |
| commit | 14b4a45f512ebe4b3f1a6fde00124a76373b7c9f (patch) | |
| tree | 64078675e3c44fc65d848c6b7b3b80b79326d456 | |
| parent | fdb5ad8c2d18dd9c538d21c2e032a1b0dd4fe07d (diff) | |
| parent | db5ecf69c8a13f96fbb00250a5fd3df312082b23 (diff) | |
| download | oslo-db-14b4a45f512ebe4b3f1a6fde00124a76373b7c9f.tar.gz | |
Merge "Increase the default max_overflow value"4.6.0
| -rw-r--r-- | oslo_db/options.py | 1 | ||||
| -rw-r--r-- | releasenotes/notes/increase-default-max-overflow-0af787268807f926.yaml | 25 |
2 files changed, 26 insertions, 0 deletions
diff --git a/oslo_db/options.py b/oslo_db/options.py index 38e9024..f4bec25 100644 --- a/oslo_db/options.py +++ b/oslo_db/options.py @@ -89,6 +89,7 @@ database_opts = [ group='DATABASE')], help='Interval between retries of opening a SQL connection.'), cfg.IntOpt('max_overflow', + default=50, deprecated_opts=[cfg.DeprecatedOpt('sql_max_overflow', group='DEFAULT'), cfg.DeprecatedOpt('sqlalchemy_max_overflow', diff --git a/releasenotes/notes/increase-default-max-overflow-0af787268807f926.yaml b/releasenotes/notes/increase-default-max-overflow-0af787268807f926.yaml new file mode 100644 index 0000000..6547ac2 --- /dev/null +++ b/releasenotes/notes/increase-default-max-overflow-0af787268807f926.yaml @@ -0,0 +1,25 @@ +--- +upgrade: + - | + The default value of ``max_overflow`` config option + has been increased from 10 to 50 in order to allow + OpenStack services heavily using DBs to better handle + spikes of concurrent requests and lower the probability + of getting a pool timeout issue. + + This change potentially leads to increasing of the number + of open connections to an RDBMS server. Depending on the + configuration, you may see "too many connections" errors + in logs of OpenStack services / RDBMS server. The max limit of + connections can be set by the means of these config options: + + http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_connections + http://www.postgresql.org/docs/current/static/runtime-config-connection.html#GUC-MAX-CONNECTIONS + + For details, please see the following LP: + + https://bugs.launchpad.net/oslo.db/+bug/1535375 + + and the ML thread: + + http://lists.openstack.org/pipermail/openstack-dev/2015-December/082717.html |