From: Reindl Harald
Date: July 14 2012 6:19pm
Subject: Re: mysql - uppoer limit for doing simultaneous red/writes..
List-Archive: http://lists.mysql.com/mysql/227819
Message-Id: <5001B81B.3080909@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig2665ED44B40168084D79BF48"

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



Am 14.07.2012 19:16, schrieb bruce:
> Hi.
>=20
> Considering a system, where I have a centralized Mysql setup. I'm not
> sure exactly what this should be called, single box, cluster, etc...
>=20
> But I'm looking to have a system of a a bunch of boxes, whihc run apps
> that will access (read/write) to the different dbs/tbls on the mysql
> setup.
>=20
> I'm trying to get a feel for just what mysql can handle in this situati=
on.
>=20
> Can a mysql setup handle 50K-100K simultaneous connections
> (reads/writes) to the same db..

simply no

you need around 1-2 MB per connection memory besides
locking, IOPS and other scale troubles

you would nee at least 35-50 GB RAM for this

but however, 50k connections are not realistic
from where should they come? mysqld would be
not the only bottenleck


--------------enig2665ED44B40168084D79BF48
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.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEUEARECAAYFAlABuBsACgkQhmBjz394Ann5+ACglpO4iP0M5f8xGcH/1LSEYJBh
pbIAmM59jIzkljCHdaXHKi4c3jDsoAg=
=VNOE
-----END PGP SIGNATURE-----

--------------enig2665ED44B40168084D79BF48--