From: Reindl Harald
Date: April 13 2011 9:59pm
Subject: Re: Practical connection limits MySQL 5.1/5.5
List-Archive: http://lists.mysql.com/mysql/224805
Message-Id: <4DA61CCF.40208@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig60856150B2F3C716C3B69227"

--------------enig60856150B2F3C716C3B69227
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable


Am 13.04.2011 23:50, schrieb Jeff Lee:
> Hey All,
>=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,000
> persistent db connections.=20

depends on how much RAM the box has
remind that every connection needs some MB for buffers

> 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

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

> 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

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,
query-cache, key-buffers?




--------------enig60856150B2F3C716C3B69227
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2mHM8ACgkQhmBjz394AnkxwACfbuBwHWhGu3EVRdGQ0XLg5+qb
T5cAoJENMKmvSYh9ee6ohy8Df31cgdbv
=yQJf
-----END PGP SIGNATURE-----

--------------enig60856150B2F3C716C3B69227--