transaction logs

Java Architecture Diary

Aug 6, 2021 · Databases

How Relational Databases Ensure Durability: Inside Pages, Undo & Redo Logs

This article explains the internal mechanisms of relational databases, covering data pages, buffer pools, undo and redo logs, checkpointing, and how these components work together to provide atomicity, durability, and crash recovery while minimizing disk I/O.

Checkpointdata pagesdatabases

0 likes · 7 min read

How Relational Databases Ensure Durability: Inside Pages, Undo & Redo Logs

Java Captain

Apr 8, 2019 · Databases

Understanding MySQL Execution Process: Architecture, Query and Update Flow

This article explains MySQL's internal architecture and the step‑by‑step execution flow of SELECT and UPDATE statements, covering server layers, storage engines, parsers, optimizers, executors, and the role of binlog and redo log in ensuring data consistency.

InnoDBMySQLQuery Optimization

0 likes · 10 min read

Understanding MySQL Execution Process: Architecture, Query and Update Flow

Beike Product & Technology

Jun 1, 2018 · Databases

InnoDB Transaction and Index Principles

This article explains InnoDB's transaction and index principles, covering ACID properties, transaction logs, MVCC, locking mechanisms, and B+ tree index structures to help backend developers understand how InnoDB ensures data consistency and high concurrency.

ACIDB-TreeIndex Optimization

0 likes · 11 min read