Dear community,
I have an issue with MySQL swapping. I tried a lot of things to make sure it doesn’t swap and read lot’s of articles, but I can’t seem to solve the problem. Could you please point me in the right direction?
Info about the server:
Processor: 2x Intel® Xeon® CPU E5-2650 (8 cores)
Memory: 64GB
Storage: 2x SSD 250GB
Software: Percona Server (GPL), Release rel33.0, Revision 611
MySQL conf: http://pastebin.com/BrffKQiU
Things I tried:
Added numa-interleave to my.cnf
[mysqld_safe]
numa-interleave
I tested if it works, the result:
cat /proc/19670/numa_maps | cut -d ' ' -f 2 | uniq
interleave:0-1
So that works…
I also set vm.swappiness at 2. I didn’t set it to 0 because the server isn’t a dedicated MySQL server, it’s a webserver, mailserver, etc also.
When I run MySQL for about 10 hours it uses about 2GB swap space. How can I make sure it doesn’t do that?