Qos plugin performs too many queries
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
High
|
Oleg Bondarev |
Bug Description
Whenever retrieving the port list while having the QoS plugin enabled, Neutron performs about 10 DB queries per port, most of them being QoS related: http://
For 1000 ports, we end up with 10 000 sequential DB queries. A simple "neutron port-list" or "nova list" command will exceed 1 minute, which is likely to hit timeouts.
This seems to be the problem: https:/
For each of the retrieved ports, the plugins are then supposed to provide additional details, so for each port we get a certain number of extra queries.
One idea would be to add a flag such as 'detailed' or 'include_
Worth mentioning that there were a couple of commits meant to reduce the number of queries but it's still excessive:
https:/
https:/
no longer affects: | cinder |
Changed in neutron: | |
status: | New → In Progress |
tags: | added: neutron-proactive-backport-potential |
Changed in neutron: | |
status: | In Progress → Fix Released |
milestone: | none → wallaby-3 |
status: | Fix Released → Fix Committed |
Changed in neutron: | |
status: | Fix Committed → Fix Released |
Going to apply same approach as in https:/ /review. opendev. org/c/openstack /neutron/ +/763777