From: Reindl Harald
Date: March 28 2012 5:38am
Subject: Re: mysqld got signal 6 (problem why bigger than I initially realised)
List-Archive: http://lists.mysql.com/mysql/227065
Message-Id: <4F72A3BB.7080703@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig3A58F617BD47C42FE2241A16"

--------------enig3A58F617BD47C42FE2241A16
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable



Am 27.03.2012 23:24, schrieb Rick James:
> MaxClients          1000
> could overwhelm  max_connections =3D 41 .  Strongly recommend you decre=
ase=20
> MaxClients to less than max_connections
> (not the other way around).

totally wrong!

not every http-connection implies a myql-connection
a website typically contains a lot of static files
like images, javascripts, stylesheets and you bring
down your httpd if MaxClients is set too low and
you are unable to serve waiting clients

additionally if KeepAlive is used there are open
httpd-connections with NO db-connection after
serving a dynamic page using one out of MaxClients
for a timewindow based on KeepAliveTimeout

MaxClients on httpd should never be lower than "max_connections"
"max_connections" is primary a question of RAM and typical load

mysqltuner.pl:
[--] Total buffers: 2.4G global + 3.2M per thread (200 max threads)
[OK] Maximum possible memory usage: 3.0G (37% of installed RAM)
_____________________

however - 1000 is much too high if we are speak
about a preforked server on most hardware - keep
in mind that a worker process with mod_php consumes
some MB of memory in a typical environment

but this is all not mysql related


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

iEYEARECAAYFAk9yo7sACgkQhmBjz394AnkvYwCePwp3QUbIztR9twFj3uEy3uce
N2cAnA5Age1ep/8Oc6xgMepR6oBwl61Y
=5kYN
-----END PGP SIGNATURE-----

--------------enig3A58F617BD47C42FE2241A16--