Tagged articles

7 articles

Page 1 of 1

Jun 9, 2025 · Databases

Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance

This article explores the inner workings of InnoDB's architecture—including the Buffer Pool, Change Buffer, Adaptive Hash Index, and Log Buffer—detailing their designs, configuration parameters, performance impacts, and best‑practice recommendations for high‑throughput MySQL deployments.

Adaptive Hash IndexChange BufferDatabase Architecture

0 likes · 15 min read

Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance

ITPUB

Oct 31, 2023 · Databases

Demystifying MySQL InnoDB Buffers: Pool, Change, Log & Doublewrite

This article explains MySQL InnoDB’s key buffering mechanisms—buffer pool, change buffer, log buffer, and doublewrite buffer—detailing their roles, internal structures, eviction policies, and how they improve performance and data durability while handling page reads, writes, and crash recovery.

Change BufferDatabase PerformanceDoublewrite

0 likes · 14 min read

Demystifying MySQL InnoDB Buffers: Pool, Change, Log & Doublewrite

政采云技术

Mar 14, 2023 · Databases

InnoDB Buffer Pool, Page Management, Change Buffer, and Log Buffer Overview

This article explains InnoDB's in‑memory structures, detailing the Buffer Pool architecture, page classifications and their management via free, flush, and LRU lists, the role and workflow of the Change Buffer, and the purpose and configuration of the Log Buffer.

Change BufferInnoDBLog Buffer

0 likes · 11 min read

InnoDB Buffer Pool, Page Management, Change Buffer, and Log Buffer Overview

政采云技术

Mar 14, 2023 · Databases

InnoDB Memory Structures: Buffer Pool, Page Management, Change Buffer, Log Buffer, and Adaptive Hash Index

This article explains MySQL InnoDB's internal memory architecture, covering the buffer pool's composition and sizing, page classification and management via free, flush, and LRU lists, the change buffer for secondary index updates, log buffer behavior, and the role of the adaptive hash index.

Change BufferInnoDBLog Buffer

0 likes · 11 min read

InnoDB Memory Structures: Buffer Pool, Page Management, Change Buffer, Log Buffer, and Adaptive Hash Index

dbaplus Community

Aug 14, 2022 · Databases

How InnoDB Redo Logs Safeguard MySQL: Generation, Buffering, and Flushing Explained

This article explains how MySQL 8.0's InnoDB generates Redo logs, groups them into mini‑transactions, writes them concurrently to the log buffer, and uses log_writer and log_flusher threads together with LSN, slots, and recent_written structures to ensure durable, ordered persistence.

Database RecoveryInnoDBLog Buffer

0 likes · 19 min read

How InnoDB Redo Logs Safeguard MySQL: Generation, Buffering, and Flushing Explained

IT Services Circle

Jul 20, 2022 · Databases

Understanding MySQL InnoDB Redo Log Generation, Buffering, and Flushing Mechanisms

This article explains the lifecycle of MySQL InnoDB redo logs—from generation during DML/DDL operations, through writing into the log buffer, to being flushed into the redo log file and finally persisted on disk—detailing the roles of mtr, log_writer, and log_flusher threads.

Database InternalsInnoDBLog Buffer

0 likes · 20 min read

Understanding MySQL InnoDB Redo Log Generation, Buffering, and Flushing Mechanisms

Aikesheng Open Source Community

Mar 5, 2021 · Databases

Effect of innodb_log_buffer_size on Redo Log I/O in MySQL

This article experimentally demonstrates how increasing MySQL's innodb_log_buffer_size reduces redo‑log write I/O, showing fewer write operations but similar total data volume, and explains why performance gains may be subtle in typical virtual‑machine storage environments.

I/O performanceInnoDBLog Buffer

0 likes · 4 min read

Effect of innodb_log_buffer_size on Redo Log I/O in MySQL