Too many period db actions in large scale clusters increase the load of database

Bug #1704179 reported by zhang zhenzhong
This bug report is a duplicate of:  Bug #1729621: Inconsistent value for vcpu_used. Edit Remove
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
In Progress
Undecided
Chris Dent

Bug Description

Too many period db actions in large scale clusters increase the load of database, especially un-necessary db update or query.

For example, over 1000 nodes, it will be 2 * 1000=2000 db update for compute_node table in 60s in _update_available_resource, but this two db update is not necessary if resource usage not changed.

Delete the first and second _update() in _init_compute_node can reduce two db update for one node in 60s, if resource usage not changed for this compute_node.

Then the funtion self._resource_change(compute_node) in _update() make sense

description: updated
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (master)

Fix proposed to branch: master
Review: https://review.openstack.org/483506

Changed in nova:
assignee: nobody → zhang zhenzhong (zzzhang0118)
status: New → In Progress
Changed in nova:
assignee: zhang zhenzhong (zzzhang0118) → Stephen Finucane (stephenfinucane)
Changed in nova:
assignee: Stephen Finucane (stephenfinucane) → Chris Dent (cdent)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on nova (master)

Change abandoned by Matt Riedemann (<email address hidden>) on branch: master
Review: https://review.opendev.org/483506
Reason: This was fixed with https://review.opendev.org/#/c/520024/.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.