yahoo-eng-team team mailing list archive

[norman shen <2120357@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

We are using Victoria OpenStack and we found server group list API is
pretty slow. For a total number of 188 server groups, API returns in
about 8 seconds.

After some debugging, it turns out
https://github.com/openstack/nova/blob/04a65154a96d4d3094895f7b3bdad9f77c7d3e96/nova/api/openstack/compute/server_groups.py#L184
and
https://github.com/openstack/nova/blob/04a65154a96d4d3094895f7b3bdad9f77c7d3e96/nova/api/openstack/compute/server_groups.py#L109C23-L109C39
introduces the high performance penalty. It seems to me that
server_group_member table is never going to be cleanup event after
instances got deleted and DB item being archived.

** Affects: nova
     Importance: Undecided
         Status: New

-- 
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/2120357

Title:
  Obtain server group list is slow

Status in OpenStack Compute (nova):
  New

Bug description:
  We are using Victoria OpenStack and we found server group list API is
  pretty slow. For a total number of 188 server groups, API returns in
  about 8 seconds.

  After some debugging, it turns out
  https://github.com/openstack/nova/blob/04a65154a96d4d3094895f7b3bdad9f77c7d3e96/nova/api/openstack/compute/server_groups.py#L184
  and
  https://github.com/openstack/nova/blob/04a65154a96d4d3094895f7b3bdad9f77c7d3e96/nova/api/openstack/compute/server_groups.py#L109C23-L109C39
  introduces the high performance penalty. It seems to me that
  server_group_member table is never going to be cleanup event after
  instances got deleted and DB item being archived.

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