Hi Shirly, The reason why I ask is because the explanation here: https://access.redhat.com/documentation/en/red-hat-virtualization/4.0/single... 2017-01-24 10:49 GMT+01:00 Shirly Radco <sradco@redhat.com>:
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 dashboards use the information from the samples and hourly tables for the last 24 hours.
This file will overwrite the default configurations after you restart ovirt-engine-dwhd.
Best regards,
Shirly Radco
BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109
On Tue, Jan 24, 2017 at 11:43 AM, Matt . <yamakasi.014@gmail.com> wrote:
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@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@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@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@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@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