cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Somesh Naidu <Somesh.Na...@citrix.com>
Subject RE: How to reduce the size of the cloud_usage database
Date Tue, 06 Jan 2015 15:33:15 GMT
Dave,

Deleting records from cloud_usage is safe and permitted. These records are not used by any
CS functionality. This data (raw usage data) is consumed by entities external to CS (billing
software, etc). This data is exposed by CS via listUsage API. Deleting records from cloud_usage
table will only cause this API to not return raw usage pertaining to those deleted records
but not cause the API to break/crash.

I had written a KB article for Citrix Cloudplatform on this subject as well - http://support.citrix.com/article/CTX139043

You cloud replace "truncate table" with "delete from" with a where clause if you wanted to
keep records until certain time and purge older, something like below:
delete from cloud_usage where start_date < date_sub(current_date(), interval 30 day);

Hope that helps.

-----Original Message-----
From: David Williams [mailto:David.Williams@interoute.com] 
Sent: Tuesday, January 06, 2015 5:06 AM
To: users@cloudstack.apache.org
Subject: How to reduce the size of the cloud_usage database

Hi all,

Is there an "official" procedure on how to reduce the size of the cloud_usage database?

Thanks,

Dave



Mime
View raw message