BestHub
search
Sign in
Tag

LSN

1 views collected around this technical thread.

Aikesheng Open Source Community
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
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