Return-Path: X-Original-To: apmail-cloudstack-users-archive@www.apache.org Delivered-To: apmail-cloudstack-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EDBF3178D1 for ; Fri, 23 Jan 2015 15:12:04 +0000 (UTC) Received: (qmail 64553 invoked by uid 500); 23 Jan 2015 15:12:04 -0000 Delivered-To: apmail-cloudstack-users-archive@cloudstack.apache.org Received: (qmail 64502 invoked by uid 500); 23 Jan 2015 15:12:04 -0000 Mailing-List: contact users-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@cloudstack.apache.org Delivered-To: mailing list users@cloudstack.apache.org Received: (qmail 64490 invoked by uid 99); 23 Jan 2015 15:12:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Jan 2015 15:12:03 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of abhinandan.prateek@shapeblue.com designates 157.56.112.143 as permitted sender) Received: from [157.56.112.143] (HELO emea01-am1-obe.outbound.protection.outlook.com) (157.56.112.143) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Jan 2015 15:11:58 +0000 Received: from DB4PR07MB0541.eurprd07.prod.outlook.com (10.242.195.20) by DB4PR07MB0543.eurprd07.prod.outlook.com (10.242.195.22) with Microsoft SMTP Server (TLS) id 15.1.59.20; Fri, 23 Jan 2015 15:10:54 +0000 Received: from DB4PR07MB0541.eurprd07.prod.outlook.com ([10.242.195.20]) by DB4PR07MB0541.eurprd07.prod.outlook.com ([10.242.195.20]) with mapi id 15.01.0059.007; Fri, 23 Jan 2015 15:10:53 +0000 From: Abhinandan Prateek To: "users@cloudstack.apache.org" CC: "David.Williams@interoute.com" Subject: Re: How to reduce the size of the cloud_usage database Thread-Topic: How to reduce the size of the cloud_usage database Thread-Index: AdApmCJ/hKquI7YJQwWR/otyKlHFCwACuXWAAABVYgABWH0/AAIEGlYAAAICioA= Date: Fri, 23 Jan 2015 15:10:53 +0000 Message-ID: <15BF0462-38D6-4CF8-91EC-673317A9065F@shapeblue.com> References: <9B3B2E4F79F7A14B990E92C561CC1610A40ED0E7@CZPREXMBX01.interoute.com> <54ABC56B.2030300@shapeblue.com> <9B3B2E4F79F7A14B990E92C561CC1610A40ED20C@CZPREXMBX01.interoute.com> <8258531A-7D6D-4683-ACEF-4C78D12B0C5E@shapeblue.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [1.186.104.34] authentication-results: cloudstack.apache.org; dkim=none (message not signed) header.d=none;cloudstack.apache.org; dmarc=none action=none header.from=shapeblue.com; x-dmarcaction-test: None x-microsoft-antispam: BCL:0;PCL:0;RULEID:(3005004);SRVR:DB4PR07MB0543; x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:;SRVR:DB4PR07MB0543; x-forefront-prvs: 0465429B7F x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(13734003)(51704005)(24454002)(377454003)(43544003)(2950100001)(92566002)(40100003)(66066001)(83716003)(86362001)(19580405001)(102836002)(15975445007)(77096005)(2900100001)(77156002)(46102003)(62966003)(122556002)(93886004)(87936001)(50986999)(15395725005)(2501002)(76176999)(2656002)(82746002)(33656002)(19580395003)(2351001)(110136001)(54356999)(36756003)(104396002);DIR:OUT;SFP:1102;SCL:1;SRVR:DB4PR07MB0543;H:DB4PR07MB0541.eurprd07.prod.outlook.com;FPR:;SPF:None;MLV:sfv;LANG:en; Content-Type: text/plain; charset="utf-8" Content-ID: <4DBFE7BC8106DA41A80A941950FD73D0@eurprd07.prod.outlook.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: shapeblue.com X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Jan 2015 15:10:53.6095 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: fc8906f6-e50e-4dad-98a0-ec2e3abe14f5 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB4PR07MB0543 X-Virus-Checked: Checked by ClamAV on apache.org V2lsbCB0aGlzIGFsc28gdGFrZSBjYXJlIG9mIHVzYWdlIHNlcnZlciBub3QgcmVnZW5lcmF0aW5n IHVzYWdlIGRhdGEgb24gcmVzdGFydCBiZWZvcmUgYSBjZXJ0YWluIGN1dC1vZmYgZGF0ZSA/DQoN Cj4gT24gMjMtSmFuLTIwMTUsIGF0IDc6NDMgcG0sIFJvaGl0IFlhZGF2IDxyb2hpdC55YWRhdkBz aGFwZWJsdWUuY29tPiB3cm90ZToNCj4NCj4gSGksDQo+DQo+IEluc3RlYWQgb2YgYSBhdXRvbWF0 aWMgdGhyZWFkIHRoYXQgd291bGQgY2xlYW4gdXAgY2xvdWRfdXNhZ2UgZGF0YWJhc2UsIEnigJl2 ZSBpbXBsZW1lbnRlZCBhIG5ldyBBUEkgKHJlbW92ZVJhd1VzYWdlUmVjb3JkcykgdGhhdCB3aWxs IGJlIGF2YWlsYWJsZSB3aXRoIDQuNi4wIGFuZCBhYm92ZS4gSXQgdGFrZXMgYW4gaW50ZXJ2YWwg cGFyYW1ldGVyIHdoaWNoIGlzIGFuIGludGVnZXIgZ3JlYXRlciB0aGFuIDAsIGFuZCB0aGlzIEFQ SSB3aGVuIGNhbGxlZCByZW1vdmVzIGFsbCByZWNvcmRzIGZyb20gY2xvdWRfdXNhZ2UuY2xvdWRf dXNhZ2UgdGFibGUgdGhhdCBhcmUgb2xkZXIgdGhhbiDigJhpbnRlcnZhbOKAmSBudW1iZXIgb2Yg ZGF5cy4gSXQgZmFpbHMgaW4gYSB3aW5kb3cgb2YgMTVtaW5zIHdoZW4gdXNpbmcgdGhlIHVzYWdl IGpvYiBleGVjIHRpbWUgKGFsc28gY29uc2lkZXJpbmcgdGhlIHRpbWV6b25lKSB3aGVuIHRoZSBB UEkgaXMgY2FsbGVkLg0KPg0KPiBGb3IgZGV0YWlscyB5b3UgbWF5IGZvbGxvdyBpdCBoZXJlOiBo dHRwczovL2lzc3Vlcy5hcGFjaGUub3JnL2ppcmEvYnJvd3NlL0NMT1VEU1RBQ0stODE1MQ0KPg0K PiBSZWdhcmRzLA0KPiBSb2hpdCBZYWRhdg0KPiBTb2Z0d2FyZSBBcmNoaXRlY3QsIFNoYXBlQmx1 ZQ0KPiBNLiArOTEgODggMjYyIDMwODkyIHwgcm9oaXQueWFkYXZAc2hhcGVibHVlLmNvbQ0KPiBC bG9nOiBiaGFpc2FhYi5vcmcgfCBUd2l0dGVyOiBAX2JoYWlzYWFiDQo+DQo+IEZpbmQgb3V0IG1v cmUgYWJvdXQgU2hhcGVCbHVlIGFuZCBvdXIgcmFuZ2Ugb2YgQ2xvdWRTdGFjayByZWxhdGVkIHNl cnZpY2VzDQo+DQo+IElhYVMgQ2xvdWQgRGVzaWduICYgQnVpbGQ8aHR0cDovL3NoYXBlYmx1ZS5j b20vaWFhcy1jbG91ZC1kZXNpZ24tYW5kLWJ1aWxkLy8+DQo+IENTRm9yZ2Ug4oCTIHJhcGlkIElh YVMgZGVwbG95bWVudCBmcmFtZXdvcms8aHR0cDovL3NoYXBlYmx1ZS5jb20vY3Nmb3JnZS8+DQo+ IENsb3VkU3RhY2sgQ29uc3VsdGluZzxodHRwOi8vc2hhcGVibHVlLmNvbS9jbG91ZHN0YWNrLWNv bnN1bHRhbmN5Lz4NCj4gQ2xvdWRTdGFjayBTb2Z0d2FyZSBFbmdpbmVlcmluZzxodHRwOi8vc2hh cGVibHVlLmNvbS9jbG91ZHN0YWNrLXNvZnR3YXJlLWVuZ2luZWVyaW5nLz4NCj4gQ2xvdWRTdGFj ayBJbmZyYXN0cnVjdHVyZSBTdXBwb3J0PGh0dHA6Ly9zaGFwZWJsdWUuY29tL2Nsb3Vkc3RhY2st aW5mcmFzdHJ1Y3R1cmUtc3VwcG9ydC8+DQo+IENsb3VkU3RhY2sgQm9vdGNhbXAgVHJhaW5pbmcg Q291cnNlczxodHRwOi8vc2hhcGVibHVlLmNvbS9jbG91ZHN0YWNrLXRyYWluaW5nLz4NCj4NCj4g VGhpcyBlbWFpbCBhbmQgYW55IGF0dGFjaG1lbnRzIHRvIGl0IG1heSBiZSBjb25maWRlbnRpYWwg YW5kIGFyZSBpbnRlbmRlZCBzb2xlbHkgZm9yIHRoZSB1c2Ugb2YgdGhlIGluZGl2aWR1YWwgdG8g d2hvbSBpdCBpcyBhZGRyZXNzZWQuIEFueSB2aWV3cyBvciBvcGluaW9ucyBleHByZXNzZWQgYXJl IHNvbGVseSB0aG9zZSBvZiB0aGUgYXV0aG9yIGFuZCBkbyBub3QgbmVjZXNzYXJpbHkgcmVwcmVz ZW50IHRob3NlIG9mIFNoYXBlIEJsdWUgTHRkIG9yIHJlbGF0ZWQgY29tcGFuaWVzLiBJZiB5b3Ug YXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50IG9mIHRoaXMgZW1haWwsIHlvdSBtdXN0IG5l aXRoZXIgdGFrZSBhbnkgYWN0aW9uIGJhc2VkIHVwb24gaXRzIGNvbnRlbnRzLCBub3IgY29weSBv ciBzaG93IGl0IHRvIGFueW9uZS4gUGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlciBpZiB5b3UgYmVs aWV2ZSB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGVtYWlsIGluIGVycm9yLiBTaGFwZSBCbHVlIEx0 ZCBpcyBhIGNvbXBhbnkgaW5jb3Jwb3JhdGVkIGluIEVuZ2xhbmQgJiBXYWxlcy4gU2hhcGVCbHVl IFNlcnZpY2VzIEluZGlhIExMUCBpcyBhIGNvbXBhbnkgaW5jb3Jwb3JhdGVkIGluIEluZGlhIGFu ZCBpcyBvcGVyYXRlZCB1bmRlciBsaWNlbnNlIGZyb20gU2hhcGUgQmx1ZSBMdGQuIFNoYXBlIEJs dWUgQnJhc2lsIENvbnN1bHRvcmlhIEx0ZGEgaXMgYSBjb21wYW55IGluY29ycG9yYXRlZCBpbiBC cmFzaWwgYW5kIGlzIG9wZXJhdGVkIHVuZGVyIGxpY2Vuc2UgZnJvbSBTaGFwZSBCbHVlIEx0ZC4g U2hhcGVCbHVlIFNBIFB0eSBMdGQgaXMgYSBjb21wYW55IHJlZ2lzdGVyZWQgYnkgVGhlIFJlcHVi bGljIG9mIFNvdXRoIEFmcmljYSBhbmQgaXMgdHJhZGVkIHVuZGVyIGxpY2Vuc2UgZnJvbSBTaGFw ZSBCbHVlIEx0ZC4gU2hhcGVCbHVlIGlzIGEgcmVnaXN0ZXJlZCB0cmFkZW1hcmsuDQoNCkZpbmQg b3V0IG1vcmUgYWJvdXQgU2hhcGVCbHVlIGFuZCBvdXIgcmFuZ2Ugb2YgQ2xvdWRTdGFjayByZWxh dGVkIHNlcnZpY2VzDQoNCklhYVMgQ2xvdWQgRGVzaWduICYgQnVpbGQ8aHR0cDovL3NoYXBlYmx1 ZS5jb20vaWFhcy1jbG91ZC1kZXNpZ24tYW5kLWJ1aWxkLy8+DQpDU0ZvcmdlIOKAkyByYXBpZCBJ YWFTIGRlcGxveW1lbnQgZnJhbWV3b3JrPGh0dHA6Ly9zaGFwZWJsdWUuY29tL2NzZm9yZ2UvPg0K Q2xvdWRTdGFjayBDb25zdWx0aW5nPGh0dHA6Ly9zaGFwZWJsdWUuY29tL2Nsb3Vkc3RhY2stY29u c3VsdGFuY3kvPg0KQ2xvdWRTdGFjayBTb2Z0d2FyZSBFbmdpbmVlcmluZzxodHRwOi8vc2hhcGVi bHVlLmNvbS9jbG91ZHN0YWNrLXNvZnR3YXJlLWVuZ2luZWVyaW5nLz4NCkNsb3VkU3RhY2sgSW5m cmFzdHJ1Y3R1cmUgU3VwcG9ydDxodHRwOi8vc2hhcGVibHVlLmNvbS9jbG91ZHN0YWNrLWluZnJh c3RydWN0dXJlLXN1cHBvcnQvPg0KQ2xvdWRTdGFjayBCb290Y2FtcCBUcmFpbmluZyBDb3Vyc2Vz PGh0dHA6Ly9zaGFwZWJsdWUuY29tL2Nsb3Vkc3RhY2stdHJhaW5pbmcvPg0KDQpUaGlzIGVtYWls IGFuZCBhbnkgYXR0YWNobWVudHMgdG8gaXQgbWF5IGJlIGNvbmZpZGVudGlhbCBhbmQgYXJlIGlu dGVuZGVkIHNvbGVseSBmb3IgdGhlIHVzZSBvZiB0aGUgaW5kaXZpZHVhbCB0byB3aG9tIGl0IGlz IGFkZHJlc3NlZC4gQW55IHZpZXdzIG9yIG9waW5pb25zIGV4cHJlc3NlZCBhcmUgc29sZWx5IHRo b3NlIG9mIHRoZSBhdXRob3IgYW5kIGRvIG5vdCBuZWNlc3NhcmlseSByZXByZXNlbnQgdGhvc2Ug b2YgU2hhcGUgQmx1ZSBMdGQgb3IgcmVsYXRlZCBjb21wYW5pZXMuIElmIHlvdSBhcmUgbm90IHRo ZSBpbnRlbmRlZCByZWNpcGllbnQgb2YgdGhpcyBlbWFpbCwgeW91IG11c3QgbmVpdGhlciB0YWtl IGFueSBhY3Rpb24gYmFzZWQgdXBvbiBpdHMgY29udGVudHMsIG5vciBjb3B5IG9yIHNob3cgaXQg dG8gYW55b25lLiBQbGVhc2UgY29udGFjdCB0aGUgc2VuZGVyIGlmIHlvdSBiZWxpZXZlIHlvdSBo YXZlIHJlY2VpdmVkIHRoaXMgZW1haWwgaW4gZXJyb3IuIFNoYXBlIEJsdWUgTHRkIGlzIGEgY29t cGFueSBpbmNvcnBvcmF0ZWQgaW4gRW5nbGFuZCAmIFdhbGVzLiBTaGFwZUJsdWUgU2VydmljZXMg SW5kaWEgTExQIGlzIGEgY29tcGFueSBpbmNvcnBvcmF0ZWQgaW4gSW5kaWEgYW5kIGlzIG9wZXJh dGVkIHVuZGVyIGxpY2Vuc2UgZnJvbSBTaGFwZSBCbHVlIEx0ZC4gU2hhcGUgQmx1ZSBCcmFzaWwg Q29uc3VsdG9yaWEgTHRkYSBpcyBhIGNvbXBhbnkgaW5jb3Jwb3JhdGVkIGluIEJyYXNpbCBhbmQg aXMgb3BlcmF0ZWQgdW5kZXIgbGljZW5zZSBmcm9tIFNoYXBlIEJsdWUgTHRkLiBTaGFwZUJsdWUg U0EgUHR5IEx0ZCBpcyBhIGNvbXBhbnkgcmVnaXN0ZXJlZCBieSBUaGUgUmVwdWJsaWMgb2YgU291 dGggQWZyaWNhIGFuZCBpcyB0cmFkZWQgdW5kZXIgbGljZW5zZSBmcm9tIFNoYXBlIEJsdWUgTHRk LiBTaGFwZUJsdWUgaXMgYSByZWdpc3RlcmVkIHRyYWRlbWFyay4NCg==