** Changed in: glance
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1211315
Title:
optimize queries for image-list
Status in OpenStack Image Registry and Delivery Service (Glance):
Fix Released
Bug description:
Get image list take lot of time for certain image-list criterias.
Found through the explain plan and slow query logs that there is a
full table scan happening on certain scenarios.
The fix is to refactor the get_image_list query building code to avoid
full table scan and hence reduce the response time taken.
As part of the optimization of query the following fixes are to be done:
- avoid full table scan on images table by converting,
images.is_public = 1 OR images.owner = 'OWNER'
to
query WHERE images.is_public = 1
UNION
query WHERE images.owner = 'OWNER'
- introduce missing index for owner column on images table.
- move image related conditions to the inner union queries
- remove unwanted union of queries in case of admin querying for image list
- change the condition images.status != 'killed' to images.status in
('active', 'saving', 'queued', 'pending_delete', 'deleted')
- convert the correlation subqueries that are used for image_property filters
into inner joins
To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1211315/+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
