Mailing-List: contact users-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cloudstack.apache.org
Received-SPF: pass (athena.apache.org: domain of Suresh.Sadhu@citrix.com
 designates 185.25.65.24 as permitted sender)
From: Suresh Sadhu <Suresh.Sadhu@citrix.com>
To: "users@cloudstack.apache.org" <users@cloudstack.apache.org>
Subject: RE: How to reduce the size of the cloud_usage database
Thread-Topic: How to reduce the size of the cloud_usage database
Thread-Index: AdApyedxhKquI7YJQwWR/otyKlHFCwAAlupw
Date: Tue, 6 Jan 2015 16:20:48 +0000
Message-ID: 
 <5A4FE8EFA8C8584CBEFEEACD9AA077EE50C49863@SINPEX01CL03.citrite.net>
References: 
 <BC047208AFA8C3429141743ADC8C561D5620F815@SINPEX01CL02.citrite.net>
In-Reply-To: 
 <BC047208AFA8C3429141743ADC8C561D5620F815@SINPEX01CL02.citrite.net>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

+1 for  implementing  this option -  which will reduce  upgrade time window=
 as well.

-----Original Message-----
From: Somesh Naidu [mailto:Somesh.Naidu@citrix.com]=20
Sent: 06 January 2015 21:31
To: users@cloudstack.apache.org
Subject: RE: How to reduce the size of the cloud_usage database

Just saw this ...

> new (global) configuration option to limit size

+1 for the above.

It would be useful to have similar functionality developed for cloud_usage =
as we have for alerts and events, see below:

+----------------------+---------------------------------------------------=
-------------------------------------------------+
| name                 | description                                       =
                                                 |
+----------------------+---------------------------------------------------=
-------------------------------------------------+
| alert.purge.delay    | Alerts older than specified number days will be pu=
rged. Set this value to 0 to never delete alerts |
| alert.purge.interval | The interval (in seconds) to wait before running t=
he alert purge thread                            |
| event.purge.delay    | Events older than specified number days will be pu=
rged. Set this value to 0 to never delete events |
| event.purge.interval | The interval (in seconds) to wait before running t=
he event purge thread                            |
+----------------------+---------------------------------------------------=
-------------------------------------------------+

-----Original Message-----
From: Rohit Yadav [mailto:rohit.yadav@shapeblue.com]
Sent: Tuesday, January 06, 2015 6:22 AM
To: users@cloudstack.apache.org
Subject: Re: How to reduce the size of the cloud_usage database

Hi David,

There is no official way to reduce the size of the cloud_usage database as =
it gets populated from the cloud database.

Can you share why you want to reduce it? Are you're facing any MySQL perfor=
mance issues?

If your DB size is causing problems we could work with you to develop a new=
 (global) configuration option to limit size or an API to limit past/histor=
ic data.

On Tuesday 06 January 2015 03:36 PM, David Williams wrote:
> Hi all,
>
> Is there an "official" procedure on how to reduce the size of the cloud_u=
sage database?
>
> Thanks,
>
> Dave

Regards,
Rohit Yadav
Software Architect, ShapeBlue
M. +91 8826230892 | rohit.yadav@shapeblue.com
Blog: bhaisaab.org | Twitter: @_bhaisaab PS. If you see any footer below, I=
 did not add it :) Find out more about ShapeBlue and our range of CloudStac=
k related services

IaaS Cloud Design & Build<http://shapeblue.com/iaas-cloud-design-and-build/=
/>
CSForge - rapid IaaS deployment framework<http://shapeblue.com/csforge/>
CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/>
CloudStack Software Engineering<http://shapeblue.com/cloudstack-software-en=
gineering/>
CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastru=
cture-support/>
CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-traini=
ng/>

This email and any attachments to it may be confidential and are intended s=
olely for the use of the individual to whom it is addressed. Any views or o=
pinions expressed are solely those of the author and do not necessarily rep=
resent those of Shape Blue Ltd or related companies. If you are not the int=
ended recipient of this email, you must neither take any action based upon =
its contents, nor copy or show it to anyone. Please contact the sender if y=
ou believe you have received this email in error. Shape Blue Ltd is a compa=
ny incorporated in England & Wales. ShapeBlue Services India LLP is a compa=
ny incorporated in India and is operated under license from Shape Blue Ltd.=
 Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and=
 is operated under license from Shape Blue Ltd. ShapeBlue SA Pty Ltd is a c=
ompany registered by The Republic of South Africa and is traded under licen=
se from Shape Blue Ltd. ShapeBlue is a registered trademark.