Source: dzone.com
MySQL 101: Linux Tuning for MySQLCategory: Database
by When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL.
You can determine the current value with the following command: If this is not set to "1", you should consider making the change by using one of the following options: If the change helps, you will want to make it permanent by making the change in /etc/sysctl.conf: The default for many systems is either "noop" or "deadline".
You can check what driver and governor are in use with the following command: In the above, you can see that the driver is "acpi-cpufreq" and the governor is set to "ondemand". You can also check the governor setting by issuing the following: If "performance" is an option, you can make the change by issuing the command: Of course, you will want to decide if this has helped performance, so testing is essential.
You can determine the current value with the following command: If this is not set to "1", you should consider making the change by using one of the following options: If the change helps, you will want to make it permanent by making the change in /etc/sysctl.conf: The default for many systems is either "noop" or "deadline".
You can check what driver and governor are in use with the following command: In the above, you can see that the driver is "acpi-cpufreq" and the governor is set to "ondemand". You can also check the governor setting by issuing the following: If "performance" is an option, you can make the change by issuing the command: Of course, you will want to decide if this has helped performance, so testing is essential.
Related Articles
Community Partners
DevOps Careers