Shirly Radco has uploaded a new change for review. Change subject: history: updated ksm_shared_memory_percent to mb ......................................................................
history: updated ksm_shared_memory_percent to mb Droped ksm_shared_memory_percent column from host_samples_history table and added ksm_shared_memory_mb instead. Change-Id: Ic965021913baa1a3a95deda5ab2cad206638cbbb Related-To: https://bugzilla.redhat.com/1076902 Signed-off-by: Shirly Radco <[email protected]> --- M packaging/dbscripts/create_views_3_4.sql A packaging/dbscripts/upgrade/03_04_0070_update_mem_shared_to_mb.sql 2 files changed, 26 insertions(+), 5 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/89/25789/1 diff --git a/packaging/dbscripts/create_views_3_4.sql b/packaging/dbscripts/create_views_3_4.sql index d94563f..303b018 100644 --- a/packaging/dbscripts/create_views_3_4.sql +++ b/packaging/dbscripts/create_views_3_4.sql @@ -269,7 +269,7 @@ host_status as host_status, minutes_in_status as minutes_in_status, memory_usage_percent as memory_usage_percent, - ksm_shared_memory_percent, + ksm_shared_memory_mb, cpu_usage_percent as cpu_usage_percent, ksm_cpu_percent as ksm_cpu_percent, active_vms as active_vms, @@ -292,8 +292,8 @@ minutes_in_status as minutes_in_status, memory_usage_percent as memory_usage_percent, max_memory_usage as max_memory_usage, - ksm_shared_memory_percent, - max_ksm_shared_memory_percent, + ksm_shared_memory_mb, + max_ksm_shared_memory_mb, cpu_usage_percent as cpu_usage_percent, max_cpu_usage as max_cpu_usage, ksm_cpu_percent as ksm_cpu_percent, @@ -325,8 +325,8 @@ minutes_in_status as minutes_in_status, memory_usage_percent as memory_usage_percent, max_memory_usage as max_memory_usage, - ksm_shared_memory_percent, - max_ksm_shared_memory_percent, + ksm_shared_memory_mb, + max_ksm_shared_memory_mb, cpu_usage_percent as cpu_usage_percent, max_cpu_usage as max_cpu_usage, ksm_cpu_percent as ksm_cpu_percent, diff --git a/packaging/dbscripts/upgrade/03_04_0070_update_mem_shared_to_mb.sql b/packaging/dbscripts/upgrade/03_04_0070_update_mem_shared_to_mb.sql new file mode 100644 index 0000000..3dabb98 --- /dev/null +++ b/packaging/dbscripts/upgrade/03_04_0070_update_mem_shared_to_mb.sql @@ -0,0 +1,21 @@ +-- add ksm_shared_memory_mb to host_samples_history table +SELECT fn_db_add_column('host_samples_history', 'ksm_shared_memory_mb', 'bigint'); + +--delete ksm_shared_memory_percent column from host_samples_history table +SELECT fn_db_drop_column('host_samples_history', 'ksm_shared_memory_percent'); + +-- add ksm_shared_memory_mb to host_hourly_history table +SELECT fn_db_add_column('host_hourly_history', 'ksm_shared_memory_mb', 'bigint'); +SELECT fn_db_add_column('host_hourly_history', 'max_ksm_shared_memory_mb', 'bigint'); + +--delete ksm_shared_memory_percent column from host_hourly_history table +SELECT fn_db_drop_column('host_hourly_history', 'ksm_shared_memory_percent'); +SELECT fn_db_drop_column('host_hourly_history', 'max_ksm_shared_memory_percent'); + +-- add ksm_shared_memory_mb to host_daily_history table +SELECT fn_db_add_column('host_daily_history', 'ksm_shared_memory_mb', 'bigint'); +SELECT fn_db_add_column('host_daily_history', 'max_ksm_shared_memory_mb', 'bigint'); + +--delete ksm_shared_memory_percent column from host_samples_history table +SELECT fn_db_drop_column('host_daily_history', 'ksm_shared_memory_percent'); +SELECT fn_db_drop_column('host_daily_history', 'max_ksm_shared_memory_percent'); -- To view, visit http://gerrit.ovirt.org/25789 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ic965021913baa1a3a95deda5ab2cad206638cbbb 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
