[Bug 1404076] Re: Optimize Ceilometer resource list query

[Launchpad Bug Tracker]

This bug was fixed in the package ceilometer - 2014.1.5-0ubuntu2

---------------
ceilometer (2014.1.5-0ubuntu2) trusty; urgency=medium

  * 0001-Optimize-resource-list-query.patch: Optimize resource list
    query. (LP: #1404076).

 -- Jorge Niedbalski <jorge.niedbalski at canonical.com>  Tue, 14 Jul 2015
08:18:13 -0500

** Changed in: ceilometer (Ubuntu Trusty)
       Status: Fix Committed => Fix Released

-- 
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:
  Fix Released

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