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

[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 . <yamakasi.014 at gmail.com>:
> I think it did. Cluster exists 4 years now, hosted engine 7 months.
>
> 2017-01-08 13:50 GMT+01:00 Shirly Radco <sradco at redhat.com>:
>> 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 . <yamakasi.014 at gmail.com> wrote:
>>>
>>> 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 <sradco at redhat.com>:
>>> > No. That will corrupt your database.
>>> >
>>> > Are you using the full dwh or the smaller version for the dashboards?
>>> >
>>> > Please set the delete thresholds to save less data and the data older
>>> > then
>>> > the time you set will be deleted.
>>> > Add a file to /ovirt-engine-dwhd.conf.d/
>>> > update_time_to_keep_records.conf
>>> >
>>> > Add these lines with the new configurations. The numbers represent the
>>> > hours
>>> > to keep the data.
>>> >
>>> > DWH_TABLES_KEEP_SAMPLES=24
>>> > DWH_TABLES_KEEP_HOURLY=1440
>>> > DWH_TABLES_KEEP_DAILY=43800
>>> >
>>> >
>>> > These are the configurations for a full dwh.
>>> >
>>> > The smaller version configurations are:
>>> > DWH_TABLES_KEEP_SAMPLES=24
>>> > DWH_TABLES_KEEP_HOURLY=720
>>> > DWH_TABLES_KEEP_DAILY=0
>>> >
>>> > The delete process by default at 3am every day (DWH_DELETE_JOB_HOUR=3)
>>> >
>>> > Best regards,
>>> >
>>> > Shirly Radco
>>> >
>>> > BI Software Engineer
>>> > Red Hat Israel Ltd.
>>> > 34 Jerusalem Road
>>> > Building A, 4th floor
>>> > Ra'anana, Israel 4350109
>>> >
>>> >
>>> > On Fri, Jan 6, 2017 at 6:35 PM, Matt . <yamakasi.014 at gmail.com> wrote:
>>> >>
>>> >> 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 at ovirt.org
>>> >> http://lists.ovirt.org/mailman/listinfo/users
>>> >
>>> >
>>
>>