From: Martin Gainty
Date: April 14 2011 1:52am
Subject: RE: Practical connection limits MySQL 5.1/5.5
List-Archive: http://lists.mysql.com/mysql/224806
Message-Id: <BLU142-W372318A57C8948ADD9BEF3AEAD0@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_ecc5d321-c0f4-4842-9b7f-d29263c764ed_"

--_ecc5d321-c0f4-4842-9b7f-d29263c764ed_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


i agree with harald

if you're using Java you should consider pooling your database connections =
with DBCP
http://commons.apache.org/dbcp/

feel free to ping me for implementation details

takk=2C
Martin =20
______________________________________________=20
Note de d=E9ni et de confidentialit=E9
 Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAte=
s pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sa=
tisfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9=
e ou la copie de ceci est interdite. Ce message sert =E0 l'information seul=
ement et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant =
donn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
.




> Date: Wed=2C 13 Apr 2011 23:59:43 +0200
> From: h.reindl@stripped
> To: mysql@stripped
> Subject: Re: Practical connection limits MySQL 5.1/5.5
>=20
>=20
> Am 13.04.2011 23:50=2C schrieb Jeff Lee:
> > Hey All=2C
> >=20
> > Can anyone provide some guidance as to what the practical connection li=
mits
> > to MySQL 5.1/5.5 are under linux?
> >=20
> > We're running a ruby on rails application that establishes 50 to 100
> > connections to our database upon startup resulting in around 1=2C000
> > persistent db connections.=20
>=20
> depends on how much RAM the box has
> remind that every connection needs some MB for buffers
>=20
> > I've been told to expect anywhere from 5 - 10x
> > our current transaction volume and I'm trying to predict where we're go=
ing
> > to top out. =20
>=20
> i can not image why 1000 connections are needed in a real world applicati=
on
> throw away the a=FC=FClication if it does not support connection-pooling =
in 2011
>=20
> > The servers are pretty beefy so I don't have a problem
> > reserving memory for connections if that's what it takes but was more
> > concerned about other problems that might be caused by having so many
> > connections
>=20
> even if you have enough memory why will you throw it away for a
> unusual connection count instead use the RAm for innodb-buffer-pool=2C
> query-cache=2C key-buffers?
>=20
>=20
>=20
 		 	   		  =

--_ecc5d321-c0f4-4842-9b7f-d29263c764ed_--