From dev-return-111018-archive-asf-public=cust-asf.ponee.io@cloudstack.apache.org Wed Mar 14 15:37:08 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id EFC01180654 for ; Wed, 14 Mar 2018 15:37:06 +0100 (CET) Received: (qmail 87760 invoked by uid 500); 14 Mar 2018 14:37:05 -0000 Mailing-List: contact dev-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list dev@cloudstack.apache.org Received: (qmail 87741 invoked by uid 99); 14 Mar 2018 14:37:04 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Mar 2018 14:37:04 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 52C6F1A0F59 for ; Wed, 14 Mar 2018 14:37:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.988 X-Spam-Level: X-Spam-Status: No, score=0.988 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H5=-1, RCVD_IN_MSPIKE_WL=-0.01, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=shapeblue.onmicrosoft.com header.b=Oy/Kxwar; dkim=fail (1024-bit key) reason="fail (body has been altered)" header.d=shapeblue.onmicrosoft.com header.b=I+o37m+E Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id jQ6KW89aU1tp for ; Wed, 14 Mar 2018 14:37:01 +0000 (UTC) Received: from EUR01-DB5-obe.outbound.protection.outlook.com (mail-db5eur01on0093.outbound.protection.outlook.com [104.47.2.93]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 049B65F475 for ; Wed, 14 Mar 2018 14:37:00 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=shapeblue.onmicrosoft.com; s=selector1-shapeblue-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=H4mC/qIlCqchxUf/epc5d8Gi3zHo0qPXV76TgJlNnuU=; b=Oy/Kxwart+AejkHv7E488JmlkHUi5NVg+A5/5WxcrqFVlICajOVzcKWrphdotFD1CgJ1qZZasDxVHWoRDB62RCirWFceW/ljzh1B76wNs+kmjQ6tjXx2LMycUymmmjp2v6gicJWMcRBx/vYNVp+jC8Q0n6tMWbelm1D+3hgig4w= Received: from VI1PR07CA0035.eurprd07.prod.outlook.com (2a01:111:e400:533d::45) by HE1PR07MB1643.eurprd07.prod.outlook.com (2a01:111:e400:c521::27) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.588.7; Wed, 14 Mar 2018 14:36:53 +0000 Received: from HE1EUR01FT053.eop-EUR01.prod.protection.outlook.com (2a01:111:f400:7e1f::206) by VI1PR07CA0035.outlook.office365.com (2a01:111:e400:533d::45) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.588.7 via Frontend Transport; Wed, 14 Mar 2018 14:36:52 +0000 Received-SPF: Fail (protection.outlook.com: domain of shapeblue.com does not designate 104.40.179.195 as permitted sender) receiver=protection.outlook.com; client-ip=104.40.179.195; helo=smtpworker-in-7.xware-eu-1.o365.crossware.co.nz; Received: from smtpworker-in-7.xware-eu-1.o365.crossware.co.nz (104.40.179.195) by HE1EUR01FT053.mail.protection.outlook.com (10.152.1.73) with Microsoft SMTP Server (version=TLS1_0, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA_P256) id 15.20.527.15 via Frontend Transport; Wed, 14 Mar 2018 14:36:52 +0000 Received: from EUR01-DB5-obe.outbound.protection.outlook.com (213.199.154.178) by smtpworker-in-7.xware-eu-1.o365.crossware.co.nz with Crossware for Office365; Wed, 14 Mar 2018 14:36:50 +0000 Received: from DB6PR0701MB2167.eurprd07.prod.outlook.com (10.168.58.22) by DB6PR0701MB2790.eurprd07.prod.outlook.com (10.169.216.7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.588.7; Wed, 14 Mar 2018 14:36:49 +0000 Received: from DB6PR0701MB2167.eurprd07.prod.outlook.com ([fe80::96a:6735:67f7:98e1]) by DB6PR0701MB2167.eurprd07.prod.outlook.com ([fe80::96a:6735:67f7:98e1%11]) with mapi id 15.20.0588.013; Wed, 14 Mar 2018 14:36:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=shapeblue.onmicrosoft.com; s=selector1-shapeblue-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=gSbZNMsnDZ942h5OnR1+BF9YVE8z49NocmKkdqGwIKA=; b=I+o37m+E/AhgACRHV0zbVyI1EtrVMeF8h/mUWA295eDS1Y2injQJy9hqGVBLL+eEtdhwTNYPMsrcw2G/ggPe8Lc0E57Y8tjIbmjB7BTn2TdV3Ab6jY+Ft0vb9RAy5wVjmcYBd2aj+hJQKe6AErLQh9iI6P3rZZV0sfVdSS6eUgs= From: Nicolas Vazquez To: dev Subject: Re: [DISCUSS] CloudStack Connection Pools Thread-Topic: [DISCUSS] CloudStack Connection Pools Thread-Index: AQHTulqL/Qf6maYEikeYXwGwEV0HQ6PNcfSAgACc9gCAAbtulw== Date: Wed, 14 Mar 2018 14:36:49 +0000 Message-ID: References: , In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: Authentication-Results-Original: spf=none (sender IP is ) smtp.mailfrom=Nicolas.Vazquez@shapeblue.com; x-originating-ip: [2800:a4:144d:bb00:f1f4:dec9:66de:4687] x-ms-publictraffictype: Email X-Microsoft-Exchange-Diagnostics-untrusted: 1;DB6PR0701MB2790;7:D50OcFVG9nN7a8gizkSQFLyfrJog7cr/1yE06VfJSM1LzKZBUyZ6H55DWC9RcE/FphwUw9J5aasYZzGm5N9PR4jqYnIVGksXmswKjGLs5BiWsf8bGqa24XSfXktMFqDCg4ofzjNFRK8EBnngRCQ8kxnIn95gewqaK3mObI+8OKtulLXuLXc0stWE/EBeK61lqV5XBu+zRJfxRTNrlH7CVpwOrT7sTMbRk7nPN4fzvLpfk+7TutZKhxMr7ll8vcjP x-ms-exchange-antispam-srfa-diagnostics: SOS; X-MS-Office365-Filtering-Correlation-Id: 96820133-aab0-45c7-8915-08d589b906fe X-Microsoft-Antispam-Untrusted: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(5600026)(4604075)(3008032)(4534165)(4627221)(201703031133081)(201702281549075)(2017052603328)(7153060)(7193020);SRVR:DB6PR0701MB2790; X-MS-TrafficTypeDiagnostic: DB6PR0701MB2790:|HE1PR07MB1643: X-Microsoft-Antispam-PRVS: x-exchange-antispam-report-test: UriScan:(166708455590820)(47647156867600)(85827821059158)(788757137089);UriScan:(166708455590820)(47647156867600)(85827821059158)(788757137089); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(5005006)(8121501046)(10201501046)(93006095)(93001095)(3002001)(3231221)(944501244)(52105095)(6041310)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123562045)(20161123560045)(20161123564045)(20161123558120)(6072148)(201708071742011);SRVR:DB6PR0701MB2790;BCL:0;PCL:0;RULEID:;SRVR:DB6PR0701MB2790;BCL:0;PCL:0;RULEID:(6040522)(2401047)(8121501046)(5005006)(3231221)(944501244)(52105095)(3002001)(93006095)(93003095)(10201501046)(6041310)(20161123558120)(20161123564045)(20161123560045)(20161123562045)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(6072148)(201708071742011);SRVR:HE1PR07MB1643;BCL:0;PCL:0;RULEID:;SRVR:HE1PR07MB1643; x-forefront-prvs: 0611A21987 X-Forefront-Antispam-Report-Untrusted: SFV:NSPM;SFS:(10019020)(39380400002)(376002)(346002)(366004)(39840400004)(396003)(53754006)(76104003)(189003)(199004)(72206003)(6606003)(6506007)(102836004)(1680700002)(606006)(8936002)(6436002)(6116002)(316002)(53936002)(186003)(74316002)(966005)(2950100002)(6246003)(236005)(53546011)(81166006)(9686003)(81156014)(478600001)(106356001)(54896002)(8676002)(2906002)(5660300001)(7736002)(6916009)(6306002)(53386004)(68736007)(229853002)(33656002)(55016002)(3280700002)(3660700001)(7696005)(14454004)(97736004)(76176011)(99286004)(18265965003)(25786009)(86362001)(105586002)(19627405001)(59450400001)(5250100002)(46003)(2900100001);DIR:OUT;SFP:1102;SCL:1;SRVR:DB6PR0701MB2790;H:DB6PR0701MB2167.eurprd07.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; received-spf: None (protection.outlook.com: shapeblue.com does not designate permitted sender hosts) X-Microsoft-Antispam-Message-Info-Original: A9P5pRm8S+MRL9z0zGxhdV2FhS//+1du6OmK7Zz2qtRlGiP1KolTzaGbUHqFef4fThI6yXpqBogkdaOGXecA+hfzY9ygWyUnDTTy5+hNxQOTRNIEo6P0fFI3qUsm6WDh+CEevHxYNgiiLTJHZos4KSgu5W7yr2EcTypV0OwSPYhE+aPn1Gc0knXlJkL7zeOT/N1+nKNVDNz3rpbUdltXixIQYyXJjrfrPBaftOZhoE1f7PcuUfwkmfrCpTSxeciXDS/WLhY1F1e5R5Kb2EBYUrZFXcIKw4HLegbprMORNdp1AKmQvtsYzCToHjymHSpxitlD4dOhPv8iV1Ur0SIfDg== SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-CWesigProcessed: Y X-MAIL_SIG_VERSION: 4.0.2.4454 X-MAIL_SIG_SERVER: smtpworker-in-7.xware-eu-1.o365.crossware.co.nz X-MAIL_SIG_CONFIGNAME: Plain Text for Mailing Lists etc X-MAIL_SIG_CONFIGNAMEPLIED: Plain Text for Mailing Lists etc Content-Type: multipart/alternative; boundary="_000_DB6PR0701MB216725DBDECB81044EBD7DEBE9D10DB6PR0701MB2167_" MIME-Version: 1.0 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB6PR0701MB2790 X-EOPAttributedMessage: 0 X-CrossPremisesHeadersPromoted: HE1EUR01FT053.eop-EUR01.prod.protection.outlook.com X-CrossPremisesHeadersFiltered: HE1EUR01FT053.eop-EUR01.prod.protection.outlook.com X-MS-Exchange-Transport-CrossTenantHeadersStripped: HE1EUR01FT053.eop-EUR01.prod.protection.outlook.com X-Forefront-Antispam-Report: CIP:104.40.179.195;IPV:NLI;CTRY:;EFV:NLI;SFV:NSPM;SFS:(10019020)(396003)(39380400002)(39840400004)(376002)(346002)(2980300002)(1109001)(1110001)(339900001)(53754006)(199004)(189003)(76104003)(16586007)(336012)(68736007)(8936002)(105606002)(19627405001)(6116002)(99286004)(76176011)(18265965003)(15974865002)(106466001)(7696005)(316002)(25786009)(5660300001)(33656002)(7736002)(74316002)(356003)(8676002)(81156014)(81166006)(5250100002)(2900100001)(966005)(606006)(14454004)(478600001)(1720100001)(53936002)(72206003)(229853002)(97736004)(61614004)(86362001)(6506007)(53386004)(102836004)(55236004)(53546011)(59450400001)(186003)(26005)(6346003)(9686003)(6916009)(236005)(2950100002)(2906002)(6306002)(54896002)(55016002)(84326002)(1680700002)(6246003);DIR:OUT;SFP:1102;SCL:1;SRVR:HE1PR07MB1643;H:smtpworker-in-7.xware-eu-1.o365.crossware.co.nz;FPR:;SPF:Fail;PTR:InfoDomainNonexistent;A:1;MX:1;LANG:en; X-Microsoft-Exchange-Diagnostics: 1;HE1EUR01FT053;1:qGqy4uD7SZ2FUWS8QXyK9fsusXPav3dJSKmMCpbcBxnQd+MF468usH6n+t9ByBkxE1BfjmIY8Gt/wpAoSwliEBvaJbmxEgnwQdqE25lzy2WE2NcXHfi81odsqnwCxGcE X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(5600026)(4604075)(3008032)(4534165)(7168020)(4627221)(201703031133081)(201702281549075)(2017052603328)(7153060)(7193020);SRVR:HE1PR07MB1643; X-Microsoft-Exchange-Diagnostics: 1;HE1PR07MB1643;3:5poGqZ9bYQlc0b8M+IJKfsIHzUEKn+flTg0cVhhtt/jPgC/sHRpb3Y/uYaBeDsR+X1E9MKKcN9t+Xxg4zkI7ow65TszahU55HvwbnzsuKyaoBFzDjN6QfYwR5G29HKdZ4idq8iaCUvVlASo9OU/skiy0ZcAqDJq42Yk+mqR/1NypFucN9GzsoAqzob31z2L/5jDxiyVjUWxGZXBe/jyY5CDK8dLlP3YRNbF95yI2XHPMeA3gTUw7gwxM/fRm4xqY4o2yknkTz/dEGOKsDmVfK/uzw+7QyVJwGgmwY9zDZQY/e83LxxSyJu/ZSGTciSI3flVYzrytBE4HU6DOIH83BsWbjBiIPwadbGpNcwcUZlQ=;25:eZ70xSo4BAt1ghjcmA91se4h6kEP3EcXWfcEdNyeRQHVWq/RU5GsWyVN6hmIGSGtvtatl72g5YH0r0oi1kiW/bxZPNtBc2TDcFqCURHuc6d3WkkZiwnkzE8/LD73eaSTu3aPEs3LwDKIdDAVV4gFLXarl9ALdjAKxXfrLKM7HmMYNhQQXoPs1Bsw71kIVR7O+wFg+LYRo4UpTRpIrBVz8W4fjGdWRUOx6/SxNus4M7Lc/DYQP5ky+0GXW4kORNJCpPxNbRP1gW2qj16pg/OAB7iXma1v7Lk4bvtWknRwoDZaNG92KniQgF3e7TlP8/UH6xkUmSmVWqCboAHAD12xSg== X-Microsoft-Exchange-Diagnostics: 1;HE1PR07MB1643;31:oUNAeKKRGPy4bd9X8Hl9ZqxHbNoafMM/QqTtBaKpFZOBrLUlo/u6oxsAOsgvNvCRhK8FFcP3DV21xsv8eFiVP+Wnt8ipzui3SKlYBzEA0jGGXfyK/quWlW5kAXmCL4kplEQN5M01qFJfYV/MmAIhCnBiTGVZFBfTcFnva35FP80+vJ7ycFFOP8dx6xeE1WsFf8usQcUdPXhlK25Pxye+kAaFaBAtHJhJve2vUDFXjvU=;20:Dg2K1nx4cquXma8sDW6gA8AZmZlcW7tGdSQEuv4NlpM/R3ZT47auRvmjlBQCIaPCkROr87gUAb1TmRzRD7ppbzNa/+0ixClUG67svTdrulh7nPf+/wnXb9Vz1fC61qbBIR2O5Pkm6N03J5lLQ8v8TdqzbRL/TR3IQVFBjiqWkjMG4t5kcMcqhMgw5SBToAy2te6494/5A0Ukh7dcXXwJ0dZo9SITBCxnWfAgF3/Qi5hSX9zVKhpNZPSvlhePlHsE;4:Py3276j4jQD2JeDGnXRJSezVImAlpkjXwqPyMTcQjVcUcKL/zglzHflO5fL78qvNivgekswmwD0TJ6j4mbkyWzLRTOvZsqBYD+k0ialz/fc4wE76MuKi5s9S+jWxHDajuZyr76mQRx8JdkluGiQxfsXKwUH7Bw1iTVwSgN29Lkcm+yPUeLiHKsVQ983LG/aLo/6vnfO40uAsxTlzwN4gU0vtCZpZcB+7Yh0/Kb6M1vQyt96dg4YKtHteHK12QXUITLB+FCzUPyNAcd9F9kFaHIpa2W8jUCtQgzU1KIf2qV/y4axsDHs0j79SrzpQLX32tr5UHjwA7EX5OGYUW5EJTIw/zoHoSnoJ7wA1SayYYveiPP54QxoyCaAoNKzNsDdDysr2v2QKYY/cQwopPoAOMXr6Lj6FEzQ3ys2qZgj3XIk= X-Forefront-PRVS: 0611A21987 X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1;HE1PR07MB1643;23:8eg8wsaq5NANdb5RJRzsdCMndWHwlTZvpEos6PjBR?= =?us-ascii?Q?qJM949UMzFYeDWD847duAod4ldY7SKtD4UEjZLZSTHijJ/myxQoZN22pCdI/?= =?us-ascii?Q?8xwkVqF+U/ge5E5ZkiGQhkZAiMiIro0V49zKL4E5qV9xbrb7vXzsuqz3BOMf?= =?us-ascii?Q?J1gVVBF6zbRohPqUhyyfQ2EYf0p0nhWKOXgWkXYnkFiMOJB5MNRDlvOw5X3V?= =?us-ascii?Q?D2/Z0qHNLHG5md4mvPf7JmnulMYPOh1oP1X0rwBEFyWIfx7yjqkjk/yAVX+T?= =?us-ascii?Q?yB9iDsHgxXr9XW6gbKWL2ULIEzTRNgQYHVrbHbFA4Wwxd1qg64afEBd4cGpY?= =?us-ascii?Q?6a9i2XihfALSK4HFmZtH+6mBZLVoSvO1/bCYCtUzENEtf4G+59ogNO54Hk2k?= =?us-ascii?Q?yWFgusBdcqZF7WjPfBabY1emg6t/qKrcCjS8jkdLKO4xYTIwbk0ON1JAMsyj?= =?us-ascii?Q?bsTet84wpEf/rezMWtFPLGVoxZbZS3qi+GiEzrocolL0kW7uM1Hn6svb36vj?= =?us-ascii?Q?lhhxP94YX3giPDxn4Cn9nd5hUS5gEX2riU8tgP+NK7yDdlVPKBhqu/cjT93T?= =?us-ascii?Q?eehn06skQjBCP2sdNutiI4oYxswUOsTvjkDdg5zr+athhx/W15yS9UxrpRSD?= =?us-ascii?Q?wJigQeoXLXJInuR5+KKuIo/+S0SdGpBFM6Rp64AU9L/zwXWsNpoS6cIRSDU0?= =?us-ascii?Q?ZXaBP8yZK1ddB/aZXQBe2909kI/liZYnlkpSBmMRuGNhjqNXmvnbA+PrtxV9?= =?us-ascii?Q?/CcFodFtrbLocGInEsmIyfuZNSe3C+E14hZN1ckIcZc7mC23ulkxFJ7IYtlL?= =?us-ascii?Q?goDimJrL+anGQRpmMKQJy7NDD4cF3wQCIZHDuXk5qxJwtwpWeEiO8GR5LnE4?= =?us-ascii?Q?u4mdbIp6NpFXO0MqWebWAFLvX8hUV7SlgKwwj1azZdtCUe7+cup8cK3EvfPc?= =?us-ascii?Q?iyYLw6Ai2NHcNyiX4OfrPRbhVRQoVZArovD+PHuM/qpsisee8V5rSZDz5ZeL?= =?us-ascii?Q?wZ5XgyI9orZzYiS7jDNG79gPDeciEuUEdK4wDqtKEW5WnbMY2/HiqAHEicjz?= =?us-ascii?Q?CnAp8dViCEC34U51INcOToiN+i3hwAu+02eSUGRRxwbi8ZXjU4KWqFCK93Bk?= =?us-ascii?Q?q06faIv5PmnAkUklJkULZQigNjFTieGX+jKUyw90H6rOi1BxCST/Gj5Cx2Es?= =?us-ascii?Q?uxLKxq0XcyXxOkcU5u9tT+oA7/BrBHuuWdWG+ZK+Hul3Nz6zkJgvoAO6xCxv?= =?us-ascii?Q?EchKfXTBuHh6CzVMQ5OrL34p24aPc+Yy6RGrZVECLbeoEGkaX/Opb/4OoZug?= =?us-ascii?Q?RuhC66Zhh01a0zA8tB28OKpNGqpHRQmpwbu0AjytX+IlcbTAb8Psqo7r016q?= =?us-ascii?Q?DNO+a09lZVoIL+1U2pvEOwTcC7ES2ObKti1xICY1HlHxOtOfe4SWEBUivbaP?= =?us-ascii?Q?PslJH//VqE+7b8eSTwkS2z0RQCk4OUqCpzyXzo5zMhXIetw4DvNbcjSt3Zwr?= =?us-ascii?Q?rTyKbXKIAkWNhHYiTYqyJHptrE+ZGRMzDPrct1yxvqelMLrDIcGV+eO2cj+B?= =?us-ascii?Q?tE5eujSrdit76FvGNfUjyp+d/2djoFvdcXeMU4=3D?= X-Microsoft-Antispam-Message-Info: XN7YSA42JCFJW0iYlP8bLHArUEYn0pviupv4k/RQN1K8xzmgl7cEC/XXpGktI9P9NE2DLXTMLSIyE5+n1ZPWmdgGUnSZyjYWyuJf++Pfaem1hF4mTbseEPl5boFIGqqRv/4Rryz5MOyQKieJzNhcXK8zThTrYZnJDkqbGSFMsggwn1IjOo0rHA2zULA1nF/3yCa9JKnJ2a0euk/4w21nNWFGrwa9dWxdVjmMD1sl+GT5E9OEEytamYKMnfGelU/PfzI3Mq56fWBy3CYnya/T77O1u1f6pNUi0+RSc7HP4LA02/DeiTsL+7HArzHMQfmjnba7CeoghvJGmvKBXL9yXw== X-Microsoft-Exchange-Diagnostics: 1;HE1PR07MB1643;6:uTZ5xvr/3Xy0bkpepMycw7U+e6SxomhRI/9I7JlJgxg5hYSo/3KyxWp+CnvfFCwEmlENNq0Tb5Ny7+jBQ7unQXF9oVjEx/ZmWwkL64cToBVcuoMN88k5j4dsudAzBXlpI4Z/su2n5w6A2B+EAyIeLm0F1/YdT6rk8yeU2ry8CdJStqfKfDE2O7v9+rCcueVs7dYg1DU+WOTPzlAy2Pdr6TQf95UTeFDD6Q6kahr7Cy2QjDeDic3E/g1VjVTluaFxiVhdtgTbP1iYcdkV6HY4Zhfmk/cy1FRG+lUTT+A5YaqjbNV9hi0alJ85O5XzBWYRFIM36XMg4GuG+M9AnnYdY8DqzKYa5g/jXlf249GFmWujTSVtjDL2o6FBSkFpeCo8OrZoXNOmSvlNxWLn3yNs5Q==;5:7ejhh4NwsV19Hcbcw2hWnvJDVTEILaHNuzE0a+7v+HOsRT1I+4yFrhJ99WhBR0iUrxvKoYXCuncR16UP3G1K3/wOYBwjvX3ELOtlh7Pjpje9m5iTum90WMxAf4aRayhmWUgKEakn3HQ/DVFrY8Vu0tnwdkWaUVau0aHUuOgnQd4=;24:e6fmARxqwX3gbtsihzZpehWs4SmLhh5r5XfuAaQl0OcUK8AlOz/fAClipNn1lhCODRxtoAYJKWBpivl05PkLMD7ixaMVuTYdovlRR3QnERo= X-Microsoft-Exchange-Diagnostics: 1;HE1PR07MB1643;7:I2dDMMZ5byM75YZnHlmMT7HNPsn1PF6GAqsIWKubpNK1DrzyUqvPxBbuKARuPrzFo+Qmt7LNQZwFPhw5RWLlht/TdcaEVC5SAy7fHxwlCLNpDWKMrgdVtLMZGikIKuDc3os2+fk8gSxftzhVLZV5GEfvkMxcn7s+UMYzHjERpsdryfbpycP/HyclIAxnwD+6iRyQcAUkLyW+yRrFGR0iMu6e44N76EuVObCry3R6lXCysITgIRj+hNhblYsg78Tu X-OriginatorOrg: shapeblue.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 14 Mar 2018 14:36:52.0842 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: 96820133-aab0-45c7-8915-08d589b906fe X-MS-Exchange-CrossTenant-Id: fc8906f6-e50e-4dad-98a0-ec2e3abe14f5 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=fc8906f6-e50e-4dad-98a0-ec2e3abe14f5;Ip=[104.40.179.195];Helo=[smtpworker-in-7.xware-eu-1.o365.crossware.co.nz] X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1PR07MB1643 --_000_DB6PR0701MB216725DBDECB81044EBD7DEBE9D10DB6PR0701MB2167_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Khosrow and Rafael. You both agree on Spring Data as the best option= , I see it would require a big effort and commitment to migrate to it, ther= efore it can take some (long) time to achieve it. As a more viable option, would you agree on supporting different connection= pool management libraries and letting the administrator choose which one t= o use? (DBCP 1.4 as default) ________________________________ From: Rafael Weing=E4rtner Sent: Tuesday, March 13, 2018 8:52:50 AM To: dev Subject: Re: [DISCUSS] CloudStack Connection Pools Spring data would be awesome. It is very flexible and has a very good API. However, this would require commitment from our side to slowly migrate things to it. Regarding the connection pool management libraries; I would prefer either C3P0 or 2.* DBCP. The other two sound trendy, but I worry about this type of project in the long run. Both DBCP from Apache and C3P0 from Hibernate (RedHat) sound a more reasonable selection for me. They have been around for years, and have a solid community base already. On Mon, Mar 12, 2018 at 11:31 PM, Khosrow Moossavi wrote: > Hi Nicolas > > From my past experiences, I prefer 1) HikariCP 2) Tomcat Pool 3) C3P0 4) > DBCP in that order. Although I don't have > any benchmark of my own to provide, and the ones you mentioned are really > informative anyway. > > To me the broader subject is the _one_ who uses the pool, I mean if the > transactions are handled in a faster way and > released sooner and with shorter locks, generally speaking if it's more > efficient, I don't think from ACS point of view > there won't be much difference between the above mentioned options. > > On the same subject, it might be more interesting to use Spring Boot in > general and Spring Boot Data in particular > rather than only changing the CP functionality, and slowly refactor/retir= e > the DAO layer in favor of Spring Boot equivalent > implementation. > > > Khosrow Moossavi > > CloudOps > > > > On Mon, Mar 12, 2018 at 9:32 PM, Nicolas Vazquez < > Nicolas.Vazquez@shapeblue.com> wrote: > > > Hi all, > > > > > > I would like to introduce a topic for discussion, regarding DB connecti= on > > pools used in CloudStack, currently Apache Commons DBCP 1.4 ( > > http://commons.apache.org/) is used. I've been investigating this topic > > as we are having complains of random issues on MySQL connection pool on > > large environments. Please let me know if this topic has already been > > discussed before. > > > > > > First of all, DBCP 1.4 has been released on 2010 ( > > https://commons.apache.org/proper/commons-dbcp/changes-report.html), an= d > > no minor/patch version has been released since then. It seems to work i= n > > high performance with relatively low traffic and low load applications. > > However, it is single threaded, and in order to be thread-safe, the > entire > > pool needs to be locked. It is also reported that an CPU and concurrent > > threads increases, the performance gets affected. This is a serious iss= ue > > on highly concurrent systems, such as CloudStack. > > > > > > I've been investigating some options to replace it: > > - The first option can be upgrading to version 2.x. Issues on performan= ce > > and concurrency could be solved using this version. > > - Tomcat JDBC Connection Pool. Please check: https://tomcat.apache.org/ > > tomcat-7.0-doc/jdbc-pool.html. > > > > - Other replacement options found: BoneCP, C3P0, HikariCP > > > > > > Given these options, I've been looking for benchmarks to compare them > (*). > > Looks like HikariCP (http://brettwooldridge.github.io/HikariCP/) could > be > > the best replacement, improving performance and stability. Another good > > replacement option could be Tomcat. > > > > > > I've been also examining the codebase, data source initialization is do= ne > > on TransactionLegacy class under the cloud-framework-db project. > > Replacement work should be done on this class. Instead of pure > replacement, > > a global setting can be introduced to make the admins able to select > which > > connection pool to use. > > > > What do you think? Any possitive/negative feedback is welcome as well a= s > > new ideas. As mentioned before, I don't know if it has been discussed > > before, sorry in advance if it has. > > > > Kind regards, > > Nicolas > > > > (*) Links to benchmarks and comparissons: > > https://www.wix.engineering/single-post/how-many-threads- > > does-it-take-to-fill-a-pool > > https://www.wix.engineering/single-post/how-does-hikaricp- > > compare-to-other-connection-pools > > > compare-to-other-connection-pools>https://beansroasted. > > wordpress.com/2017/07/29/connection-pool-analysis/ > > https://beansroasted.wordpress.com/tag/connection-pool-comparison/ > > > > https://github.com/brettwooldridge/HikariCP/wiki/%22My-benchmark- > > doesn't-show-a-difference.%22 > > http://www.trustiv.co.uk/2014/06/battle-connection-pools > > > > Nicolas.Vazquez@shapeblue.com > > www.shapeblue.com > > , > > @shapeblue > > > > > > > > > -- Rafael Weing=E4rtner Nicolas.Vazquez@shapeblue.com=A0 www.shapeblue.com , =20 @shapeblue =20 =20 --_000_DB6PR0701MB216725DBDECB81044EBD7DEBE9D10DB6PR0701MB2167_--