yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #95128
[Bug 2092133] Re: api slow due to missing LRP index
Reviewed: https://review.opendev.org/c/openstack/ovsdbapp/+/938004
Committed: https://opendev.org/openstack/ovsdbapp/commit/1cbe61683a0bf40a7894efaa4d069b96e8862344
Submitter: "Zuul (22348)"
Branch: master
commit 1cbe61683a0bf40a7894efaa4d069b96e8862344
Author: Max Lamprecht <max.lamprecht@stackit.cloud>
Date: Tue Dec 3 14:31:17 2024 +0100
Add Northbound Logical_Router_Port name index
This improves Logical_Router_Port lookup speeds at scale.
Closes-Bug: #2092133
Change-Id: I9cc8460244c030f83194736cbb71c3cf449cbf76
** Changed in: ovsdbapp
Status: In Progress => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2092133
Title:
api slow due to missing LRP index
Status in neutron:
In Progress
Status in ovsdbapp:
Fix Released
Bug description:
With many routers/Logical_Router_Ports the neutron-api can get slow at
scale.
When profiling the api we noticed that much time gets spend in
functions like:
sync_routers_and_rports -> _is_router_port_changed
schedule_unhosted_gateways -> get_unhosted_gateways -> get_gateway_chassis_binding
schedule_unhosted_gateways -> get_gateway_chassis_az_hints
This happens due to LRP queries without an index:
lrp = idlutils.row_by_value(self.idl, 'Logical_Router_Port', 'name', gateway_name)
After adding an Logical_Router_Port name index the API performance improves a lot.
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2092133/+subscriptions
References