ati » from archive
The MySQL “swap insanity” problem and the effects of the NUMA architecture -
in many cases, “real” useful memory is being swapped: primarily parts of InnoDB’s buffer pool. When it’s needed once again, a big performance hit is taken to swap it back in, causing random delays in random queries. ‎- ati