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....@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 <sra...@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....@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 <sra...@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....@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@ovirt.org >>> >> http://lists.ovirt.org/mailman/listinfo/users >>> > >>> > >> >> _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users