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

I think it did. Cluster exists 4 years now, hosted engine 7 months. 2017-01-08 13:50 GMT+01:00 Shirly Radco <sradco(a)redhat.com&gt;: > 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(a)gmail.com&gt; 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(a)redhat.com&gt;: >> > 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(a)gmail.com&gt; 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(a)ovirt.org >> >> http://lists.ovirt.org/mailman/listinfo/users >> > >> > > >