Correct, but when something *does* go amiss, some swap may give you the time
you need to fix things before you really go down :-)
So, yeah, a gig or two should be fine. There's also no real need for an
actual swap partition, these days - just use a swap file. Performance is
only marginally less than a dedicated partition, and it's not like you
expect to use it a lot anyway.
On Wed, Apr 14, 2010 at 5:59 AM, Kyong Kim <kykimdba@stripped> wrote:
> Yeah. One of the telltale signs of something amiss is excessive swap
> You're not going to be happy with the performance when the swap space
> is actually in use heavily.
> On Tue, Apr 13, 2010 at 8:15 PM, Dan Nelson <dnelson@stripped>
> > 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. The 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
> > but I didn't think Linux supported that), no more than 2GB. With that
> > RAM, you don't ever want to be in the state where the OS decides to page
> > 8GB of memory (for example) to swap. We have a few Oracle servers with
> > between 32 and 48 GB of memory and they all live just fine without swap.
> > --
> > Dan Nelson
> > dnelson@stripped
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel