www.percona.com
9
Do Not Let MySQL Swap
• Allocating too much memory and having MySQL
o swapping is a lot worse than not using all memory
• Monitor swapping (si/so from vmstat closely)
• Start with safe buffer values and increase them
gradually if a lot of memory stays free
!"#$%$&'$()*+,-.'/'+01
!234.+55555555555-6-3275555555555+555.8/!55+55555935555+5.7.'6-55+55554!$55551
+2++%+++.8!:+++;266+++%$;;++4/4<6+++.9+++.3++++%9++++%3+++9&+++4.+$.+.7+9:+8/1
+=++>++++>+?@?0@>A+?0B?=C+0=B0@?++++>++++>+++++=+++++=+++?>+++??++>++>+=>>++>1
+>++>++++>+?@?0@>>+?0B?=C+0=B0DC++++>++++>+++++>+++++>+++@?+++@B++>++>+=>>++>1
+>++>1+++>+?@?0@>>+?0B?=C+0=B0DC++++>++++>+++++>+++++B+++@>+++@E++>++>+DD++=1
+>++>++++>+?@?0@>>+?0B?=C+0=B0DC++++>++++>+++++>+++++>+++@>+++@E++>++>+=>>++>1
+>++>++++>+?@?0@>>+?0B?=C+0=B0DC++++>++++>+++++>+++++>+++@>+++@E++>++>+=>>++>1
+>++>++++>+?@?0@>>+?0B?=C+0=B0DC++++>++++>+++++>+++++>+++@>+++@?++>++>+=>>++>1