[openstack-dev] [octavia] Optimize the query of the octavia database

Jeff Yang yjf1970231893 at gmail.com
Thu Sep 13 11:52:17 UTC 2018

Hi, All

As octavia resources increase, I found that running the "openstack
loadbalancer list" command takes longer and longer. Sometimes a 504 error
is reported.

By reading the code, I found that octavia will performs complex left outer
join queries when acquiring resources such as loadbalancer, listener, pool,
etc. in order to only make one trip to the database.
Reference code: http://paste.openstack.org/show/730022 Line 133
Generated SQL statements: http://paste.openstack.org/show/730021

So, I suggest that adjust the query strategy to provide different join
queries for different resources.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20180913/3c5327b9/attachment.html>

More information about the OpenStack-dev mailing list