Bug 1388536

Summary:	[RFE] Optimize performance of host monitoring
Product:	[oVirt] ovirt-engine	Reporter:	Martin Perina <mperina>
Component:	BLL.Infra	Assignee:	Ravi Nori <rnori>
Status:	CLOSED UPSTREAM	QA Contact:	eberman
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	4.0.0	CC:	bugs, eberman, emarcian, gklein, lsvaty, mgoldboi, rgolan, rnori, ykaul
Target Milestone:	ovirt-4.1.0-rc	Keywords:	CodeChange, FutureFeature, Performance, ZStream
Target Release:	4.1.0	Flags:	rule-engine: ovirt-4.1+ gklein: testing_plan_complete- mgoldboi: planning_ack+ mperina: devel_ack+ eberman: testing_ack+
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1402859 1416305 (view as bug list)		Environment:
Last Closed:	2017-02-06 13:39:50 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Infra	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1388462, 1402859, 1416305

Description Martin Perina 2016-10-25 15:06:28 UTC

Description of problem:

Currently host monitoring is updating database data inefficiently and we have seen it causes big db load for larger setups. So we need to clean up the code here and optimize database updates similarly as it has been done inside VM monitoring

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 2 Lukas Svaty 2016-12-08 13:56:31 UTC

Adding CodeChange, for testing it is sufficient the basic sanity on db performance with host and VM statuses. With this interval to write to vds_dynamic was changed from few seconds to 1-2 per minute.

Comment 3 Sandro Bonazzola 2017-01-25 07:57:09 UTC

4.0.6 has been the last oVirt 4.0 release, please re-target this bug.

Comment 4 Eldad Marciano 2017-02-02 12:54:03 UTC

Yaniv, based on this comment 
https://bugzilla.redhat.com/show_bug.cgi?id=1402859#c11
we can close it as well

Comment 5 eberman 2017-02-06 13:38:43 UTC

if we need to verify :
please provide   instructions how to measure and decide on quality of improvement ,what and how to compare

Comment 6 Yaniv Kaul 2017-02-06 13:39:50 UTC

CodeChange - closing.