| 2016-10-11 09:05:42 |
Tina Kevin |
bug |
|
|
added bug |
| 2016-10-11 09:06:55 |
Tina Kevin |
tags |
|
all-tenants list slow |
|
| 2016-10-29 04:04:59 |
Tina Kevin |
nova: importance |
Undecided |
Wishlist |
|
| 2016-11-02 03:58:32 |
Sivasathurappan Radhakrishnan |
nova: assignee |
|
Sivasathurappan Radhakrishnan (siva-radhakrishnan) |
|
| 2016-12-09 11:20:54 |
Sean Dague |
tags |
all-tenants list slow |
db |
|
| 2016-12-09 11:58:25 |
Sean Dague |
nova: status |
New |
Confirmed |
|
| 2016-12-09 11:58:39 |
Sean Dague |
nova: importance |
Wishlist |
Medium |
|
| 2016-12-09 11:59:39 |
Sean Dague |
summary |
The command "nova list --all-tenants" query is slow |
We fetch all instance faults, then throw away all but the last ones on "nova list --all-tenants", potentinally making the command slow |
|
| 2016-12-12 16:01:43 |
Roman Podoliaka |
bug |
|
|
added subscriber Roman Podoliaka |
| 2016-12-12 19:26:49 |
Jay Pipes |
summary |
We fetch all instance faults, then throw away all but the last ones on "nova list --all-tenants", potentinally making the command slow |
nova list --all-tenants fetches all instance faults but uses only latest |
|
| 2016-12-12 19:27:06 |
Jay Pipes |
nova: assignee |
Sivasathurappan Radhakrishnan (siva-radhakrishnan) |
Jay Pipes (jaypipes) |
|
| 2016-12-12 21:46:15 |
OpenStack Infra |
nova: status |
Confirmed |
In Progress |
|
| 2016-12-13 14:11:19 |
OpenStack Infra |
nova: assignee |
Jay Pipes (jaypipes) |
Roman Podoliaka (rpodolyaka) |
|
| 2017-01-04 21:37:18 |
OpenStack Infra |
nova: status |
In Progress |
Fix Released |
|
| 2017-09-06 01:37:49 |
Ben Niu |
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 |
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 |
|
