6:58 p.m.
Hi Aviv
We are still observing this issue. dwh db is increasing very rapidly. So far we are unable
to find what is causing so much increasing. These are top tables consuming disk space.
I added entry in the root crontab to vacuum the db but it did not work.
public.host_interface_samples_history | 56 GB
public.host_interface_hourly_history | 11 GB
public.vm_disks_usage_samples_history | 8819 MB
public.vm_interface_samples_history | 3396 MB
public.vm_samples_history | 2689 MB
public.host_interface_configuration | 2310 MB
public.vm_disk_samples_history | 1839 MB
public.vm_disks_usage_hourly_history | 1210 MB
public.vm_device_history | 655 MB
public.vm_interface_hourly_history | 536 MB
public.vm_hourly_history | 428 MB
public.statistics_vms_users_usage_hourly | 366 MB
public.vm_disk_hourly_history | 330 MB
public.host_samples_history | 140 MB
public.host_interface_daily_history | 77 MB
public.calendar | 40 MB
public.host_hourly_history | 24 MB
public.vm_disk_configuration | 19 MB
public.vm_interface_configuration | 16 MB
public.vm_configuration | 14 MB
public.vm_disks_usage_daily_history | 11 MB
public.vm_interface_daily_history | 4992 kB
public.storage_domain_samples_history | 4312 kB
public.vm_daily_history | 4088 kB
public.vm_disk_daily_history | 3048 kB
public.statistics_vms_users_usage_daily | 2816 kB
public.cluster_configuration | 1248 kB
public.host_configuration | 1136 kB
public.storage_domain_hourly_history | 744 kB
public.tag_relations_history | 352 kB
This the row count in host_interface_samples_history table.
ovirt_engine_history=# select count(*) from host_interface_samples_history;
count
-----------
316633499
I had no choice except to truncate the table. But in next 3-4 hours count again increased
too much
ovirt_engine_history=# select count(*) from host_interface_samples_history;
count
---------
8743168
(1 row)
So even if we move dwh to separate vm it will use the disk space in few days. I applied
below recommendations also but it did not make any change.
# cat ovirt-engine-dwhd.conf
#
# These variables control the amount of memory used by the java
# virtual machine where the daemon runs:
#
DWH_HEAP_MIN=1g
DWH_HEAP_MAX=3g
# Recommendation as per oVirt Guide in case dwh and engine are on same machine
#https://www.ovirt.org/documentation/data_warehouse_guide/#Installing_and_Configuring_Dat#a_Warehouse_on_a_Separate_Machine_DWH_admin
DWH_TABLES_KEEP_HOURLY=780
DWH_TABLES_KEEP_DAILY=0
Is there anything else we can check further to find what is causing so much increase?
Please let me know if you need any further information.
Regards
Sohail