Managing MySQL Binary and Relay Logs: Analysis, Recovery, and Cleanup
Understanding MySQL Binary Logs
The binary log (often called binlog) is a set of files that stores details about data modifications and potentially data-changing events. It captures operations like INSERT, UPDATE, and DELETE, along with timestamps and execution details. Queries that do not alter data, such as SELECT or SHOW, are omitted. These ...
Posted on Mon, 21 Sep 2026 16:36:05 +0000 by Mercenary
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