BestHub
Sign in
Tagged articles
80 articles
Page 1 of 1
Java Architect Handbook
Java Architect Handbook
Apr 7, 2026 · Databases

Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success

This article provides a comprehensive interview guide on MySQL’s three core logs—redo log, undo log, and binlog—covering their architecture, roles in crash recovery, MVCC, replication, configuration commands, two‑phase commit workflow, and frequent follow‑up questions to help candidates ace database interview questions.

BinlogDatabase Interviewlog architecture
0 likes · 13 min read
Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success
Sohu Tech Products
Sohu Tech Products
Dec 3, 2025 · Databases

Why MySQL Uses MVCC: A Deep Dive into Concurrency, Isolation Levels, and Read Views

This article explains MySQL InnoDB’s MVCC mechanism, why it replaces traditional locking, details the four SQL isolation levels, illustrates dirty, non‑repeatable and phantom reads with examples, and breaks down the hidden fields, undo‑log chain, and read‑view algorithm that enable high‑concurrency, non‑blocking reads and writes.

Concurrency ControlInnoDBIsolation Levels
0 likes · 18 min read
Why MySQL Uses MVCC: A Deep Dive into Concurrency, Isolation Levels, and Read Views
Sanyou's Java Diary
Sanyou's Java Diary
Aug 14, 2025 · Databases

Deep Dive into MySQL InnoDB Tablespaces, Undo Logs, and Doublewrite Buffer

This article explores MySQL InnoDB's memory and on‑disk architecture, detailing tablespace types, table and row formats, primary key strategies, index structures, the doublewrite buffer, redo log, undo log, and temporary tablespaces, complete with diagrams and code examples for practical understanding.

Doublewrite BufferInnoDBTablespaces
0 likes · 25 min read
Deep Dive into MySQL InnoDB Tablespaces, Undo Logs, and Doublewrite Buffer
Java Tech Enthusiast
Java Tech Enthusiast
Jul 12, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

Learn how MySQL’s three essential logs—Redo Log for durability, Undo Log for transaction rollback, and Binlog for replication—work together, understand their configurations, performance trade‑offs, and practical monitoring and recovery techniques to ensure data integrity in production environments.

BinlogData Recoverymysql
0 likes · 9 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Su San Talks Tech
Su San Talks Tech
Jul 9, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

This article explains how MySQL’s three essential logs—redo, undo, and binlog—work together to guarantee data durability, enable crash recovery, support transaction rollback, and power master‑slave replication, while providing practical configuration tips, monitoring queries, and recovery procedures for production environments.

Binlogdatabase reliabilitymysql
0 likes · 10 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Sohu Tech Products
Sohu Tech Products
Jun 11, 2025 · Databases

Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes

This article explains MySQL InnoDB's dual memory and on‑disk architecture, detailing the various tablespace types (system, file‑per‑table, general, undo, temporary), their internal structures (segments, extents, pages), configuration tips, and how tables, row formats, primary keys, auto‑increment lock modes, and B+Tree indexes are organized and managed.

Database ArchitectureInnoDBTablespaces
0 likes · 18 min read
Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 18, 2025 · Databases

Parsing Delete Undo Log in MySQL 8.0.32 InnoDB

This article explains how to read and parse the Undo log generated by a DELETE operation in MySQL 8.0.32 InnoDB, covering preparation, log extraction, detailed field parsing, locating the primary index record, and the step‑by‑step rollback of secondary and primary index records.

Database InternalsInnoDBSQL
0 likes · 10 min read
Parsing Delete Undo Log in MySQL 8.0.32 InnoDB
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 12, 2025 · Databases

Understanding the Delete Undo Log Format in MySQL 8.0 InnoDB

This article explains how MySQL 8.0 InnoDB generates and stores Delete Undo logs, detailing the log structure, field meanings, type_flag and info_bits decoding, address composition via DB_ROLL_PTR, and provides concrete SQL examples and shell calculations to illustrate the process.

Database InternalsDelete OperationInnoDB
0 likes · 11 min read
Understanding the Delete Undo Log Format in MySQL 8.0 InnoDB
Architect
Architect
Jan 14, 2025 · Databases

How MySQL Guarantees ACID: Deep Dive into Undo, Redo, and Binlog

This article provides a comprehensive analysis of MySQL’s internal architecture, detailing the four-layer design, the server service layer’s parsing, optimization and execution components, and the critical roles of Undo Log, Redo Log, and Binlog in ensuring ACID transaction properties.

