From: Reindl Harald
Date: December 1 2011 6:36pm
Subject: Re: Use of Swap Memroy
List-Archive: http://lists.mysql.com/mysql/226411
Message-Id: <4ED7C930.1040000@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigDB4A2BB6FAF53ADC25461AC0"

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



Am 01.12.2011 18:56, schrieb Stdranwl:
> Hi, will it help to use swap memory on MYSQL's VM. We are in planning t=
o
> use 10GB RAM and  10 GB as swap on a perticular server? thanx

SWAP is always bad and should only be a reserve

so normally you should have as much memory as needed for the application
(per-connections-buffersxmac_connetions, key_buffer_size, buffer_pool)
and 20-40% reserve, additional i wuld recommend 1-2 GB SWAP to help the
OS in stress-situations

but never, independent for which service, you should see SWAp as addition=
al
memory because if it is heavily used/needed the performance will suck


--------------enigDB4A2BB6FAF53ADC25461AC0
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 Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7XyTAACgkQhmBjz394AnljQwCeN/yWaQbPgcqrzWMgiol/c3Y+
m/UAnjRiPA9G7Khjxxpb6rOsk2NMIqa/
=s/S4
-----END PGP SIGNATURE-----

--------------enigDB4A2BB6FAF53ADC25461AC0--