When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL. Below are some of the most important of these settings to help you get started.
Swappiness
The first thing to look at is what swappiness is set to. This will determine the tendency of the kernel to swap out memory pages. In may cases, you will want to set this to “1” to keep the swapping to a minimum. A value of “0” will disable it entirely.
You can determine the current value with the following command:
cat /proc/sys/vm/swappiness
If this is not set to “1”, you should consider making the change by using one of the following options:
# Make sure you are root and set swappiness to 1 echo 1 > /proc/sys/vm/swappiness # Or, you can use sysctl to do the same sysctl vm.swappiness vm.swappiness = 1
If the change helps, you will want to …
[Read more]