Public bug reported: The require_tenant_aggregate request filter was added in Idb52b2a9af539df653da7a36763cb9a1d0de3d1b, it queries hosts aggregates by its metadata, and since it is used for matching spesific "filter_tenant_id:123" key and value pairs. As the host aggregates table only has index for metadata key, it is possible that with a large number of tenants, the performance could be bad. We should also add value to the index.
** Affects: nova Importance: Undecided Status: New ** Description changed: - The require_tenant_aggregate request filter was added in Idb52b2a9af539df653da7a36763cb9a1d0de3d1b, - it queries hosts aggregates by its metadata, and since it is used for matching spesific "filter_tenant_id:123" - key and value pairs. As the host aggregates table only has index for metadata key, it is possible that - with a large number of tenants, the performance could be bad. We should also add value to the index. + The require_tenant_aggregate request filter was added in + Idb52b2a9af539df653da7a36763cb9a1d0de3d1b, it queries + hosts aggregates by its metadata, and since it is used + for matching spesific "filter_tenant_id:123" key and value + pairs. As the host aggregates table only has index + for metadata key, it is possible that with a large number + of tenants, the performance could be bad. We should also + add value to the index. -- 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/1784769 Title: The performance of require_tenant_aggregate request filter can be improved Status in OpenStack Compute (nova): New Bug description: The require_tenant_aggregate request filter was added in Idb52b2a9af539df653da7a36763cb9a1d0de3d1b, it queries hosts aggregates by its metadata, and since it is used for matching spesific "filter_tenant_id:123" key and value pairs. As the host aggregates table only has index for metadata key, it is possible that with a large number of tenants, the performance could be bad. We should also add value to the index. To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1784769/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp