<div dir="ltr">Ok, Thank you very much for your work.</div><br><div class="gmail_quote"><div dir="ltr">Adam Harwell <<a href="mailto:flux.adam@gmail.com">flux.adam@gmail.com</a>> 于2018年9月15日周六 上午8:26写道：<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">It's high priority for me as well, so we should be able to get something done very soon, I think. Look for something early next week maybe?<div><br></div><div>Thanks,</div><div> --Adam<br><br><div class="gmail_quote"><div dir="ltr">On Thu, Sep 13, 2018, 21:18 Jeff Yang <<a href="mailto:yjf1970231893@gmail.com" target="_blank">yjf1970231893@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Thanks:<div> I found the correlative patch in neutron-lbaas: <a href="https://review.openstack.org/#/c/568361/" target="_blank">https://review.openstack.org/#/c/568361/</a></div><div><br></div><div> The bug was marked high level by our QA team. I need to fix it as soon as possible.</div><div> Does Michael Johnson have any good suggestion? I am willing to complete the</div><div> repair work of this bug. If your patch still takes a while to prepare.</div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">Michael Johnson <<a href="mailto:johnsomor@gmail.com" target="_blank">johnsomor@gmail.com</a>> 于2018年9月14日周五 上午7:56写道：<br></div></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">This is a known regression in the Octavia API performance. It has an<br>
existing story[0] that is under development. You are correct, that<br>
star join is the root of the problem.<br>
Look for a patch soon.<br>
<br>
[0] <a href="https://storyboard.openstack.org/#!/story/2002933" rel="noreferrer" target="_blank">https://storyboard.openstack.org/#!/story/2002933</a><br>
<br>
Michael<br>
On Thu, Sep 13, 2018 at 10:32 AM Erik Olof Gunnar Andersson<br>
<<a href="mailto:eandersson@blizzard.com" target="_blank">eandersson@blizzard.com</a>> wrote:<br>
><br>
> This was solved in neutron-lbaas recently, maybe we could adopt the same method for Octavia?<br>
><br>
> Sent from my iPhone<br>
><br>
> On Sep 13, 2018, at 4:54 AM, Jeff Yang <<a href="mailto:yjf1970231893@gmail.com" target="_blank">yjf1970231893@gmail.com</a>> wrote:<br>
><br>
> Hi, All<br>
><br>
> As octavia resources increase, I found that running the "openstack loadbalancer list" command takes longer and longer. Sometimes a 504 error is reported.<br>
><br>
> 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.<br>
> Reference code: <a href="http://paste.openstack.org/show/730022" rel="noreferrer" target="_blank">http://paste.openstack.org/show/730022</a> Line 133<br>
> Generated SQL statements: <a href="http://paste.openstack.org/show/730021" rel="noreferrer" target="_blank">http://paste.openstack.org/show/730021</a><br>
><br>
> So, I suggest that adjust the query strategy to provide different join queries for different resources.<br>
><br>
> <a href="https://storyboard.openstack.org/#!/story/2003751" rel="noreferrer" target="_blank">https://storyboard.openstack.org/#!/story/2003751</a><br>
><br>
> __________________________________________________________________________<br>
> OpenStack Development Mailing List (not for usage questions)<br>
> Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
><br>
> __________________________________________________________________________<br>
> OpenStack Development Mailing List (not for usage questions)<br>
> Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
</blockquote></div>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
</blockquote></div></div>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
</blockquote></div>