MySQL and the Linux swap problem →
Even though your box might have lot of physical memory left, Linux would prefer to swap out your process so it can allocate more space for the filesystem cache. Read Smugmug and Kevin Burton’s blog posts and the comments.