Description of problem: Several lbaas commands are taking longer than expected to complete, this time increases as more loadbalancers or pools are added. In the production environment, 'neutron lbaas-loadbalancer-list' is taking 1.5 minutes to complete. Running 'neutron lbaas-loadbalancer-show <lb>' on a loadbalancer with 1 pool takes about 1.5 seconds. Running the same command on a loadbalancer with 7 pools takes about 5.5 seconds. In the neutron debug logs, a large number of mysql queries being run for these operations can be seen. Version-Release number of selected component (if applicable): openstack-neutron-lbaas-9.2.1-6.el7ost.noarch How reproducible: Consistently, but becomes more apparent with more loadbalancers/pools Steps to Reproduce: 1. create multiple loadbalancers and pools 2. run lbaas cli commands Actual results: Commands take unacceptably long with more loadbalancers present Expected results: Commands should complete more quickly even as scale increases Additional info: The F5 plugin is being used, but that does not seem to be the culprit at this point. This looks very similar to https://bugs.launchpad.net/octavia/+bug/1706466, if this is the issue, can this fix be backported?
Created attachment 1414775 [details] benchmarks.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2018:1603
Fixes included here: https://brewweb.engineering.redhat.com/brew/buildinfo?buildID=799021