Public bug reported:
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 <jenk...@review.openstack.org>
Date: Thu Jul 30 21:36:10 2015 +0000
Merge "Add DiskNotFound and VolumeNotFound test"
** Affects: nova
Importance: Undecided
Assignee: Rui Chen (kiwik-chenrui)
Status: New
** Tags: postgresql
** Changed in: nova
Assignee: (unassigned) => Rui Chen (kiwik-chenrui)
** Tags added: postgresql
--
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):
New
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 <jenk...@review.openstack.org>
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
--
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
