ITPUB

Oct 13, 2016 · Databases

MySQL Nontransactional Statements Explained: Effects on binlog Cache Parameters

The article clarifies that nontransactional statements are SQL commands operating on non‑transactional tables such as MyISAM, explains how MySQL parameters max_binlog_stmt_cache_size and max_binlog_cache_size control memory for these statements, and demonstrates the difference with transactional InnoDB tables through concrete command‑line examples.