[ovirt-users] Limit DWH database size

[nicolas at devels.es]

I tried adjusting the DWH_TABLES_KEEP_HOURLY parameter to a very low 
value and also setting the DWH_SAMPLING parameter to 60 and restarted 
both ovirt-engine-dwhd and ovirt-engine daemons, however, the database 
is still huge.

So even if I change those parameters should I manually clean up the 
database? If so, what's the recommended way?

Thanks.

El 2016-09-01 19:26, Shirly Radco escribió:
> Another option is to set the DWH_SAMPLING back to 60  and restart
> dwh.
>  This will lower the granularity of the dashboard calculations.
>  The dwh db size grow since now it samples the statistics every 15
> seconds instead of once a minute.
> 
> Best regards,
>  Shirly Radco
> 
> On Sep 1, 2016 19:29, <nicolas at devels.es> wrote:
> 
>> Hi Didi,
>> 
>> El 2016-09-01 14:02, Yedidyah Bar David escribió:
>> On Thu, Sep 1, 2016 at 3:26 PM, Sandro Bonazzola
>> <sbonazzo at redhat.com>
>> wrote:
>> 
>> Didi, Shirly, can you help here?
>> 
>> On Thu, Sep 1, 2016 at 8:52 AM, <nicolas at devels.es> wrote:
>> 
>> Hi,
>> 
>> Since we upgraded to 4.0.x, DWH's PostgreSQL database is getting
>> really huge. Is there a clean way to limit its size, like setting
>> a maximal retention time for DWH data?
> 
>  Earlier today replied to a similar question, search list archives for
>  "Change Engine History Logging from Advanched to Basic".
> 
>  Just to confirm: I already have basic DWH configured, and the content
> of /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf
> is:
> 
>    DWH_TABLES_KEEP_SAMPLES=24
>    DWH_TABLES_KEEP_HOURLY=720
>    DWH_TABLES_KEEP_DAILY=0
> 
>  So according to [1] regarding "DWH_TABLES_KEEP_HOURLY":
> 
>    The number of hours that hourly data is stored. The default is 60
> days.
>    Hourly data more than two days old is aggregated into dailydata.
> 
>  if I reduce that value to say 240 (10 days), any older entry from
> that should be erased upon a DWH restart, right?
> 
>  Thanks.
> 
>    [1]:
> https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.6/pdf/Reports_and_Data_Warehouse_Guide/Red_Hat_Enterprise_Virtualization-3.6-Reports_and_Data_Warehouse_Guide-en-US.pdf
> [3]
> 
>> Best,
>> 
>>  
>> 
>> Thanks.
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users [1] [1]
>> 
>> --
>> 
>> Sandro Bonazzola
>> Better technology. Faster innovation. Powered by community
>> collaboration.
>> See how it works at redhat.com [2] [2]
>> 
>> [3]
> 
>  --
> 
>  Didi
> 
>  Links:
>  ------
>  [1] http://lists.ovirt.org/mailman/listinfo/users [1]
>  [2] http://redhat.com [2]
>  [3]
> https://www.redhat.com/it/about/events/red-hat-open-source-day-2016
> [4]
> 
> 
> Links:
> ------
> [1] http://lists.ovirt.org/mailman/listinfo/users
> [2] http://redhat.com
> [3]
> https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.6/pdf/Reports_and_Data_Warehouse_Guide/Red_Hat_Enterprise_Virtualization-3.6-Reports_and_Data_Warehouse_Guide-en-US.pdf
> [4] https://www.redhat.com/it/about/events/red-hat-open-source-day-2016