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