The instance_faults table is too large, leading to slow query speed of command: nova list --all-tenants
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Triaged
|
Medium
|
Unassigned |
Bug Description
Description
===========
The execution of command: nova list --all-t, takes 50+ seconds, but the number of virtual machines is only 50.
This is because this command will call the function fill_faults() in "\nova\
will query the database table: instance_faults. If the number of records in this table is too large, the performance will be very poor.
For example, in my openstack, due to many wrong operations, the record number is more than 250 thousand and query time is 50+ second.
In my opinion, as time goes on, data will become more and more, and query performance will be lower and lower. So, we need a plan to ensure that query performance is not affected by data volume.
Steps to reproduce
==================
This bug is not easy to reproduce, unless your data is large too.
Environment
===========
[root@nail1 ~]# rpm -qa | grep nova
openstack-
openstack-
python2-
openstack-
openstack-
openstack-
openstack-
python-
openstack-
openstack-
hypervisor:
Libvirt + KVM
tags: | added: list |
Changed in nova: | |
status: | New → Triaged |
importance: | Undecided → Medium |
Sounds like bug 1632247 but that was "fixed" a couple of years ago with this change:
https:/ /review. openstack. org/#/c/ 409943/
I wonder if there has been a regression?