From 55f2e16178e55bb5a7e3a379f28a020305462005 Mon Sep 17 00:00:00 2001 From: Christian Berendt Date: Thu, 21 Mar 2013 12:06:33 +0100 Subject: [PATCH] adding parameter to configure QueuePool in SQLAlchemy This patch introduces the parameter sqlalchemy_pool_size. The parameter is used to configure the QueuePool, created in configure_db(). At the moment the configuration of the pool is only possible when using eventlet's db_pool for MySQL (sql_dbpool_enable = True). Change-Id: I64dec2863c1ee88215ef9b28054ba3bfaafa3b32 fixes: bug #1158235 --- quantum/db/api.py | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/quantum/db/api.py b/quantum/db/api.py index d27a0c21c..82ea55ff5 100644 --- a/quantum/db/api.py +++ b/quantum/db/api.py @@ -62,6 +62,10 @@ database_opts = [ cfg.BoolOpt('sql_dbpool_enable', default=False, help=_("Enable the use of eventlet's db_pool for MySQL")), + cfg.IntOpt('sqlalchemy_pool_size', + default=5, + help=_("Maximum number of SQL connections to keep open in a " + "QueuePool in SQLAlchemy")), ] cfg.CONF.register_opts(database_opts, "DATABASE") @@ -122,6 +126,7 @@ def configure_db(): 'pool_recycle': 3600, 'echo': False, 'convert_unicode': True, + 'pool_size': cfg.CONF.DATABASE.sqlalchemy_pool_size, } if 'mysql' in connection_dict.drivername: -- 2.45.2