MESSAGE
DATE | 2021-02-07 |
FROM | John Dunlap
|
SUBJECT | Re: [Hangout - NYLXS] Moving ExecCGI to mod_perl - performance and
|
From hangout-bounces-at-nylxs.com Tue Feb 9 17:08:06 2021 Return-Path: X-Original-To: archive-at-mrbrklyn.com Delivered-To: archive-at-mrbrklyn.com Received: from www2.mrbrklyn.com (www2.mrbrklyn.com [96.57.23.82]) by mrbrklyn.com (Postfix) with ESMTP id 9286E163FB3; Tue, 9 Feb 2021 17:08:05 -0500 (EST) X-Original-To: hangout-at-www2.mrbrklyn.com Delivered-To: hangout-at-www2.mrbrklyn.com Received: by mrbrklyn.com (Postfix, from userid 1000) id 108FC164046; Tue, 9 Feb 2021 17:05:48 -0500 (EST) Resent-From: Ruben Safir Resent-Date: Tue, 9 Feb 2021 17:05:47 -0500 Resent-Message-ID: <20210209220547.GU25519-at-www2.mrbrklyn.com> Resent-To: hangout-at-mrbrklyn.com X-Original-To: ruben-at-mrbrklyn.com Delivered-To: ruben-at-mrbrklyn.com Received: from mxout1-he-de.apache.org (mxout1-he-de.apache.org [95.216.194.37]) by mrbrklyn.com (Postfix) with ESMTP id 894C4163FF9 for ; Sun, 7 Feb 2021 15:33:47 -0500 (EST) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-he-de.apache.org (ASF Mail Server at mxout1-he-de.apache.org) with SMTP id C6AAA63B37 for ; Sun, 7 Feb 2021 20:33:45 +0000 (UTC) Received: (qmail 31184 invoked by uid 500); 7 Feb 2021 20:33:44 -0000 Mailing-List: contact modperl-help-at-perl.apache.org; run by ezmlm Precedence: bulk Delivered-To: mailing list modperl-at-perl.apache.org Received: (qmail 31173 invoked by uid 99); 7 Feb 2021 20:33:44 -0000 Received: from spamproc1-he-de.apache.org (HELO spamproc1-he-de.apache.org) (116.203.196.100) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 Feb 2021 20:33:44 +0000 Received: from localhost (localhost [127.0.0.1]) by spamproc1-he-de.apache.org (ASF Mail Server at spamproc1-he-de.apache.org) with ESMTP id 7227C1FF39A for ; Sun, 7 Feb 2021 20:33:43 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamproc1-he-de.apache.org X-Spam-Flag: NO X-Spam-Score: 0.201 X-Spam-Level: X-Spam-Status: No, score=0.201 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=0.2, RCVD_IN_MSPIKE_H2=-0.001, SPF_NONE=0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamproc1-he-de.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=lariat-co.20150623.gappssmtp.com Received: from mx1-ec2-va.apache.org ([116.203.227.195]) by localhost (spamproc1-he-de.apache.org [116.203.196.100]) (amavisd-new, port 10024) with ESMTP id qkHayoGfVfxR for ; Sun, 7 Feb 2021 20:33:42 +0000 (UTC) Received-SPF: None (mailfrom) identity=mailfrom; client-ip=209.85.167.54; helo=mail-lf1-f54.google.com; envelope-from=john-at-lariat.co; receiver= Received: from mail-lf1-f54.google.com (mail-lf1-f54.google.com [209.85.167.54]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id 078C6BCC6B for ; Sun, 7 Feb 2021 20:33:41 +0000 (UTC) Received: by mail-lf1-f54.google.com with SMTP id d3so19060165lfg.10 for ; Sun, 07 Feb 2021 12:33:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lariat-co.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=INkjUP0uf4wKp6KbJKnhWWvgWb/SXHRKQeJgS0IQWcI=; b=iBa/jpkVsKsUDrsu402LPJqfhNO0CEj40dYqyqAsTEGCo8LZKCLnt3BWcrpwvtB6Lb BUSXEvuroZe7r7EQpRO88xNpYZ9dG76G+GrGOIrLQBcgrROEyUkEy6h65JNVwWy/n6Kp r3t1emPZxg8msRKIxleAaRSLOQgRQKnaMYdB49cSI+IGJzglHHXA0IMECvoZNsi5Urae Wk03ZIBP7RZK/qmIfqFneSPEsGD4YzBmYOYtl9pLjMC7Zjj03b4KTO5YrUhzeVhgXphx gBAJLu1KTpVz8z7sQLXJ9KJsWv+LraQb5BZWZjh86BY0zCf0V9N2Rmcy2w7KmsKHDuwE zoPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=INkjUP0uf4wKp6KbJKnhWWvgWb/SXHRKQeJgS0IQWcI=; b=eorp8uS8U2NmwZTnVSZMpT5To3A9AxHLiRQmTomonY7uvJm/KSLCdQh9lv6dRozATd Ycyuu5x0+9Di3DbF9RatmTsjBgK49IRu5cahQIgYpGA2gaqp4HupJgrPZgtjq3iOUqFx JNsawxG/JGAIqJyQy+f06xCfxO0QaONhnfjk3b5iOqJXHFT5mJgqcDKUrP1d1jWC2BjK WZ+8mBFUjc2oixtq6tTJ+d247i1zpU76VWyWuRoEAWWLts3NVnIiWqvo7d7UXG0us9E8 t0QiHAe1Ru67/NfYqY0yrW1/ixWdF+OMFH5YLQk2GvUCjQXjfrXgPaQzkPJdafKw3yo0 x7EA== X-Gm-Message-State: AOAM530LR3qPBZBandrsjbPdrnn5lzXd+/sKOYMkw7whkwcTnJCpNp/m b4HOaziiwWWruEywOClY71hG4Y5URLWE52BHgX/20w== X-Google-Smtp-Source: ABdhPJwbCynAZSyjK3Pcy4W40Cq+VnrXlZh3j9iAykwqozHQqT5lyWgb+ps6hYMZ/SSl+x3uZZHbBZMWcB276iIVncA= X-Received: by 2002:a05:6512:68d:: with SMTP id t13mr8415726lfe.472.1612730018439; Sun, 07 Feb 2021 12:33:38 -0800 (PST) MIME-Version: 1.0 References: <5DT5OQ.TMVDQL2ALCKH-at-crc.id.au> <20210207200539.a916a6af80093eb8a56ab4dc-at-wanadoo.fr> In-Reply-To: From: John Dunlap Date: Sun, 7 Feb 2021 14:33:26 -0600 Message-ID: To: James Smith Cc: Vincent Veyron , Steven Haigh , "modperl-at-perl.apache.org" Content-Type: multipart/mixed; boundary="000000000000e03acf05bac4f7db" Subject: Re: [Hangout - NYLXS] Moving ExecCGI to mod_perl - performance and custom 'modules' [EXT] X-BeenThere: hangout-at-nylxs.com X-Mailman-Version: 2.1.30rc1 List-Id: NYLXS Tech Talk and Politics List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: hangout-bounces-at-nylxs.com Sender: "Hangout"
--000000000000e03acf05bac4f7db Content-Type: multipart/alternative; boundary="000000000000e03acb05bac4f7d9"
--000000000000e03acb05bac4f7d9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
We're in a similar situation with 20-40 databases per server. We use PGBouncer for connection pooling.
On Sun, Feb 7, 2021 at 2:23 PM James Smith wrote:
> DBI sharing doesn't really gain you much - and can actually lead you into > a whole world of pain. It isn't actually worth turning it on at all. > > We use dedicated DB caching in the cases where we benefit from it as and > when you need it (low level caching database)... > > Although milage may vary - our problem was DB servers with 30 or 40 > databases on them being connected from a number of approximately 50-100 > child apaches, meant we ended up blowing up the connections to the databa= se > server really quickly... > > > -----Original Message----- > From: Vincent Veyron > Sent: 07 February 2021 19:06 > To: Steven Haigh > Cc: James Smith ; modperl-at-perl.apache.org > Subject: Re: Moving ExecCGI to mod_perl - performance and custom 'modules= ' > [EXT] > > On Sun, 07 Feb 2021 23:58:17 +1100 > Steven Haigh wrote: > > > > I haven't gotten into the preload or DBI sharing yet - as that'll end > > up needing a bit of a rewrite of code to take advantage of. I'd be > > open to suggestions here from those who have done it in the past to > > save me going down some dead ends :D > > I use mod_perl handlers, so not sure how it mixes with PerlRegistry, but > you probably want to have a look at connect_cached > > > -- > > Bien =C3=A0 vous, Vincent Veyron > > > https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__compta.libremen.co= m&d=3DDwIFAw&c=3DD7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=3DoH2yp0ge1e= cj4oDX0XM7vQ&m=3DC0OcuGbNbfxaSa8ASgV3uFXzejn7MpjIUH1aP1RbiyU&s=3DGPr8VuKQ3r= ZCzCPwggyAHdCOojK6ZThmShKk0Jb3maI&e=3D > Logiciel libre de comptabilit=C3=A9 g=C3=A9n=C3=A9rale en partie double > > > > -- > The Wellcome Sanger Institute is operated by Genome Research > Limited, a charity registered in England with number 1021457 and a > company registered in England with number 2742969, whose registered > office is 215 Euston Road, London, NW1 2BE. >
--=20 John Dunlap *CTO | Lariat *
*Direct:* *john-at-lariat.co *
*Customer Service:* 877.268.6667 support-at-lariat.co
--000000000000e03acb05bac4f7d9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
We're in a similar situation with 20-40 databases per = server. We use PGBouncer for connection pooling.
"gmail_quote"> :0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"= >DBI sharing doesn't really gain you much - and can actually lead you i= nto a whole world of pain. It isn't actually worth turning it on at all= .
We use dedicated DB caching in the cases where we benefit from it as and wh= en you need it (low level caching database)...
Although milage may vary - our problem was DB servers with 30 or 40 databas= es on them being connected from a number of approximately 50-100 child apac= hes, meant we ended up blowing up the connections to the database server re= ally quickly...
-----Original Message-----
From: Vincent Veyron <blank">vv.lists-at-wanadoo.fr>
Sent: 07 February 2021 19:06
To: Steven Haigh <= netwiz-at-crc.id.au>
Cc: James Smith <j= s5-at-sanger.ac.uk>; =3D"_blank">modperl-at-perl.apache.org
Subject: Re: Moving ExecCGI to mod_perl - performance and custom 'modul= es' [EXT]
On Sun, 07 Feb 2021 23:58:17 +1100
Steven Haigh <netw= iz-at-crc.id.au> wrote:
>
> I haven't gotten into the preload or DBI sharing yet - as that'= ;ll end
> up needing a bit of a rewrite of code to take advantage of. I'd be=
> open to suggestions here from those who have done it in the past to r> > save me going down some dead ends :D
I use mod_perl handlers, so not sure how it mixes with PerlRegistry, but yo= u probably want to have a look at connect_cached
--
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Bien =C3= =A0 vous, Vincent Veyron
bremen.com&d=3DDwIFAw&c=3DD7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnq= Bo&r=3DoH2yp0ge1ecj4oDX0XM7vQ&m=3DC0OcuGbNbfxaSa8ASgV3uFXzejn7MpjIU= H1aP1RbiyU&s=3DGPr8VuKQ3rZCzCPwggyAHdCOojK6ZThmShKk0Jb3maI&e=3D" re= l=3D"noreferrer" target=3D"_blank">https://urldefense.proofpoint.com/v2/url= ?u=3Dhttps-3A__compta.libremen.com&d=3DDwIFAw&c=3DD7ByGjS34AllFgecY= w0iC6Zq7qlm8uclZFI0SqQnqBo&r=3DoH2yp0ge1ecj4oDX0XM7vQ&m=3DC0OcuGbNb= fxaSa8ASgV3uFXzejn7MpjIUH1aP1RbiyU&s=3DGPr8VuKQ3rZCzCPwggyAHdCOojK6ZThm= ShKk0Jb3maI&e=3D
Logiciel libre de comptabilit=C3=A9 g=C3=A9n=C3=A9rale en partie double
--
=C2=A0The Wellcome Sanger Institute is operated by Genome Research
=C2=A0Limited, a charity registered in England with number 1021457 and a r> =C2=A0company registered in England with number 2742969, whose registered <= br> =C2=A0office is 215 Euston Road, London, NW1 2BE.
--
mail_signature"> arial">ot;,sans-serif;font-size:large">John Dunlap
ont-size:small;font-family:arial">s",sans-serif">a,sans-serif;font-style:normal">CTO |=C2=A0y:tahoma,sans-serif;font-style:normal">Lariat>;font-style:normal">=C2=A0
l;font-family:arial">serif">font-style:normal">
family:arial">= yle:normal">Direct: t-size:small;font-family:arial">quot;,sans-serif">sans-serif;font-style:normal"> Customer Service: = ![](3D"ci=<BR) d:ii_hwm90qu91_146b4d583171a8e6" width=3D"100" height=3D"60"> = div> --000000000000e03acb05bac4f7d9-- --000000000000e03acf05bac4f7db Content-Type: image/png; name="100x60.png" Content-Disposition: attachment; filename="100x60.png" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: ii_hwm90qu91_146b4d583171a8e6
iVBORw0KGgoAAAANSUhEUgAAAGQAAAA8CAYAAACQPx/OAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAN1wAADdcBQiibeAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAffSURB VHic7Zx/cFTVFcc/5+6+TQJECVZpBUZERmcQpWKnSrV2tDOdgUl/hLC0ZBcqpdmo1VpApTNiFVtb i6MRY0WSYFAI2izp0jqd0hla+4cjVloGOoIULVOwPyydseVHDHlv953+QQPZ3bfJ5seG98f7zOzM 23PuPffsft+779y7LxFVJcA/mPOdQEA2gSA+IxDEZwSC+IxAEJ8RCOIzAkF8RiCIzwgE8RmBID4j EMRnBIL4jEAQnxF2WuM35hqtC+3dRDsy5yOhkcbeEJ8hIS7oa7Mc/TN3tv+nFON1dnZenRap7Gsz mczb0Wj0VDH9w6q6K8/aNbYK+O/IpHh+UaPPoXyur80OaU0EtpdiPBfZaFRuyLKFQnOAN4vpH0xZ PiMQxGcEgviMURUkmUxOSiaTFaM5pjE8oK7O7fuy3fAbo5lDLsnkL6YX8oVHI4FNmzaVj7tg/H2Y 0HdxM9OB7tEYF8Ba1v5Wrq1stAYvhGSakttSGTfEiq/W1BzKcvU01+U95RCxIlXc3jYiVda2bamo Ck8AlwGo8BI5ghgl7ar+AzFHEfeoZDKHotHoB3nBmuIX9JSzNqsv6lj17ffQuLDCHmetRJiH8gnQ tkj91kd7WupWgLkyq48r662Gzft6WuLVQPXAn0JVkGMietRVjhDmcNnS9sNeLZM/S/0B5frs7qTU cKz3rSjzgCmAoyrPiDrfj0ajx6GEV0gyuf2TGF2HcEtfuyhLctsqICJnjlTAhNPJztQz9unyNbHY 3BO97bpC9hgLqyGnb09326K1oXHWa8AV9J5ewrT/H3xJ0KyyV8XdAewT1U8hZMUrjKIKApAGuzWW zITclRVLX34/p1n+dyrUiPfDPZaIrkTCizs6U6vfeftPG0tyD0kmU3MwuguyxRgEYWBFpPz0gVQq ddFAjUOO+QlwxRDHGhpKNJQ2B50Ni2eNQLRLBJqvnnltY0kEiUZrdhnca1F+OcxQkzIuTw7Qpgzh i8McZ6iM0ZC7HkSGGed9RL+2oLbm3pJNWbW1te8C1du2bZ+roo3AVWc8+qyIdBUbRxVNJpMX9s6x HmRQfpDfkb0Dx9Y3jci6ItIIKUwGPg9kbYugzHGaFy2zErSeeeuuMmqq+okVUeF+YCbQraprRTM/ jkaj3TAKVdaCBV/5VXNz886qiy6+B3gYN/PYAq8b9tBJRxLtjwylY1nD1h3AjmLb97TFpkmancDl fe165gptBVhYW/vrgeIkt6UWYXgnhN4/v3b+kb6+USl7E4mEAzyVSqW2HD/ZdaLfxk3zyqicmL1W +agrzV0dRW3OlZKype2H7da676GyOcuhMqX30GlePDtjsjczy8PhvVlVq6YbovOjR73GGBVBeqmp qTk2UJueigl3imM3ZhmtyBsRuKlkiQ0CwbynZJdMKkw+d6zPGdWszcXT6fSt5fC73vfRqLcYMEqC 9DTHvwBaK8J1aPbZk4sRqvIqRNWSru7tjUtmipv5hitcLy4T+20slOebuJg1t4Z5+LX0cHPxFKRH 7QllI7H9vmaNcS499JQI9561DVCPeJbroiXb4nGa6xoQeVqhXJQB8yvIZVPDgKcgBndCsWEMHtsY 4uSsNIeIc+m7CaWPGD7D2Rj7tIqsh/yzfqgIbv62kFv892kQj/JQ8lfTg+aFZZWK/rCAtwvk994v jhToM+KoK414XxMZYE+B/Pb3H1X25ZtYSOPCoqbdsMBuhTk59mqnOf51K7HlxWKCeJFOd89CJK8e F9WnLSofJLHhI69+Pa3x74hqo5dvRGmaV0Z51Q25ZoGdVtipY2nHv726Oa3xGz1/ZT0XYI/HvDvd GWs9YcHdA6VlFN3t5VDRNqc1to6meL834UKokRkeZteCxwqJMZrYFeOvAkK59owrjxcSoxhU9Y+e duFbdkvs1e62RVO8/L2EIyfTnfY46yHgyhyfqPJtu1zvpiV2EPQ9KLBFloMroeVG8VqNG1vMZyOQ KiZOKVHX7RLJ0wNjuAX4zVDjRuq37rdbYj8Hvuzhrg6lTbXdEvsryH4lvaKs/pWs7fcwyzu6zYa6 210jr+P9g5UBZoDnGe9JSDOPKLrXe3rWrXZr7FVcDnj1FSHvKZhSUJb46WG7pe4E5Jbhutppid2s yOt4/AGmCpMHKsTsTChhhTI3CXysQJOpoFONhPO2fMIA4Yatu+zW+I9QfbCYD1MMkfqXDzgtdb9V uC3HVY4SHXJ5OWKoQt3zIA/kOMyZnPU2rxwLpn3yX2fFG3fHS8fslngCNInHtNgfZ6+IyDe3rAYW AR8OJkBhVNOZ8BKBAVfn54vI+PRDwJ4RCVY5MUurSP2WlBg+AxwcTJisKSpS3/5KWs1MVLYAfxtu jhV3vPh323FmUaJnoIZNtMOOnHJuFtEnAXekw1vL2t+KnHJmg64FDlFg3duXvJX6mMTmfwKLAU49 v+QSS9KzjZGPDyoR45zdqxl7V8cHQE1Xa93EsMo1RmUSooOasFxCHwKM7eG4Y7E0x93/E5auPi5G NmV3sM5dFcs7ui24j6b4o+kxXKOuTmOQ0wwAY7scT/vyju4IrAJW8cKyyrRz+joVuRxRsUL2X3Kb S/CPA/xF8FyWzwgE8RmBID4jEMRnBIL4jEAQnxEI4jMCQXxGIIjPCATxGYEgPiMQxGcEgviMQBCf EQjiMwJBfEYgiM8IBPEZ/wONLbmWkFlv2gAAAABJRU5ErkJggg== --000000000000e03acf05bac4f7db Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline
_______________________________________________ Hangout mailing list Hangout-at-nylxs.com http://lists.mrbrklyn.com/mailman/listinfo/hangout
--000000000000e03acf05bac4f7db--
--000000000000e03acf05bac4f7db Content-Type: multipart/alternative; boundary="000000000000e03acb05bac4f7d9"
--000000000000e03acb05bac4f7d9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
We're in a similar situation with 20-40 databases per server. We use PGBouncer for connection pooling.
On Sun, Feb 7, 2021 at 2:23 PM James Smith wrote:
> DBI sharing doesn't really gain you much - and can actually lead you into > a whole world of pain. It isn't actually worth turning it on at all. > > We use dedicated DB caching in the cases where we benefit from it as and > when you need it (low level caching database)... > > Although milage may vary - our problem was DB servers with 30 or 40 > databases on them being connected from a number of approximately 50-100 > child apaches, meant we ended up blowing up the connections to the databa= se > server really quickly... > > > -----Original Message----- > From: Vincent Veyron > Sent: 07 February 2021 19:06 > To: Steven Haigh > Cc: James Smith ; modperl-at-perl.apache.org > Subject: Re: Moving ExecCGI to mod_perl - performance and custom 'modules= ' > [EXT] > > On Sun, 07 Feb 2021 23:58:17 +1100 > Steven Haigh wrote: > > > > I haven't gotten into the preload or DBI sharing yet - as that'll end > > up needing a bit of a rewrite of code to take advantage of. I'd be > > open to suggestions here from those who have done it in the past to > > save me going down some dead ends :D > > I use mod_perl handlers, so not sure how it mixes with PerlRegistry, but > you probably want to have a look at connect_cached > > > -- > > Bien =C3=A0 vous, Vincent Veyron > > > https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__compta.libremen.co= m&d=3DDwIFAw&c=3DD7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=3DoH2yp0ge1e= cj4oDX0XM7vQ&m=3DC0OcuGbNbfxaSa8ASgV3uFXzejn7MpjIUH1aP1RbiyU&s=3DGPr8VuKQ3r= ZCzCPwggyAHdCOojK6ZThmShKk0Jb3maI&e=3D > Logiciel libre de comptabilit=C3=A9 g=C3=A9n=C3=A9rale en partie double > > > > -- > The Wellcome Sanger Institute is operated by Genome Research > Limited, a charity registered in England with number 1021457 and a > company registered in England with number 2742969, whose registered > office is 215 Euston Road, London, NW1 2BE. >
--=20 John Dunlap *CTO | Lariat *
*Direct:* *john-at-lariat.co *
*Customer Service:* 877.268.6667 support-at-lariat.co
--000000000000e03acb05bac4f7d9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
We're in a similar situation with 20-40 databases per = server. We use PGBouncer for connection pooling.
"gmail_quote"> :0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"= >DBI sharing doesn't really gain you much - and can actually lead you i= nto a whole world of pain. It isn't actually worth turning it on at all= .
We use dedicated DB caching in the cases where we benefit from it as and wh= en you need it (low level caching database)...
Although milage may vary - our problem was DB servers with 30 or 40 databas= es on them being connected from a number of approximately 50-100 child apac= hes, meant we ended up blowing up the connections to the database server re= ally quickly...
-----Original Message-----
From: Vincent Veyron <blank">vv.lists-at-wanadoo.fr>
Sent: 07 February 2021 19:06
To: Steven Haigh <= netwiz-at-crc.id.au>
Cc: James Smith <j= s5-at-sanger.ac.uk>; =3D"_blank">modperl-at-perl.apache.org
Subject: Re: Moving ExecCGI to mod_perl - performance and custom 'modul= es' [EXT]
On Sun, 07 Feb 2021 23:58:17 +1100
Steven Haigh <netw= iz-at-crc.id.au> wrote:
>
> I haven't gotten into the preload or DBI sharing yet - as that'= ;ll end
> up needing a bit of a rewrite of code to take advantage of. I'd be=
> open to suggestions here from those who have done it in the past to r> > save me going down some dead ends :D
I use mod_perl handlers, so not sure how it mixes with PerlRegistry, but yo= u probably want to have a look at connect_cached
--
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Bien =C3= =A0 vous, Vincent Veyron
bremen.com&d=3DDwIFAw&c=3DD7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnq= Bo&r=3DoH2yp0ge1ecj4oDX0XM7vQ&m=3DC0OcuGbNbfxaSa8ASgV3uFXzejn7MpjIU= H1aP1RbiyU&s=3DGPr8VuKQ3rZCzCPwggyAHdCOojK6ZThmShKk0Jb3maI&e=3D" re= l=3D"noreferrer" target=3D"_blank">https://urldefense.proofpoint.com/v2/url= ?u=3Dhttps-3A__compta.libremen.com&d=3DDwIFAw&c=3DD7ByGjS34AllFgecY= w0iC6Zq7qlm8uclZFI0SqQnqBo&r=3DoH2yp0ge1ecj4oDX0XM7vQ&m=3DC0OcuGbNb= fxaSa8ASgV3uFXzejn7MpjIUH1aP1RbiyU&s=3DGPr8VuKQ3rZCzCPwggyAHdCOojK6ZThm= ShKk0Jb3maI&e=3D
Logiciel libre de comptabilit=C3=A9 g=C3=A9n=C3=A9rale en partie double
--
=C2=A0The Wellcome Sanger Institute is operated by Genome Research
=C2=A0Limited, a charity registered in England with number 1021457 and a r> =C2=A0company registered in England with number 2742969, whose registered <= br> =C2=A0office is 215 Euston Road, London, NW1 2BE.
--
mail_signature"> arial">ot;,sans-serif;font-size:large">John Dunlap
ont-size:small;font-family:arial">s",sans-serif">a,sans-serif;font-style:normal">CTO |=C2=A0y:tahoma,sans-serif;font-style:normal">Lariat>;font-style:normal">=C2=A0
l;font-family:arial">serif">font-style:normal">
family:arial">= yle:normal">Direct: t-size:small;font-family:arial">quot;,sans-serif">sans-serif;font-style:normal"> Customer Service: = ![](3D"ci=<BR) d:ii_hwm90qu91_146b4d583171a8e6" width=3D"100" height=3D"60"> = div> --000000000000e03acb05bac4f7d9-- --000000000000e03acf05bac4f7db Content-Type: image/png; name="100x60.png" Content-Disposition: attachment; filename="100x60.png" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: ii_hwm90qu91_146b4d583171a8e6
iVBORw0KGgoAAAANSUhEUgAAAGQAAAA8CAYAAACQPx/OAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAN1wAADdcBQiibeAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAffSURB VHic7Zx/cFTVFcc/5+6+TQJECVZpBUZERmcQpWKnSrV2tDOdgUl/hLC0ZBcqpdmo1VpApTNiFVtb i6MRY0WSYFAI2izp0jqd0hla+4cjVloGOoIULVOwPyydseVHDHlv953+QQPZ3bfJ5seG98f7zOzM 23PuPffsft+779y7LxFVJcA/mPOdQEA2gSA+IxDEZwSC+IxAEJ8RCOIzAkF8RiCIzwgE8RmBID4j EMRnBIL4jEAQnxF2WuM35hqtC+3dRDsy5yOhkcbeEJ8hIS7oa7Mc/TN3tv+nFON1dnZenRap7Gsz mczb0Wj0VDH9w6q6K8/aNbYK+O/IpHh+UaPPoXyur80OaU0EtpdiPBfZaFRuyLKFQnOAN4vpH0xZ PiMQxGcEgviMURUkmUxOSiaTFaM5pjE8oK7O7fuy3fAbo5lDLsnkL6YX8oVHI4FNmzaVj7tg/H2Y 0HdxM9OB7tEYF8Ba1v5Wrq1stAYvhGSakttSGTfEiq/W1BzKcvU01+U95RCxIlXc3jYiVda2bamo Ck8AlwGo8BI5ghgl7ar+AzFHEfeoZDKHotHoB3nBmuIX9JSzNqsv6lj17ffQuLDCHmetRJiH8gnQ tkj91kd7WupWgLkyq48r662Gzft6WuLVQPXAn0JVkGMietRVjhDmcNnS9sNeLZM/S/0B5frs7qTU cKz3rSjzgCmAoyrPiDrfj0ajx6GEV0gyuf2TGF2HcEtfuyhLctsqICJnjlTAhNPJztQz9unyNbHY 3BO97bpC9hgLqyGnb09326K1oXHWa8AV9J5ewrT/H3xJ0KyyV8XdAewT1U8hZMUrjKIKApAGuzWW zITclRVLX34/p1n+dyrUiPfDPZaIrkTCizs6U6vfeftPG0tyD0kmU3MwuguyxRgEYWBFpPz0gVQq ddFAjUOO+QlwxRDHGhpKNJQ2B50Ni2eNQLRLBJqvnnltY0kEiUZrdhnca1F+OcxQkzIuTw7Qpgzh i8McZ6iM0ZC7HkSGGed9RL+2oLbm3pJNWbW1te8C1du2bZ+roo3AVWc8+qyIdBUbRxVNJpMX9s6x HmRQfpDfkb0Dx9Y3jci6ItIIKUwGPg9kbYugzHGaFy2zErSeeeuuMmqq+okVUeF+YCbQraprRTM/ jkaj3TAKVdaCBV/5VXNz886qiy6+B3gYN/PYAq8b9tBJRxLtjwylY1nD1h3AjmLb97TFpkmancDl fe165gptBVhYW/vrgeIkt6UWYXgnhN4/v3b+kb6+USl7E4mEAzyVSqW2HD/ZdaLfxk3zyqicmL1W +agrzV0dRW3OlZKype2H7da676GyOcuhMqX30GlePDtjsjczy8PhvVlVq6YbovOjR73GGBVBeqmp qTk2UJueigl3imM3ZhmtyBsRuKlkiQ0CwbynZJdMKkw+d6zPGdWszcXT6fSt5fC73vfRqLcYMEqC 9DTHvwBaK8J1aPbZk4sRqvIqRNWSru7tjUtmipv5hitcLy4T+20slOebuJg1t4Z5+LX0cHPxFKRH 7QllI7H9vmaNcS499JQI9561DVCPeJbroiXb4nGa6xoQeVqhXJQB8yvIZVPDgKcgBndCsWEMHtsY 4uSsNIeIc+m7CaWPGD7D2Rj7tIqsh/yzfqgIbv62kFv892kQj/JQ8lfTg+aFZZWK/rCAtwvk994v jhToM+KoK414XxMZYE+B/Pb3H1X25ZtYSOPCoqbdsMBuhTk59mqnOf51K7HlxWKCeJFOd89CJK8e F9WnLSofJLHhI69+Pa3x74hqo5dvRGmaV0Z51Q25ZoGdVtipY2nHv726Oa3xGz1/ZT0XYI/HvDvd GWs9YcHdA6VlFN3t5VDRNqc1to6meL834UKokRkeZteCxwqJMZrYFeOvAkK59owrjxcSoxhU9Y+e duFbdkvs1e62RVO8/L2EIyfTnfY46yHgyhyfqPJtu1zvpiV2EPQ9KLBFloMroeVG8VqNG1vMZyOQ KiZOKVHX7RLJ0wNjuAX4zVDjRuq37rdbYj8Hvuzhrg6lTbXdEvsryH4lvaKs/pWs7fcwyzu6zYa6 210jr+P9g5UBZoDnGe9JSDOPKLrXe3rWrXZr7FVcDnj1FSHvKZhSUJb46WG7pe4E5Jbhutppid2s yOt4/AGmCpMHKsTsTChhhTI3CXysQJOpoFONhPO2fMIA4Yatu+zW+I9QfbCYD1MMkfqXDzgtdb9V uC3HVY4SHXJ5OWKoQt3zIA/kOMyZnPU2rxwLpn3yX2fFG3fHS8fslngCNInHtNgfZ6+IyDe3rAYW AR8OJkBhVNOZ8BKBAVfn54vI+PRDwJ4RCVY5MUurSP2WlBg+AxwcTJisKSpS3/5KWs1MVLYAfxtu jhV3vPh323FmUaJnoIZNtMOOnHJuFtEnAXekw1vL2t+KnHJmg64FDlFg3duXvJX6mMTmfwKLAU49 v+QSS9KzjZGPDyoR45zdqxl7V8cHQE1Xa93EsMo1RmUSooOasFxCHwKM7eG4Y7E0x93/E5auPi5G NmV3sM5dFcs7ui24j6b4o+kxXKOuTmOQ0wwAY7scT/vyju4IrAJW8cKyyrRz+joVuRxRsUL2X3Kb S/CPA/xF8FyWzwgE8RmBID4jEMRnBIL4jEAQnxEI4jMCQXxGIIjPCATxGYEgPiMQxGcEgviMQBCf EQjiMwJBfEYgiM8IBPEZ/wONLbmWkFlv2gAAAABJRU5ErkJggg== --000000000000e03acf05bac4f7db Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline
_______________________________________________ Hangout mailing list Hangout-at-nylxs.com http://lists.mrbrklyn.com/mailman/listinfo/hangout
--000000000000e03acf05bac4f7db--
|
|