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.
INSERTbinlogdisk flush
0 likes · 3 min read