June 19, 2013

Post: Heikki Tuuri Innodb answers - Part I

kernel can decide (incorrectly) to swap out MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock is apparently unstable on Linuxbuffer pool and which are not swappable. They also allow to reduce number of TLB cache… checkpointing rate? Postgres exposes … try to disable thread throttling …