FLASH disk as swap

Eric Cope eric.cope at gmail.com
Fri Dec 4 09:46:02 MST 2009


Can you share which changes you made to improve those Apache barfers?
Eric

On Fri, Dec 4, 2009 at 9:34 AM, Matt Graham <danceswithcrows at usa.net> wrote:

> From: "Bob Elzer" <bob.elzer at gmail.com>
> > What about a large database, maybe a couple of terabytes, and maybe
> > lots of users. And then let's say we spread our 6G of swap over
> > several disks. Maybe a system with 32GB of memory, and quad
> > processors. Maybe we could run some tests, anybody have a system
> > like this?
>
> Lessee.  Not quite, but:  Master DB server over here is 4-CPU, 16G
> RAM, has ~90G of junk in InnoDB and MyISAM tables, has hardRAID-5,
> and swap usage is currently roughly constant at 20M.  We aren't
> Amazon or NewEgg, but we get a constant flow of insert/update/delete
> statements.  200-300 queries/second, mostly.  Similar stats on the
> read-only slaves, which have practically identical hardware specs.
>
> When things are working like they should be, swap usage is minimal.
> I've commented out the swap lines in fstab on a few machines, and
> seen no problems in those swapless machines.  Occasionally,
> I've seen the Apache boxes hit swap heavily, fall over, and barf,
> but that's been a lot less common since we changed a few things
> early this year.  YMMV, obviously.
>
> --
> Matt G / Dances With Crows
> The Crow202 Blog:  http://crow202.org/wordpress/
> There is no Darkness in Eternity/But only Light too dim for us to see
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>



-- 
Eric Cope
http://cope-et-al.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20091204/3a72d64c/attachment.htm 


More information about the PLUG-discuss mailing list