Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1416305

Summary: [downstream clone - 4.0.7] [RFE] Optimize performance of host monitoring
Product: Red Hat Enterprise Virtualization Manager Reporter: rhev-integ
Component: ovirt-engineAssignee: Ravi Nori <rnori>
Status: CLOSED ERRATA QA Contact: Eldad Marciano <emarcian>
Severity: high Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: bugs, eberman, gklein, lsurette, lsvaty, mgoldboi, mperina, pstehlik, rbalakri, Rhev-m-bugs, rnori, srevivo, ykaul
Target Milestone: ovirt-4.0.7Keywords: CodeChange, FutureFeature, Performance, ZStream
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: 1388536 Environment:
Last Closed: 2017-03-16 15:31:25 UTC Type: ---
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: 1388536    
Bug Blocks:    

Description rhev-integ 2017-01-25 08:42:45 UTC 
+++ 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 08:42:59 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.

(Originally by Lukas Svaty)
Comment 4 rhev-integ 2017-01-25 08:43:05 UTC 
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 12:54:21 UTC 
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 12:57:36 UTC 
CodeChange - moving to VERIFIED.
Comment 9 errata-xmlrpc 2017-03-16 15:31:25 UTC 
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