Shirly Radco has uploaded a new change for review. Change subject: history: Collect total RX/TX byte statistics ......................................................................
history: Collect total RX/TX byte statistics Change-Id: I617a5136bdd7db9cc6aa95b52af2d5f845864328 Bug-Url:https://bugzilla.redhat.com/1215587 Signed-off-by: Shirly Radco <[email protected]> --- M packaging/dbscripts/create_views_3_6.sql A packaging/dbscripts/upgrade/03_06_0020_added_total_transmit_and_receive_rate.sql 2 files changed, 26 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/38/41638/1 diff --git a/packaging/dbscripts/create_views_3_6.sql b/packaging/dbscripts/create_views_3_6.sql index e90e01a..4b32ac0 100644 --- a/packaging/dbscripts/create_views_3_6.sql +++ b/packaging/dbscripts/create_views_3_6.sql @@ -399,6 +399,8 @@ host_interface_id as host_interface_id, receive_rate_percent as receive_rate_percent, transmit_rate_percent as transmit_rate_percent, + receive_rate_total_byte as receive_rate_total_byte, + transmit_rate_total_byte as transmit_rate_total_byte, host_interface_configuration_version as host_interface_configuration_version FROM host_interface_samples_history; @@ -412,6 +414,8 @@ max_receive_rate_percent as max_receive_rate_percent, transmit_rate_percent as transmit_rate_percent, max_transmit_rate_percent as max_transmit_rate_percent, + receive_rate_total_byte as receive_rate_total_byte, + transmit_rate_total_byte as transmit_rate_total_byte, host_interface_configuration_version as host_interface_configuration_version FROM host_interface_hourly_history; @@ -426,6 +430,8 @@ max_receive_rate_percent as max_receive_rate_percent, transmit_rate_percent as transmit_rate_percent, max_transmit_rate_percent as max_transmit_rate_percent, + receive_rate_total_byte as receive_rate_total_byte, + transmit_rate_total_byte as transmit_rate_total_byte, host_interface_configuration_version as host_interface_configuration_version FROM host_interface_daily_history; @@ -658,6 +664,8 @@ vm_interface_id as vm_interface_id, receive_rate_percent as receive_rate_percent, transmit_rate_percent as transmit_rate_percent, + receive_rate_total_byte as receive_rate_total_byte, + transmit_rate_total_byte as transmit_rate_total_byte, vm_interface_configuration_version as vm_interface_configuration_version FROM vm_interface_samples_history; @@ -672,6 +680,8 @@ max_receive_rate_percent as max_receive_rate_percent, transmit_rate_percent as transmit_rate_percent, max_transmit_rate_percent as max_transmit_rate_percent, + receive_rate_total_byte as receive_rate_total_byte, + transmit_rate_total_byte as transmit_rate_total_byte, vm_interface_configuration_version as vm_interface_configuration_version FROM vm_interface_hourly_history; @@ -686,6 +696,8 @@ max_receive_rate_percent as max_receive_rate_percent, transmit_rate_percent as transmit_rate_percent, max_transmit_rate_percent as max_transmit_rate_percent, + receive_rate_total_byte as receive_rate_total_byte, + transmit_rate_total_byte as transmit_rate_total_byte, vm_interface_configuration_version as vm_interface_configuration_version FROM vm_interface_daily_history; diff --git a/packaging/dbscripts/upgrade/03_06_0020_added_total_transmit_and_receive_rate.sql b/packaging/dbscripts/upgrade/03_06_0020_added_total_transmit_and_receive_rate.sql new file mode 100644 index 0000000..0a9466c --- /dev/null +++ b/packaging/dbscripts/upgrade/03_06_0020_added_total_transmit_and_receive_rate.sql @@ -0,0 +1,14 @@ +select fn_db_add_column('host_interface_samples_history', 'receive_rate_total_byte', 'bigint'); +select fn_db_add_column('host_interface_samples_history', 'transmit_rate_total_byte', 'bigint'); +select fn_db_add_column('vm_interface_samples_history', 'receive_rate_total_byte', 'bigint'); +select fn_db_add_column('vm_interface_samples_history', 'transmit_rate_total_byte', 'bigint'); + +select fn_db_add_column('host_interface_hourly_history', 'receive_rate_total_byte', 'bigint'); +select fn_db_add_column('host_interface_hourly_history', 'transmit_rate_total_byte', 'bigint'); +select fn_db_add_column('vm_interface_hourly_history', 'receive_rate_total_byte', 'bigint'); +select fn_db_add_column('vm_interface_hourly_history', 'transmit_rate_total_byte', 'bigint'); + +select fn_db_add_column('host_interface_daily_history', 'receive_rate_total_byte', 'bigint'); +select fn_db_add_column('host_interface_daily_history', 'transmit_rate_total_byte', 'bigint'); +select fn_db_add_column('vm_interface_daily_history', 'receive_rate_total_byte', 'bigint'); +select fn_db_add_column('vm_interface_daily_history', 'transmit_rate_total_byte', 'bigint'); -- To view, visit https://gerrit.ovirt.org/41638 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I617a5136bdd7db9cc6aa95b52af2d5f845864328 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
