How to Safely Clean Up MySQL Binlog When Disk Space Is Critical

This guide walks through why MySQL binlog can fill disks, explains its structure and formats, and provides a step‑by‑step, risk‑aware process—including preparation, safe PURGE commands, automatic expiration settings, verification, and monitoring—to clean binlog without breaking replication or losing data.

Monitoringbackupbinlog

0 likes · 34 min read

How to Safely Clean Up MySQL Binlog When Disk Space Is Critical

Tencent Database Technology

Aug 15, 2019 · Databases

Understanding InnoDB MVCC, Undo Logs, ReadView, and Purge Mechanisms

This article explains InnoDB's Multi-Version Concurrency Control (MVCC) architecture, detailing row formats, undo log types, ReadView visibility rules, purge processes, and related concepts such as semi-consistent reads and index condition pushdown, with code examples and diagrams illustrating each mechanism.

ConsistencyInnoDBMVCC

0 likes · 20 min read

Understanding InnoDB MVCC, Undo Logs, ReadView, and Purge Mechanisms