[Bug 1404076] Re: Optimize Ceilometer resource list query

[Jorge Niedbalski]

** Description changed:

- Ceilometer resource-list requires an open-ended scan of resource and
+ [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

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to ceilometer in Ubuntu.
https://bugs.launchpad.net/bugs/1404076

Title:
  Optimize Ceilometer resource list query

Status in Ceilometer:
  Fix Released
Status in ceilometer package in Ubuntu:
  Fix Released
Status in ceilometer source package in Trusty:
  In Progress

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

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