In order to support the high IO load of small transactions from a database, the underlying file system should be tuned. Symptoms for this are low CPU load with high iowait. In this case, there are a couple of tweaks possible on Linux systems:
noatime,nodiratime flags for disk mount command or in the /etc/fstab for the database disk volume mount.
Copyright © 2011 Neo Technology