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