Bug 1416305 – [downstream clone - 4.0.7] [RFE] Optimize performance of host monitoring

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1416305 - [downstream clone - 4.0.7] [RFE] Optimize performance of host monitoring

Summary:	[downstream clone - 4.0.7] [RFE] Optimize performance of host monitoring

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Enterprise Virtualization Manager
Classification:	Red Hat
Component:	ovirt-engine (Show other bugs)
Sub Component:
Version:	unspecified
Hardware:	Unspecified Unspecified

Priority	unspecified Severity high
Target Milestone:	ovirt-4.0.7
Target Release:	---
Assigned To:	Ravi Nori
QA Contact:	Eldad Marciano
Docs Contact:

URL:
Whiteboard:
Keywords:	CodeChange, FutureFeature, Performance, ZStream

Depends On:	1388536
Blocks:
	Show dependency tree / graph

Reported:	2017-01-25 03:42 EST by rhev-integ
Modified:	2017-03-16 11:31 EDT (History)
CC List:	13 users (show)

See Also:
Fixed In Version:
Doc Type:	Enhancement
Doc Text:
Story Points:	---
Clone Of:	1388536
Environment:
Last Closed:	2017-03-16 11:31:25 EDT
Type:	---
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	Infra
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
oVirt gerrit	65924	master	MERGED	engine: Optimize performance of host monitoring	2017-01-25 03:43 EST
oVirt gerrit	67999	ovirt-engine-4.0	POST	engine: Optimize performance of host monitoring	2017-01-25 03:43 EST
oVirt gerrit	68001	ovirt-engine-4.0.6	POST	engine: Optimize performance of host monitoring	2017-01-25 03:43 EST
oVirt gerrit	68018	ovirt-engine-3.6	POST	engine: Optimize performance of host monitoring	2017-01-25 03:43 EST
Red Hat Product Errata	RHBA-2017:0542	normal	SHIPPED_LIVE	Red Hat Virtualization Manager 4.0.7	2017-03-16 15:25:04 EDT

Groups: None (edit)

Description rhev-integ 2017-01-25 03:42:45 EST

+++ This bug is an upstream to downstream clone. The original bug is: +++
+++   bug 1388536 +++
======================================================================

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:

(Originally by Martin Perina)

Comment 3 rhev-integ 2017-01-25 03:42:59 EST

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.

(Originally by Lukas Svaty)

Comment 4 rhev-integ 2017-01-25 03:43:05 EST

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

(Originally by Sandro Bonazzola)

Comment 6 Eldad Marciano 2017-02-02 07:54:21 EST

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

Comment 7 Yaniv Kaul 2017-02-02 07:57:36 EST

CodeChange - moving to VERIFIED.

Comment 9 errata-xmlrpc 2017-03-16 11:31:25 EDT

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2017-0542.html

Note You need to log in before you can comment on or make changes to this bug.