SELECT FOR UPDATE expression, which is triggered with the use of the
SQLAlchemy Query object's with_lockmode('update') method, is
detrimental to performance and scalability of the database
performance code in Neutron due to the lock contention it produces.
SELECT FOR UPDATE can be entirely avoided in delete_firewall method
with the use of single-shot DELETE expressions.
Reviewed: https:/ /review. openstack. org/116988 /git.openstack. org/cgit/ openstack/ neutron/ commit/ ?id=187217d767c a41b742937fe183 ba4a4c20e59185
Committed: https:/
Submitter: Jenkins
Branch: master
commit 187217d767ca41b 742937fe183ba4a 4c20e59185
Author: Cedric Brandily <email address hidden>
Date: Tue Aug 26 20:23:04 2014 +0200
Remove SELECT FOR UPDATE use in delete_firewall
SELECT FOR UPDATE expression, which is triggered with the use of the 'update' ) method, is
SQLAlchemy Query object's with_lockmode(
detrimental to performance and scalability of the database
performance code in Neutron due to the lock contention it produces.
SELECT FOR UPDATE can be entirely avoided in delete_firewall method
with the use of single-shot DELETE expressions.
Partial-Bug: #1364358 6a5bd573694a60a 798279834cb
Change-Id: Ia8db73312f5dff