ACIDBinlogDatabase Architecture
0 likes · 29 min read
How MySQL Guarantees ACID: Deep Dive into Undo, Redo, and Binlog
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 8, 2025 · Databases

How InnoDB Performs Undo Log Rollback and Record Deletion

This article explains the complete InnoDB undo‑log rollback process on MySQL 8.0, covering preparation, reading and parsing undo logs, constructing primary‑key index records, and the detailed steps for deleting secondary and primary index entries during a transaction rollback.

Database InternalsInnoDBmysql
0 likes · 12 min read
How InnoDB Performs Undo Log Rollback and Record Deletion
Senior Tony
Senior Tony
Dec 30, 2024 · Databases

Unlocking MySQL InnoDB: Deep Dive into ACID, Redo/Undo Logs, and Double Write

This article explains MySQL InnoDB's ACID properties in depth, detailing how atomicity relies on Redo and Undo logs, how consistency ensures business logic integrity, how isolation uses locks and MVCC with snapshot and current reads, and how durability is achieved through Redo logs, the innodb_flush_log_at_trx_commit setting, and the Double Write mechanism.

ACIDInnoDBIsolation
0 likes · 11 min read
Unlocking MySQL InnoDB: Deep Dive into ACID, Redo/Undo Logs, and Double Write
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 13, 2024 · Databases

Understanding MySQL Architecture and Log Mechanisms for ACID Transactions

This article provides a comprehensive overview of MySQL's layered architecture, the functions and core components of the server layer, and detailed explanations of Undo Log, Redo Log, and Binlog mechanisms that together ensure the ACID properties of transactions, including practical execution flows for queries and updates.

ACIDBinlogDatabase Architecture
0 likes · 29 min read
Understanding MySQL Architecture and Log Mechanisms for ACID Transactions
Liangxu Linux
Liangxu Linux
Sep 12, 2024 · Databases

Master MySQL Redo Log & Binlog: 15 Essential Interview Questions Explained

Explore 15 classic MySQL log interview questions covering redo log, WAL, binlog, undo log, two‑phase commit, write‑ahead logging, crash‑safe mechanisms, log flushing settings, and recovery procedures, with detailed explanations, execution flow diagrams, and configuration parameters to help you ace database engineering interviews.

BinlogDatabase RecoveryWAL
0 likes · 16 min read
Master MySQL Redo Log & Binlog: 15 Essential Interview Questions Explained
Liangxu Linux
Liangxu Linux
Sep 2, 2024 · Databases

Master MySQL Logs: Redo, Binlog, Undo & Crash‑Safe Mechanisms Explained

This article compiles 15 classic MySQL log interview questions and provides detailed explanations of redo log, WAL, binlog, undo log, two‑phase commit, crash‑safe mechanisms, and related configuration parameters, helping readers understand database recovery and replication fundamentals.

BinlogCrash SafeDatabase Recovery
0 likes · 17 min read
Master MySQL Logs: Redo, Binlog, Undo & Crash‑Safe Mechanisms Explained
dbaplus Community
dbaplus Community
Jun 30, 2024 · Databases

How MySQL’s Write‑Ahead Log Safeguards Data During Power Failures

An in‑depth guide explains MySQL’s write‑ahead log mechanism, covering buffer pool, redo and undo logs, checkpoint types, and how the system recovers from power failures, with step‑by‑step examples and practical configuration tips for reliable data consistency.

CheckpointDatabase RecoveryWAL
0 likes · 12 min read
How MySQL’s Write‑Ahead Log Safeguards Data During Power Failures
ITPUB
ITPUB
May 6, 2024 · Databases

How MySQL’s Write‑Ahead Log Protects Data During Power Outages

This article explains MySQL InnoDB’s write‑ahead logging, detailing the roles of Buffer Pool, Redo and Undo logs, checkpoint mechanisms, and how they ensure data consistency and atomicity when a sudden power loss occurs.

CheckpointDatabase RecoveryInnoDB
0 likes · 12 min read
How MySQL’s Write‑Ahead Log Protects Data During Power Outages
Sanyou's Java Diary
Sanyou's Java Diary
Dec 21, 2023 · Databases

What Happens Inside MySQL When You Run an UPDATE? A Deep Dive

This article explains the complete execution process of a MySQL UPDATE statement, covering InnoDB page structures, tablespaces, buffer pool caching, redo/undo logs, binlog, and the two‑phase commit mechanism, helping readers understand how MySQL ensures data consistency and durability.

