<div dir="ltr"><div>Hi,</div><div><br></div>We don't update the <span style="font-size:12.8px">ovirt-engine-dwhd.conf directly.</span><div><span style="font-size:12.8px"><br></span><div><span style="font-size:12.8px">You need to add the new file to </span><span style="font-size:12.8px"> </span><span style="font-size:12.8px">/ovirt-engine-dwhd.conf.d/ with the lines</span></div><div><div style="font-size:12.8px">DWH_TABLES_KEEP_SAMPLES=<br></div><div style="font-size:12.8px">DWH_TABLES_KEEP_HOURLY=</div><div style="font-size:12.8px">DWH_TABLES_KEEP_DAILY=0</div></div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">and set the values for how much time you want the data to be kept.</div><div style="font-size:12.8px">Keep in mind that the dashboards use the information from the samples and hourly tables for the last 24 hours.</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">This file will overwrite the default configurations after you restart ovirt-engine-dwhd.</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px"><br></div></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 Tue, Jan 24, 2017 at 11:43 AM, 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">Shirly,<br>
<br>
I'm checking this out and aren't you sure the file is<br>
update_time_to_keep_records.<wbr>conf and not ovirt-engine-dwhd.conf ?<br>
<div class="HOEnZb"><div class="h5"><br>
2017-01-09 14:01 GMT+01:00 Matt . <<a href="mailto:yamakasi.014@gmail.com">yamakasi.014@gmail.com</a>>:<br>
> I think it did. Cluster exists 4 years now, hosted engine 7 months.<br>
><br>
> 2017-01-08 13:50 GMT+01:00 Shirly Radco <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>>:<br>
>> No. But the delete process might have kicked in.<br>
>> How long does you environment exist?<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 Sun, Jan 8, 2017 at 2:42 PM, Matt . <<a href="mailto:yamakasi.014@gmail.com">yamakasi.014@gmail.com</a>> wrote:<br>
>>><br>
>>> 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>
>>><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<br>
>>> > 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<br>
>>> > 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>
>><br>
>><br>
</div></div></blockquote></div><br></div>