yahoo-eng-team team mailing list archive

[Vish Ishaya <vishvananda@xxxxxxxxx>]

Public bug reported:

The get_networks_by_host query fails to use the existing indexes on
fixed ips. This means a large number of fixed_ips can lead to the
database getting bogged down and taking multiple seconds to return.

** Affects: nova
     Importance: Undecided
     Assignee: Vish Ishaya (vishvananda)
         Status: In Progress

** Changed in: nova
       Status: New => In Progress

** Changed in: nova
     Assignee: (unassigned) => Vish Ishaya (vishvananda)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1369009

Title:
  Get networks by host query fails to use index

Status in OpenStack Compute (Nova):
  In Progress

Bug description:
  The get_networks_by_host query fails to use the existing indexes on
  fixed ips. This means a large number of fixed_ips can lead to the
  database getting bogged down and taking multiple seconds to return.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1369009/+subscriptions