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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
