Aikesheng Open Source Community

Feb 28, 2020 · Databases

How Many Disk Flushes Occur for a Single MySQL INSERT?

An experiment using pt‑tools shows that a single MySQL INSERT triggers three fsync operations on the redo log and one fdatasync on the binlog, while highlighting that flush behavior can vary due to multiple internal mechanisms.