InnoDBUPDATEbuffer pool
0 likes · 21 min read
What Happens Inside MySQL When You Run an UPDATE? A Deep Dive
MaGe Linux Operations
MaGe Linux Operations
Jul 23, 2023 · Databases

MySQL Redo, Bin, and Undo Logs Explained: Roles, Differences & Tips

This article introduces MySQL’s three primary logs—redo log, binlog, and undo log—explaining their purposes, how they ensure durability and recovery, the mechanisms for flushing them to disk, and the key differences among them, along with practical configuration recommendations.

BinlogDatabase LoggingInnoDB
0 likes · 6 min read
MySQL Redo, Bin, and Undo Logs Explained: Roles, Differences & Tips
Sanyou's Java Diary
Sanyou's Java Diary
Jul 3, 2023 · Databases

Master MySQL Internals: Architecture, Logs, and Recovery Explained

This article walks through MySQL's three‑layer logical architecture, explains the roles of redo, undo, bin, and relay logs, shows how they ensure crash‑safety and point‑in‑time recovery, and provides practical commands for inspecting and configuring these logs.

BinlogDatabase LogsInnoDB
0 likes · 18 min read
Master MySQL Internals: Architecture, Logs, and Recovery Explained
政采云技术
政采云技术
Mar 28, 2023 · Databases

Understanding MVCC and Lock Mechanisms in MySQL

This article explains why MySQL uses MVCC, how undo‑log version chains and read views implement multi‑version concurrency control, and details the various lock types—including global, table, metadata, intention, row, gap, and next‑key locks—under different isolation levels with practical code examples.

InnoDBIsolation LevelsLocks
0 likes · 11 min read
Understanding MVCC and Lock Mechanisms in MySQL
Tencent Database Technology
Tencent Database Technology
Feb 28, 2023 · Databases

Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)

This article explains how InnoDB uses undo segment states for crash‑safe recovery, details the XA transaction protocol, describes bugs in earlier MySQL versions, and shows how MySQL 8.0.30 introduces a new undo state and revised prepare order to make external XA transactions crash‑safe, including code examples and recovery steps.

InnoDBXA Transactioncrash recovery
0 likes · 11 min read
Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)
ITPUB
ITPUB
Nov 15, 2022 · Databases

How MySQL Executes an UPDATE: Inside InnoDB Pages, Buffer Pool, and Logs

This article walks through the complete lifecycle of a MySQL UPDATE statement, covering InnoDB page structure, tablespaces, the buffer pool, redo and undo logs, binlog, and the two‑phase commit process, illustrating each step with examples and command outputs.

BinlogInnoDBUPDATE
0 likes · 19 min read
How MySQL Executes an UPDATE: Inside InnoDB Pages, Buffer Pool, and Logs
IT Services Circle
IT Services Circle
Oct 27, 2022 · Databases

Understanding MVCC (Multiversion Concurrency Control) in MySQL InnoDB

MVCC (Multiversion Concurrency Control) in MySQL InnoDB uses undo logs and read views to provide non‑locking snapshot reads, managing read‑write, write‑write, and read‑read concurrency, with implicit row fields and transaction IDs determining visibility across isolation levels.

InnoDBMVCCRead View
0 likes · 9 min read
Understanding MVCC (Multiversion Concurrency Control) in MySQL InnoDB
Wukong Talks Architecture
Wukong Talks Architecture
Jul 21, 2022 · Databases

Understanding MySQL MVCC Mechanism

This article explains MySQL's multi-version concurrency control (MVCC), describing how version chains, undo logs, and ReadView work together to implement isolation levels, prevent dirty reads, non‑repeatable reads, and phantom reads, and how RC and RR isolation differ in practice.

Database ConcurrencyIsolation LevelsMVCC
0 likes · 8 min read
Understanding MySQL MVCC Mechanism
Ops Development Stories
Ops Development Stories
Jun 21, 2022 · Databases

Inside MySQL UPDATE: How Undo, Redo, and Binlog Work

This article explains in detail what happens inside MySQL when an UPDATE statement is executed, covering the execution flow, the roles of undo log, redo log, and binlog, buffer pool mechanics, two‑phase commit, group commit, and practical optimization tips.

Binlogbuffer poolmysql
0 likes · 40 min read
Inside MySQL UPDATE: How Undo, Redo, and Binlog Work
Architect's Journey
Architect's Journey
Mar 30, 2022 · Databases

How Does MySQL InnoDB Ensure ACID Guarantees?

This article breaks down how MySQL's InnoDB engine guarantees the four ACID properties—atomicity, consistency, isolation, and durability—by leveraging undo and redo logs, the binary log, hidden transaction metadata, and MVCC with ReadView, illustrating each mechanism with concrete examples.

