yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** 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