Activity log for bug #1704179

Date Who What changed Old value New value Message
2017-07-13 16:52:21 zhang zhenzhong bug added bug
2017-07-13 17:00:17 zhang zhenzhong description Too many period db actions in large scale clusters increase the load of database, for example over 1000 nodes, it will be 2 * 1000=2000 db update for compute_node in 60s in _update_available_resource, but this db update is not necessary if resource usage not changed for compute_node 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. 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
2017-07-13 18:53:51 OpenStack Infra nova: status New In Progress
2017-07-13 18:53:51 OpenStack Infra nova: assignee zhang zhenzhong (zzzhang0118)
2017-07-14 15:37:54 Chris Dent bug added subscriber Chris Dent
2017-07-20 11:04:16 OpenStack Infra nova: assignee zhang zhenzhong (zzzhang0118) Stephen Finucane (stephenfinucane)
2017-07-20 11:22:59 OpenStack Infra nova: assignee Stephen Finucane (stephenfinucane) Chris Dent (cdent)
2019-08-21 16:16:52 Matt Riedemann marked as duplicate 1729621