yahoo-eng-team team mailing list archive

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

** Changed in: nova
       Status: Fix Committed => Fix Released

** Changed in: nova
    Milestone: None => liberty-rc1

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

Title:
  lack index of instance_system_metadata.instance_uuid in pgsql

Status in OpenStack Compute (nova):
  Fix Released

Bug description:
  Nova db migrating script don't create index on
  instance_system_metadata.instance_uuid for postgresql, it cause the
  listing instances have low performance.

  The following is our performance testing result, we have 200,000
  instances, and 4,000,000 instance_system_metadata records in
  background.

  list 1000 instances in one API request

  GET /${tenant_id}/servers/detail&limit=1000

  No index:

  4~5 minutes on average

  After add index:

  5 seconds on average

  instance_system_metadata.instance_uuid index is created for mysql, now
  need to add it for postgresql.

  Code base:

  $ git log -1
  commit a8dd5722035784847fd7f7a915628d5feaaf5ff9
  Merge: a74f07a 990ef48
  Author: Jenkins <jenkins@xxxxxxxxxxxxxxxxxxxx>
  Date:   Thu Jul 30 21:36:10 2015 +0000

      Merge "Add DiskNotFound and VolumeNotFound test"

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