Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those Linux configuration tips into 1 blog post.
- ext4 (or xfs), mount with noatime
- Scheduler – use deadline or noop
# echo deadline >/sys/block/sda/queue/scheduler add "elevator=deadline" to grub.conf
(For more info see Linux Schedulers in TPCC like benchmark)
- Swappiness and NUMA:
# echo 0 > /proc/sys/vm/swappiness add "vm.swappiness = 0" to /etc/sysctl.conf
- Set numa interleave all