Using the correct IO scheduler can increase performance and reduce the possibility of database timeouts when the system is under extreme write load. For file systems running on an SSD, or in a virtualized environment, the noop scheduler is recommended. For all other systems, the deadline scheduler is recommended. To determine which scheduler is configured on your system, run this command:

$ cat /sys/block/<block-device>/queue/scheduler

For example:

$ cat /sys/block/sda/queue/scheduler

Changing the scheduler on a running system can be done with the following command:

$ echo 'deadline' > /sys/block/sda/queue/scheduler

The change will take effect after the system is restarted. The procedure for configuring a scheduler to use at startup depends on the version of Linux. See the Linux documentation for your specific version for the correct way to configure this setting.