<div dir="ltr">Please see at the to of this section:<div>"<span style="color:rgb(51,51,51);font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px">The following is a list of options for configuring application settings for the Data Warehouse service. These options are available in the</span><span style="color:rgb(51,51,51);font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px"> </span><code class="gmail-filename" style="color:rgb(51,51,51);box-sizing:border-box;font-family:consolas,monaco,"andale mono",monospace;font-size:14.4px;padding:2px 4px;background-color:rgb(247,247,247);border-radius:0px">/usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.conf</code><span style="color:rgb(51,51,51);font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px"> </span><span style="color:rgb(51,51,51);font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px">file. </span><font color="#000000"><b><span style="font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px">Configure any changes to the default values in an override file under</span><span style="font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px"> </span><code class="gmail-filename" style="box-sizing:border-box;font-family:consolas,monaco,"andale mono",monospace;font-size:14.4px;padding:2px 4px;background-color:rgb(247,247,247);border-radius:0px">/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/</code><span style="font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px">. Restart the Data Warehouse service after saving the changes.</span><span style="font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px">"</span></b></font></div><div><span style="color:rgb(51,51,51);font-family:overpass,"open sans",helvetica,sans-serif;font-size:16px"><br></span></div><div><span style="color:rgb(51,51,51)"><font face="arial, helvetica, sans-serif">So you need to add a file under </font></span><b style="color:rgb(0,0,0)"><code class="gmail-filename" style="box-sizing:border-box;font-family:consolas,monaco,"andale mono",monospace;font-size:14.4px;padding:2px 4px;background-color:rgb(247,247,247);border-radius:0px">/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/</code></b></div><div>The file name is not important. It should end with ".conf"</div><div class="gmail_extra"><br clear="all"><div><div class="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 Wed, Jan 25, 2017 at 1:06 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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Shirly,<br>
<br>
The reason why I ask is because the explanation here:<br>
<br>
<a href="https://access.redhat.com/documentation/en/red-hat-virtualization/4.0/single/data-warehouse-guide/#Application_Settings_for_the_Data_Warehouse_service_in_ovirt-engine-dwhd.conf" rel="noreferrer" target="_blank">https://access.redhat.com/<wbr>documentation/en/red-hat-<wbr>virtualization/4.0/single/<wbr>data-warehouse-guide/#<wbr>Application_Settings_for_the_<wbr>Data_Warehouse_service_in_<wbr>ovirt-engine-dwhd.conf</a><br>
<div class="gmail-HOEnZb"><div class="gmail-h5"><br>
<br>
2017-01-24 10:49 GMT+01:00 Shirly Radco <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>>:<br>
> Hi,<br>
><br>
> We don't update the ovirt-engine-dwhd.conf directly.<br>
><br>
> You need to add the new file to /ovirt-engine-dwhd.conf.d/ with the lines<br>
> DWH_TABLES_KEEP_SAMPLES=<br>
> DWH_TABLES_KEEP_HOURLY=<br>
> DWH_TABLES_KEEP_DAILY=0<br>
><br>
> and set the values for how much time you want the data to be kept.<br>
> Keep in mind that the dashboards use the information from the samples and<br>
> hourly tables for the last 24 hours.<br>
><br>
> This file will overwrite the default configurations after you restart<br>
> ovirt-engine-dwhd.<br>
><br>
><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 Tue, Jan 24, 2017 at 11:43 AM, Matt . <<a href="mailto:yamakasi.014@gmail.com">yamakasi.014@gmail.com</a>> wrote:<br>
>><br>
>> 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>
>><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<br>
>> >>> > dashboards?<br>
>> >>> ><br>
>> >>> > Please set the delete thresholds to save less data and the data<br>
>> >>> > 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<br>
>> >>> > 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<br>
>> >>> > (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>><br>
>> >>> > 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>
><br>
><br>
</div></div></blockquote></div><br></div></div>