Yaniv Dary has posted comments on this change.

Change subject: history: update user and system cpu usage percent
......................................................................


Patch Set 3:

(1 comment)

http://gerrit.ovirt.org/#/c/27556/3/packaging/dbscripts/upgrade/03_05_0020_update_cpu_usage_percent.sql
File packaging/dbscripts/upgrade/03_05_0020_update_cpu_usage_percent.sql:

Line 51:                     ( vm_configuration.number_of_sockets * 
vm_configuration.cpu_per_socket )
Line 52:                 FROM vm_configuration
Line 53:                 WHERE
Line 54:                     statistics_vms_users_usage_hourly.vm_id =
Line 55:                     vm_configuration.vm_id
Please move to basing on history version
Line 56:                     AND vm_configuration.history_id IN (
Line 57:                         SELECT MAX ( a.history_id )
Line 58:                         FROM vm_configuration as a
Line 59:                         GROUP BY a.vm_id


-- 
To view, visit http://gerrit.ovirt.org/27556
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: comment
Gerrit-Change-Id: Ia47326f94b0b1b696d0bcaf13b5f6df0093b9196
Gerrit-PatchSet: 3
Gerrit-Project: ovirt-dwh
Gerrit-Branch: master
Gerrit-Owner: Shirly Radco <[email protected]>
Gerrit-Reviewer: Yaniv Dary <[email protected]>
Gerrit-Reviewer: [email protected]
Gerrit-Reviewer: oVirt Jenkins CI Server
Gerrit-HasComments: Yes
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to