This is a known regression in the Octavia API performance. It has an existing story[0] that is under development. You are correct, that star join is the root of the problem. Look for a patch soon.
[0] https://storyboard.openstack.org/#!/story/2002933 Michael On Thu, Sep 13, 2018 at 10:32 AM Erik Olof Gunnar Andersson <eanders...@blizzard.com> wrote: > > 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 <yjf1970231...@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-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev __________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev