<div dir="ltr">No. But the delete process might have kicked in.<div>How long does you environment exist?</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Best regards,</span></pre><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Shirly Radco</span></pre><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109</span></pre></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Sun, Jan 8, 2017 at 2:42 PM, Matt . <span dir="ltr"><<a href="mailto:yamakasi.014@gmail.com" target="_blank">yamakasi.014@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
OK thanks! I saw that after upgrading to 4.0.5 from 4.0.4 the DB<br>
already dropped with around 500MB directly and is now at 2GB smaller.<br>
<br>
Does this sounds familiar to you with other settings in 4.0.5 ?<br>
<br>
<br>
Thanks,<br>
<br>
Matt<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
<br>
2017-01-08 10:45 GMT+01:00 Shirly Radco <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>>:<br>
> No. That will corrupt your database.<br>
><br>
> Are you using the full dwh or the smaller version for the dashboards?<br>
><br>
> Please set the delete thresholds to save less data and the data older then<br>
> the time you set will be deleted.<br>
> Add a file to /ovirt-engine-dwhd.conf.d/<br>
> update_time_to_keep_records.<wbr>conf<br>
><br>
> Add these lines with the new configurations. The numbers represent the hours<br>
> to keep the data.<br>
><br>
> DWH_TABLES_KEEP_SAMPLES=24<br>
> DWH_TABLES_KEEP_HOURLY=1440<br>
> DWH_TABLES_KEEP_DAILY=43800<br>
><br>
><br>
> These are the configurations for a full dwh.<br>
><br>
> The smaller version configurations are:<br>
> DWH_TABLES_KEEP_SAMPLES=24<br>
> DWH_TABLES_KEEP_HOURLY=720<br>
> DWH_TABLES_KEEP_DAILY=0<br>
><br>
> The delete process by default at 3am every day (DWH_DELETE_JOB_HOUR=3)<br>
><br>
> Best regards,<br>
><br>
> Shirly Radco<br>
><br>
> BI Software Engineer<br>
> Red Hat Israel Ltd.<br>
> 34 Jerusalem Road<br>
> Building A, 4th floor<br>
> Ra'anana, Israel 4350109<br>
><br>
><br>
> On Fri, Jan 6, 2017 at 6:35 PM, Matt . <<a href="mailto:yamakasi.014@gmail.com">yamakasi.014@gmail.com</a>> wrote:<br>
>><br>
>> Hi,<br>
>><br>
>> I seem to have some large database for the DWH logging and I wonder<br>
>> how I can empty it safely.<br>
>><br>
>> Can I just simply empty the database ?<br>
>><br>
>> Have a good weekend!<br>
>><br>
>> Cheers,<br>
>><br>
>> Matt<br>
>> ______________________________<wbr>_________________<br>
>> Users mailing list<br>
>> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
>> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
><br>
><br>
</div></div></blockquote></div><br></div>