Using the correct I/O 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, use the recommended noop scheduler. For all other systems, use the deadline scheduler.
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.
To determine which scheduler is configured on your system, run the following
$ cat /sys/block/<block-device>/queue/scheduler
To change the scheduler on a running system, run the following command.
$ echo 'deadline' > /sys/block/sda/queue/scheduler
- To apply the change, restart the system.