Optimize Ceilometer resource list query
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ceilometer |
Fix Released
|
High
|
Rohit Jaiswal | ||
ceilometer (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned | ||
Trusty |
Fix Released
|
High
|
Jorge Niedbalski |
Bug Description
[Impact]
* Ceilometer resource-list requires an open-ended scan of resource and sample tables to retrieve a unique list of resources. There should be a way to optimize the scans.
[Test Case]
* Deploy an openstack cloud using the current trusty package of ceilometer.
* Run a 'ceilometer resource-list' without the patch the running
time for that command takes (if returns).
ubuntu@queen:~$ time ceilometer resource-list | wc -l
10031 real 1m3.975s user 0m3.572s sys 0m0.187s
ubuntu@queen:~$ time ceilometer resource-list | wc -l
10036 real 1m54.993s user 0m3.354s sys 0m0.184s
* With the included SRU patch :
real 0m15.693s
user 0m1.104s
sys 0m0.065s
[Regression Potential]
* None expected.
[Other Info]
* Backport of https:/
Changed in ceilometer: | |
status: | New → In Progress |
Changed in ceilometer: | |
importance: | Undecided → High |
milestone: | none → kilo-2 |
Changed in ceilometer: | |
status: | Fix Committed → Fix Released |
Changed in ceilometer: | |
milestone: | kilo-2 → 2015.1.0 |
description: | updated |
tags: | added: sts |
Fix proposed to branch: master /review. openstack. org/142951
Review: https:/