Tagged articles

LSN

5 articles · Page 1 of 1

Sep 7, 2026 · Databases

InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios

This article explains InnoDB's checkpoint mechanism, contrasting synchronous and fuzzy checkpoints, detailing the pre-MySQL 8.0 fuzzy checkpoint implementation using flush lists and page cleaners, and describing two principles for detecting abnormal shutdowns plus four post-restart crash scenarios with their recovery requirements.

CheckpointCrash RecoveryInnoDB

0 likes · 11 min read

InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios

ITPUB

Nov 11, 2024 · Databases

When Does MySQL Actually Update Index Blocks? A Deep Dive into InnoDB Update Mechanics

This article examines how MySQL InnoDB decides whether to modify index blocks during UPDATE statements, walks through the internal mysql_update workflow, shows debugging with GDB, explains three test scenarios, and validates the behavior by inspecting block LSNs with the innblock tool.

Database InternalsIndex UpdateInnoDB

0 likes · 18 min read

When Does MySQL Actually Update Index Blocks? A Deep Dive into InnoDB Update Mechanics

dbaplus Community

Sep 26, 2023 · Databases

When Does MySQL Actually Update Index Blocks? A Deep Dive into InnoDB Update Mechanics

This article examines how InnoDB processes UPDATE statements on a table with primary and secondary indexes, analyzes three scenarios to determine which index blocks are modified, explains the internal filtering steps, and validates the behavior by inspecting LSN changes of the affected blocks.

Database InternalsInnoDBLSN

0 likes · 14 min read

Aikesheng Open Source Community

Sep 17, 2021 · Databases

Understanding InnoDB "Pages flushed up to" and Its Relation to the Last Checkpoint

This article explains the meaning of the 'Pages flushed up to' value in MySQL's InnoDB engine, how it differs from the 'Last checkpoint' LSN, the underlying logic for its calculation, and provides test results demonstrating its behavior during writes and checkpoints.

CheckpointInnoDBLSN

0 likes · 6 min read

Understanding InnoDB "Pages flushed up to" and Its Relation to the Last Checkpoint

Aikesheng Open Source Community

May 9, 2019 · Databases

Understanding Incremental Backup and Recovery in MySQL with XtraBackup

This article explains the principles of full and incremental MySQL backups using XtraBackup, covering how redo logs, LSN timestamps, global read locks, and recovery steps ensure data consistency for both transactional and non‑transactional information.

DatabaseBackupIncrementalBackupLSN

0 likes · 9 min read

Understanding Incremental Backup and Recovery in MySQL with XtraBackup