BestHub
Sign in
Tagged articles
8 articles
Page 1 of 1
Sanyou's Java Diary
Sanyou's Java Diary
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
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
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
JavaEdge
JavaEdge
Jul 25, 2020 · Databases

Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer

This article explains the differences between normal and unique indexes in MySQL, examines how they affect query and update performance, details InnoDB's change‑buffer mechanism, and provides practical guidance on when to prefer ordinary indexes for better write efficiency.

Change BufferInnoDBUnique Index
0 likes · 13 min read
Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer