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
purged. Set this value to 0 to never delete alerts |
| alert.purge.interval | The interval (in seconds) to wait before running the
alert purge thread |
| event.purge.delay | Events older than specified number days will be
purged. Set this value to 0 to never delete events |
| event.purge.interval | The interval (in seconds) to wait before running the
event purge thread |
+----------------------+----------------------------------------------------------------------------------------------------+
-----Original Message-----
From: Rohit Yadav [mailto:rohit.ya...@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
performance 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/historic 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_usage
> database?
>
> Thanks,
>
> Dave
Regards,
Rohit Yadav
Software Architect, ShapeBlue
M. +91 8826230892 | rohit.ya...@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 CloudStack 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-engineering/>
CloudStack Infrastructure
Support<http://shapeblue.com/cloudstack-infrastructure-support/>
CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-training/>
This email and any attachments to it may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Shape Blue Ltd or related companies. If you are not the
intended 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 you
believe you have received this email in error. Shape Blue Ltd is a company
incorporated in England & Wales. ShapeBlue Services India LLP is a company
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 company
registered by The Republic of South Africa and is traded under license from
Shape Blue Ltd. ShapeBlue is a registered trademark.
