Open Stack

This was solved in neutron-lbaas recently, maybe we could adopt the same method for Octavia?

Sent from my iPhone

On Sep 13, 2018, at 4:54 AM, Jeff Yang <yjf1970231893 at gmail.com<mailto:yjf1970231893 at gmail.com>> wrote:


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.

https://storyboard.openstack.org/#!/story/2003751

__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: OpenStack-dev-request at lists.openstack.org<mailto:OpenStack-dev-request at lists.openstack.org>?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20180913/6a98615d/attachment.html>