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

--------------enigFE4547223B2ABAC5536A39EE
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Am 14.04.2011 11:50, schrieb Johan De Meersman:
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>>
>> 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?
>=20
> Maybe the application doesn't have support for connection pooling and c=
an't be easily replaced.

http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/mysql.html

> Maybe there's just that much clients instead of a central service

Maybe the OP could clarify what he really does

> Maybe there's not just a single application that uses that database.

http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/mysql.html

> As usual, Harald, you fail to realise that your experience does not enc=
ompass the whole of human civilisation.=20

as usual people have questions without any information what they really d=
o

> You seem to have a good technical background, but it might be useful to=
 learn to=20
> consider problems from the point of view of the people who have them, a=
t times.
> It tends to be a much appreciated skill in the real world.

this is your point of view, ok

my point of view is instead having headaches about how many connections a=
re
possible without problems to consider how many connections are really
needed and without "my.cnf" (buffer settings), any information about the
workload of the applications the whole question does not make sense


--------------enigFE4547223B2ABAC5536A39EE
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/

iEYEARECAAYFAk2mxW4ACgkQhmBjz394AnmxCwCgnWZ5ysWczAKcQ3ixDHVMbQp1
co4AoJe0t/s5Qiv9qUzbvewWvKff97D8
=u8RQ
-----END PGP SIGNATURE-----

--------------enigFE4547223B2ABAC5536A39EE--