I just wanted to ask about your experience with the innodb_flush_method setting since I usually went with
innodb_flush_method = O_DIRECT
Recently, while working with new machines, same kernel but a different Raid Controller / HD Setup, I’ve noticed a heavy performance drop while using O_DIRECT. Trying O_DSYNC was the same. Using the default flush method (not using the innodb_flush_method setting) worked well instead…
Any suggestions or experiences about this setting on different setups (linux kernel versions, raid setups, etc.)?