Handling Character Encoding Issues When Using mysqlbinlog with binlog_format=ROW
In MySQL, the binary log format (binlog_format) can be set to STATEMENT, ROW, or MIXED. The ROW format records every row change individually, which porvides higheer consistency and reliability. However, when using the mysqlbinlog utility to inspect a binary log written in ROW format, the output may appear garbled because the tool does not autom ...
Posted on Tue, 19 May 2026 16:03:12 +0000 by anonymousdude
Deep Dive into MySQL: MVCC, Logs, Replication, and Backup
Multi-Version Concurrency Control (MVCC)
1. What is MVCC?
MVCC stands for Multi-Version Concurrency Control. It allows concurrency control by managing multiple versions of data rows. This technology makes consistent reads possible under InnoDB transaction isolation levels. It allows reading rows that are being updated by another transaction, se ...
Posted on Fri, 08 May 2026 01:45:33 +0000 by TheDumbNerd