Comment 1 for bug 1973576

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (master)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/841823
Committed: https://opendev.org/openstack/neutron/commit/182044d628314290a38440bab203d27fb9db755d
Submitter: "Zuul (22348)"
Branch: master

commit 182044d628314290a38440bab203d27fb9db755d
Author: shenjiatong <email address hidden>
Date: Sun May 15 10:12:47 2022 +0800

    Do not auto subquery load DistributedPortBindings

    We observe excessive DB calls to load DistributedPortBindings,
    We have enabled DVR and have some huge virtual routers with around
    60 router interfaces scheduled on around 200 compute nodes. Under such
    situation, subquery load DistributedPortBinding looks like not a very wise
    idea, because it is not explicitly used.

    I glance through the code and have a feeling that ml2_distributed_port_bindings
    is not used except explicitly called. So IMO it is safe to change it to
    default lazy load without causing serious regression.

    Closes-bug: #1973576
    Change-Id: Ib2c48bd5ad55e9c754a8e4938e6c5eafacc75dcc