[Bug 1404076] [NEW] Optimize Ceilometer resource list query

[Launchpad Bug Tracker]

You have been subscribed to a public bug by Jorge Niedbalski (niedbalski):

[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 at queen:~$ time ceilometer resource-list | wc -l 
10031 real	1m3.975s user	0m3.572s sys	0m0.187s 
ubuntu at 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://review.openstack.org/142951

** Affects: ceilometer
     Importance: High
     Assignee: Rohit Jaiswal (rohit-jaiswal-3)
         Status: Fix Released

** Affects: ceilometer (Ubuntu)
     Importance: Undecided
         Status: Fix Released

** Affects: ceilometer (Ubuntu Trusty)
     Importance: High
     Assignee: Jorge Niedbalski (niedbalski)
         Status: In Progress

-- 
Optimize Ceilometer resource list query
https://bugs.launchpad.net/bugs/1404076
You received this bug notification because you are a member of Ubuntu Sponsors Team, which is subscribed to the bug report.