yahoo-eng-team team mailing list archive

[Max <2092133@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
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:
  New

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