From: Kyong Kim Date: April 14 2010 3:59am Subject: Re: Recommended swap partition size List-Archive: http://lists.mysql.com/mysql/221229 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Yeah. One of the telltale signs of something amiss is excessive swap activi= ty. You're not going to be happy with the performance when the swap space is actually in use heavily. Kyong On Tue, Apr 13, 2010 at 8:15 PM, Dan Nelson wrote= : > In the last episode (Apr 13), Joe Hammerman said: >> My organization has a dedicated MySQL server. The system has 32Gb of >> memory, and is running CentOS 5.3. =A0The default engine will be InnoDB. >> Does anyone know how much space should be dedicated to swap? > > I say zero swap, or if for some reason you NEED swap (for crashdumps mayb= e, > but I didn't think Linux supported that), no more than 2GB. =A0With that = much > RAM, you don't ever want to be in the state where the OS decides to page = out > 8GB of memory (for example) to swap. =A0We have a few Oracle servers with > between 32 and 48 GB of memory and they all live just fine without swap. > > -- > =A0 =A0 =A0 =A0Dan Nelson > =A0 =A0 =A0 =A0dnelson@stripped > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dkykimdba@gmai= l.com > >