Re: How to reduce the size of the cloud_usage database

2015-01-23 Thread Rohit Yadav
> On 23-Jan-2015, at 8:40 pm, Abhinandan Prateek > wrote: > > Will this also take care of usage server not regenerating usage data on > restart before a certain cut-off date ? Since this is an API, its usage is at the discretion of the admin. This has nothing to do with server not generating

Re: How to reduce the size of the cloud_usage database

2015-01-23 Thread Abhinandan Prateek
Will this also take care of usage server not regenerating usage data on restart before a certain cut-off date ? > On 23-Jan-2015, at 7:43 pm, Rohit Yadav wrote: > > Hi, > > Instead of a automatic thread that would clean up cloud_usage database, I’ve > implemented a new API (removeRawUsageRecord

Re: How to reduce the size of the cloud_usage database

2015-01-23 Thread Rohit Yadav
Hi, Instead of a automatic thread that would clean up cloud_usage database, I’ve implemented a new API (removeRawUsageRecords) that will be available with 4.6.0 and above. It takes an interval parameter which is an integer greater than 0, and this API when called removes all records from cloud_

Re: How to reduce the size of the cloud_usage database

2015-01-12 Thread Rohit Yadav
From: Rohit Yadav [mailto:rohit.ya...@shapeblue.com] > Sent: Tuesday, January 06, 2015 11:22 > 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 red

RE: How to reduce the size of the cloud_usage database

2015-01-12 Thread David Williams
11:22 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 redu

Re: How to reduce the size of the cloud_usage database

2015-01-07 Thread Rene Moser
Hi On 01/06/2015 11:06 AM, David Williams wrote: > Is there an "official" procedure on how to reduce the size of the cloud_usage > database? We are using pt-archiver [1] which is included in the percona-toolkit [2]. It may be already in your Linux distro [3] as well. Yours René [1] http://www

RE: How to reduce the size of the cloud_usage database

2015-01-06 Thread Suresh Sadhu
+1 for implementing this option - which will reduce upgrade time window as well. -Original Message- From: Somesh Naidu [mailto:somesh.na...@citrix.com] Sent: 06 January 2015 21:31 To: users@cloudstack.apache.org Subject: RE: How to reduce the size of the cloud_usage database Just

RE: How to reduce the size of the cloud_usage database

2015-01-06 Thread Somesh Naidu
ead| +--++ -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 s

RE: How to reduce the size of the cloud_usage database

2015-01-06 Thread Somesh Naidu
ead| +--++ -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 s

RE: How to reduce the size of the cloud_usage database

2015-01-06 Thread Somesh Naidu
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 wil

Re: How to reduce the size of the cloud_usage database

2015-01-06 Thread Rohit Yadav
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 (g