cloudstack-users mailing list archives

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

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 -

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 [] 
Sent: Tuesday, January 06, 2015 5:06 AM
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?



View raw message