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: = 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--
|
|
