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

[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 . <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
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170108/92be4d78/attachment.html>