dbaplus Community

Jul 19, 2026 · Databases

When Does MySQL Skip Writing to the Binlog? A Deep Dive into ROW‑Mode Logic and Controls

The article explains how MySQL determines whether a statement should be recorded in the binary log under ROW format, detailing the check_table_binlog_row_based function, the cached_row_logging_check flag, OPTION_BIN_LOG, and various scenarios—such as temporary tables, replication filters, no‑replicate tables, session settings, and internal operations—where binlog entries are omitted.