Central's update status method issues a large number of SQL
queries for large zones with many recent updates, as a result
it's checking out many connections from our connection pool one
after another, contributing to bug 1445123. By wrapping the
call in a transaction, a single connection will be checked out
of the pool.
Reviewed: https:/ /review. openstack. org/176340 /git.openstack. org/cgit/ openstack/ designate/ commit/ ?id=ac79df1567f b040067ed59d948 e8a39fb90af177
Committed: https:/
Submitter: Jenkins
Branch: master
commit ac79df1567fb040 067ed59d948e8a3 9fb90af177
Author: Kiall Mac Innes <email address hidden>
Date: Wed Apr 22 15:42:29 2015 +0100
central. update_ status should be transactional
Central's update status method issues a large number of SQL
queries for large zones with many recent updates, as a result
it's checking out many connections from our connection pool one
after another, contributing to bug 1445123. By wrapping the
call in a transaction, a single connection will be checked out
of the pool.
Partial-Bug: 1445123 6a0585835fe614f 787102563fa
Change-Id: Idfde7578e1a17a