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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
