Re: [ovirt-users] Large DWH Database, how to empty

2017-01-25 Thread Matt .
Hi Shirly, OK, great! thanks for the clearification! This might be updated and made more clear in the docs. Thanks! Matt 2017-01-25 14:41 GMT+01:00 Shirly Radco : > Please see at the to of this section: > "The following is a list of options for configuring application

Re: [ovirt-users] Large DWH Database, how to empty

2017-01-25 Thread Shirly Radco
Please see at the to of this section: "The following is a list of options for configuring application settings for the Data Warehouse service. These options are available in the /usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.conf file. *Configure any changes to the

Re: [ovirt-users] Large DWH Database, how to empty

2017-01-25 Thread Matt .
Hi Shirly, The reason why I ask is because the explanation here: https://access.redhat.com/documentation/en/red-hat-virtualization/4.0/single/data-warehouse-guide/#Application_Settings_for_the_Data_Warehouse_service_in_ovirt-engine-dwhd.conf 2017-01-24 10:49 GMT+01:00 Shirly Radco

Re: [ovirt-users] Large DWH Database, how to empty

2017-01-24 Thread Shirly Radco
Hi, We don't update the ovirt-engine-dwhd.conf directly. You need to add the new file to /ovirt-engine-dwhd.conf.d/ with the lines DWH_TABLES_KEEP_SAMPLES= DWH_TABLES_KEEP_HOURLY= DWH_TABLES_KEEP_DAILY=0 and set the values for how much time you want the data to be kept. Keep in mind that the

Re: [ovirt-users] Large DWH Database, how to empty

2017-01-24 Thread Matt .
Shirly, I'm checking this out and aren't you sure the file is update_time_to_keep_records.conf and not ovirt-engine-dwhd.conf ? 2017-01-09 14:01 GMT+01:00 Matt . : > I think it did. Cluster exists 4 years now, hosted engine 7 months. > > 2017-01-08 13:50 GMT+01:00 Shirly

Re: [ovirt-users] Large DWH Database, how to empty

2017-01-09 Thread Matt .
I think it did. Cluster exists 4 years now, hosted engine 7 months. 2017-01-08 13:50 GMT+01:00 Shirly Radco : > No. But the delete process might have kicked in. > How long does you environment exist? > > Best regards, > > Shirly Radco > > BI Software Engineer > Red Hat Israel

Re: [ovirt-users] Large DWH Database, how to empty

2017-01-08 Thread Shirly Radco
No. But the delete process might have kicked in. How long does you environment exist? Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Sun, Jan 8, 2017 at 2:42 PM, Matt . wrote: >

Re: [ovirt-users] Large DWH Database, how to empty

2017-01-08 Thread Matt .
Hi, OK thanks! I saw that after upgrading to 4.0.5 from 4.0.4 the DB already dropped with around 500MB directly and is now at 2GB smaller. Does this sounds familiar to you with other settings in 4.0.5 ? Thanks, Matt 2017-01-08 10:45 GMT+01:00 Shirly Radco : > No. That will

[ovirt-users] Large DWH Database, how to empty

2017-01-06 Thread Matt .
Hi, I seem to have some large database for the DWH logging and I wonder how I can empty it safely. Can I just simply empty the database ? Have a good weekend! Cheers, Matt ___ Users mailing list Users@ovirt.org