ACIDInnoDBMVCC
0 likes · 9 min read
How Does MySQL InnoDB Ensure ACID Guarantees?
Sanyou's Java Diary
Sanyou's Java Diary
Mar 5, 2022 · Databases

Unlock MySQL’s Secrets: Redo Log, Undo Log, Binlog & Transaction Mechanics

This article delves into MySQL’s internal logging mechanisms—redo log, undo log, and binlog—explaining their structures, purposes, and interactions, and then explores transaction concepts such as dirty reads/writes, non‑repeatable reads, phantom reads, isolation levels, and the MVCC implementation that ensures data consistency.

BinlogIsolation LevelsMVCC
0 likes · 11 min read
Unlock MySQL’s Secrets: Redo Log, Undo Log, Binlog & Transaction Mechanics
政采云技术
政采云技术
Jan 20, 2022 · Databases

InnoDB MVCC: Concepts, Implementation, and Visibility Rules

This article explains InnoDB's Multi-Version Concurrency Control (MVCC) mechanism, detailing undo log, readview, hidden columns, visibility algorithms for RR and RC isolation levels, and includes source code snippets illustrating read view assignment and visibility checks.

Database InternalsInnoDBIsolation Levels
0 likes · 12 min read
InnoDB MVCC: Concepts, Implementation, and Visibility Rules
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 11, 2021 · Databases

Understanding MVCC and Transaction Isolation Levels in InnoDB

This article explains the fundamentals of MVCC, transaction isolation levels, and related concepts such as ACID properties, dirty reads, non‑repeatable reads, phantom reads, hidden columns, undo logs, version chains, read views, and demonstrates how InnoDB implements these mechanisms with practical SQL examples and diagrams.

InnoDBMVCCRead View
0 likes · 21 min read
Understanding MVCC and Transaction Isolation Levels in InnoDB
macrozheng
macrozheng
Sep 17, 2021 · Databases

Understanding MySQL Binlog, Redo Log, and Undo Log: How They Ensure Data Consistency

This article explains MySQL’s essential logging mechanisms—binary log, redo log, and undo log—detailing their structures, purposes, configuration parameters, and how they work together to support replication, crash recovery, and transaction durability while balancing performance and consistency.

BinlogDatabase Loggingmysql
0 likes · 10 min read
Understanding MySQL Binlog, Redo Log, and Undo Log: How They Ensure Data Consistency
macrozheng
macrozheng
Jan 29, 2021 · Databases

Understanding MySQL’s Logical Architecture and Its Crucial Logs

This article explains MySQL's three‑layer logical architecture, the roles of redo, undo, and binary logs, how they interact with the buffer pool and crash recovery, and provides practical commands for managing slow query, general, and error logs.

Database LogsStorage Enginebinary log
0 likes · 18 min read
Understanding MySQL’s Logical Architecture and Its Crucial Logs
ITPUB
ITPUB
Jan 27, 2021 · Databases

Understanding MySQL’s Three Write-Ahead Logs: Redo, Binlog, and Undo

This article explains the three essential log files involved in MySQL write operations—redo log, binary log, and undo log—detailing the two‑phase commit process, their roles, write timing, storage mechanisms, and how they enable data durability, recovery, and replication.

Database Loggingmysqlredo log
0 likes · 9 min read
Understanding MySQL’s Three Write-Ahead Logs: Redo, Binlog, and Undo
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 26, 2020 · Databases

Understanding MySQL Binlog, Undo Log, Redo Log, and Change Buffer

This article provides a comprehensive overview of MySQL’s logging mechanisms—including Binlog, Undo log, Redo log, and Change Buffer—explaining their concepts, roles in replication and crash‑recovery, recording formats, flush timing, two‑phase commit, checkpoint handling, and how they interact during data modifications.

BinlogChange BufferDatabase Internals
0 likes · 22 min read
Understanding MySQL Binlog, Undo Log, Redo Log, and Change Buffer
Programmer DD
Programmer DD
Oct 14, 2020 · Databases

Master MySQL Binlog, Redo Log, and Undo Log: Complete Guide

This article explains MySQL’s essential logging mechanisms—binlog, redo log, and undo log—covering their purposes, formats, configuration parameters, flushing strategies, and roles in replication, recovery, and transaction atomicity, while comparing their differences and illustrating concepts with diagrams.

