How Do InnoDB Flush Methods and fdatasync Influence MySQL Syscalls?

This article examines how changing the InnoDB parameters innodb_flush_method and innodb_use_fdatasync—especially using O_DIRECT—affects MySQL's interaction with Linux syscalls, demonstrates verification with strace and /proc, and shows performance implications of these low‑level I/O choices.

InnoDBLinuxinnodb_flush_method

0 likes · 10 min read

How Do InnoDB Flush Methods and fdatasync Influence MySQL Syscalls?