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.

BinlogInsertdisk flush

0 likes · 3 min read

How Many Disk Flushes Occur for a Single MySQL INSERT?

MaGe Linux Operations

Aug 2, 2014 · Operations

How to Pinpoint High Disk I/O Sources on Linux MySQL Servers

This guide walks through a practical three‑step process—using iostat to view I/O stats, iotop to identify the consuming processes, and pt‑ioprofile to reveal the exact files causing high disk I/O—helping Linux administrators quickly locate and address performance bottlenecks, especially in MySQL environments.

I/O MonitoringLinuxiotop

0 likes · 5 min read

How to Pinpoint High Disk I/O Sources on Linux MySQL Servers