grizzly: add sql_max_pool_size and sql_max_overflow options

Bug #1087055 reported by Tom Fifield
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
openstack-manuals
Fix Released
Medium
Tom Fifield

Bug Description

As https://review.openstack.org/#/c/16595/ is merged, a nova config option has been changed

    A recent patch adds a sql_pool_size config option. This renames it to
    sql_max_pool_size and sets a default that equals SQLAlchemy's default
    (5).

No need to support sql_pool_size for backwards compatibility as it
was to be a new option in Grizzly, anyway.

 cfg.IntOpt('sql_max_pool_size',
 225 default=None, 225 default=5,
 226 help='If set, use this value for pool_size with sqlalchemy'), 226 help='Maximum number of SQL connections to keep open in a '
   227 'pool'),

Tags: nova
Tom Fifield (fifieldt)
Changed in openstack-manuals:
status: New → Confirmed
importance: Undecided → Medium
milestone: none → grizzly
tags: added: nova
Revision history for this message
Tom Fifield (fifieldt) wrote :

The other option mentioned should also be added (https://review.openstack.org/16279): sql_max_overflow

   224 cfg.IntOpt('sql_max_overflow',
   225 default=None,
   226 help='If set, use this value for max_overflow with '
   227 'sqlalchemy'),

summary: - grizzly: Rename sql_pool_size to sql_max_pool_size
+ grizzly: add sql_max_pool_size and sql_max_overflow options
Tom Fifield (fifieldt)
Changed in openstack-manuals:
assignee: nobody → Tom Fifield (fifieldt)
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to openstack-manuals (master)

Fix proposed to branch: master
Review: https://review.openstack.org/19439

Revision history for this message
Tom Fifield (fifieldt) wrote :
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to openstack-manuals (master)

Reviewed: https://review.openstack.org/19439
Committed: http://github.com/openstack/openstack-manuals/commit/1a7433943dfb2935ce393e369a35dde2096d9575
Submitter: Jenkins
Branch: master

commit 1a7433943dfb2935ce393e369a35dde2096d9575
Author: Tom Fifield <email address hidden>
Date: Fri Jan 11 12:05:42 2013 +1100

    Add sql_max_pool_size option

    fixes bug 1087055

    grizzly adds a new option to nova: sql_max_pool_size, which is
    the max number of connections to keep open in a pool. This patch
    adds it to the config reference section.

    Patch 2 adds sql_max_overflow option and fixes a typo in the
    previous commit

    Patch 3
    fixes bug 1087054
    adds sql_min_pool_size and sql_dbpool_enable options

    Change-Id: Id9d122e3002c2a91aaf83560f4bbff06911517f3

Changed in openstack-manuals:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.