[ovirt-users] Limit DWH database size
nicolas at devels.es
nicolas at devels.es
Fri Sep 2 09:07:23 UTC 2016
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?
El 2016-09-01 19:26, Shirly Radco escribió:
> Another option is to set the DWH_SAMPLING back to 60 and restart
> 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>
>> Didi, Shirly, can you help here?
>> On Thu, Sep 1, 2016 at 8:52 AM, <nicolas at devels.es> wrote:
>> 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
> So according to  regarding "DWH_TABLES_KEEP_HOURLY":
> The number of hours that hourly data is stored. The default is 60
> 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?
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users  
>> Sandro Bonazzola
>> Better technology. Faster innovation. Powered by community
>> See how it works at redhat.com  
>  http://lists.ovirt.org/mailman/listinfo/users 
>  http://redhat.com 
>  http://lists.ovirt.org/mailman/listinfo/users
>  http://redhat.com
>  https://www.redhat.com/it/about/events/red-hat-open-source-day-2016
More information about the Users