yahoo-eng-team team mailing list archive

[Tina Kevin <song.ruixia@xxxxxxxxxx>]

Public bug reported:

Description
===========
There are 15 instances. I excute the command: nova --debug list --all-tenants,
But it took more than 40 seconds. I read the nova api code, it sends a Get request
and read the instance_faults table for detail information. The instance_faults table has
 more than tens of thousands of records. Each instance has many records.

       GET /v2/433288e1244046a9bd306658b732dded/servers/detail

I think instance_faults table needs to be optimized. A large number of records in the instance_faults
table are useless, only leaving the last three records should be on it, others can be deleted.

There are any other optimization program?

Steps to reproduce
==================
A chronological list of steps which will bring off the
issue you noticed:
* I excute the command: nova --debug list --all-tenants

A list of openstack client commands (with correct argument value)
    $ nova --debug list --all-tenants


Expected result
===============
I expect to be back soon within 10 seconds

Actual result
=============
But the query took more than 40 seconds.

Environment
===========
1. version 
    Mitaka

2. Which hypervisor did you use?
    Libvirt + KVM

** Affects: nova
     Importance: Undecided
         Status: New


** Tags: all-tenants list slow

** Tags added: all-tenants list slow

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

Title:
   The command "nova list --all-tenants" query is slow

Status in OpenStack Compute (nova):
  New

Bug description:
  Description
  ===========
  There are 15 instances. I excute the command: nova --debug list --all-tenants,
  But it took more than 40 seconds. I read the nova api code, it sends a Get request
  and read the instance_faults table for detail information. The instance_faults table has
   more than tens of thousands of records. Each instance has many records.

         GET /v2/433288e1244046a9bd306658b732dded/servers/detail

  I think instance_faults table needs to be optimized. A large number of records in the instance_faults
  table are useless, only leaving the last three records should be on it, others can be deleted.

  There are any other optimization program?

  Steps to reproduce
  ==================
  A chronological list of steps which will bring off the
  issue you noticed:
  * I excute the command: nova --debug list --all-tenants

  A list of openstack client commands (with correct argument value)
      $ nova --debug list --all-tenants

  
  Expected result
  ===============
  I expect to be back soon within 10 seconds

  Actual result
  =============
  But the query took more than 40 seconds.

  Environment
  ===========
  1. version 
      Mitaka

  2. Which hypervisor did you use?
      Libvirt + KVM

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