Using the correct I/O scheduler can increase performance and reduce the possibility of database timeouts when the system is under extreme write load.
Important:
- For file systems running on an SSD or in a virtualized environment, use the recommended noop scheduler.
- For additional considerations related to network attached storage, see Databases on storage area networks, network-attached storage, or running in virtualized environments.
- 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.