BinlogDatabase LoggingInnoDB
0 likes · 11 min read
Master MySQL Binlog, Redo Log, and Undo Log: Complete Guide
IT Xianyu
IT Xianyu
Sep 15, 2020 · Databases

Understanding MySQL Log Files: Redo Log, Undo Log, and Binary Log

This article explains MySQL’s six log files, focusing on the redo log, undo log, and binary log, detailing their purposes, contents, generation and release timing, associated physical files, configuration parameters, and their roles in transaction durability and replication.

Replicationbinary loglog
0 likes · 11 min read
Understanding MySQL Log Files: Redo Log, Undo Log, and Binary Log
ITPUB
ITPUB
Sep 8, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency

This article explains the three core MySQL logs—binlog, redo log, and undo log—their structures, formats, configuration parameters, and how they work together to provide replication, crash recovery, and transactional atomicity while balancing performance and consistency.

BinlogDatabase ReplicationTransaction Log
0 likes · 11 min read
Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency
vivo Internet Technology
vivo Internet Technology
May 20, 2020 · Databases

Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process

MySQL achieves crash‑safe durability by employing a write‑ahead log architecture that records changes in redo, undo, and binary logs, coordinates them through two‑phase and group commit to maintain order, and uses a structured recovery process to replay or roll back transactions after any failure.

BinlogCrash SafetyGroup Commit
0 likes · 17 min read
Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 20, 2020 · Databases

Understanding and Managing Undo Tablespaces in MySQL 8.0

This article explains the concept of MySQL Undo Log, traces its evolution from version 5.5 to 8.0, and provides step‑by‑step instructions with examples for creating, viewing, configuring, deleting, and moving undo tablespaces, highlighting the new parameters and defaults introduced in MySQL 8.0.

InnoDBSQLmysql
0 likes · 9 min read
Understanding and Managing Undo Tablespaces in MySQL 8.0
Qunar Tech Salon
Qunar Tech Salon
Feb 14, 2020 · Databases

Understanding InnoDB Rollback and UNDO Log Architecture in MySQL

This article explains the internal structure of InnoDB rollback segments, UNDO log storage formats, and the recovery process in MySQL, detailing how transaction IDs, segment headers, page headers, and log records are organized and used to safely roll back or purge data.

Database InternalsInnoDBmysql
0 likes · 22 min read
Understanding InnoDB Rollback and UNDO Log Architecture in MySQL
Youzan Coder
Youzan Coder
May 15, 2019 · Databases

Why a Simple SELECT LIMIT 1 Can Be Terribly Slow in MySQL InnoDB

A detailed investigation reveals that a seemingly trivial SELECT * FROM sbtest1 LIMIT 1 becomes slow due to InnoDB's MVCC visibility checks, a growing History List length, and a large number of deleted rows that must be scanned before a visible row is found.

InnoDBMVCCmysql
0 likes · 12 min read
Why a Simple SELECT LIMIT 1 Can Be Terribly Slow in MySQL InnoDB
Java Backend Technology
Java Backend Technology
Jun 12, 2018 · Databases

Understanding MySQL Redo, Undo, and Binary Logs: A Practical Guide

This article explains the purpose, content, generation timing, storage files, and release mechanisms of MySQL's redo log, undo log, and binary log, highlighting their roles in transaction durability, MVCC, and replication, and clarifying key differences and interactions among them.

Database Loggingbinary logmysql
0 likes · 12 min read
Understanding MySQL Redo, Undo, and Binary Logs: A Practical Guide
Hujiang Technology
Hujiang Technology
May 8, 2018 · Databases

Understanding Consistent Reads and MVCC in MySQL InnoDB

This article explains how MySQL InnoDB implements consistent reads using multi‑version concurrency control (MVCC), detailing isolation levels, undo‑log mechanics, hidden columns, rollback segments, transaction commit behavior, and the impact on SELECT, INSERT, UPDATE, and DELETE operations.

Consistent ReadInnoDBMVCC
0 likes · 14 min read
Understanding Consistent Reads and MVCC in MySQL InnoDB
dbaplus Community
dbaplus Community
May 12, 2016 · Databases

Three Surprising Ways to Crash MySQL (And How to Prevent Them)

This article demonstrates three distinct techniques—flooding undo logs, exhausting memory with user variables, and triggering a known bug—to deliberately crash a MySQL instance, explains the underlying mechanisms, shows test results, and offers practical safeguards to keep production databases stable.

bug exploitationdatabase stabilitymysql
0 likes · 7 min read
Three Surprising Ways to Crash MySQL (And How to Prevent Them)