BestHub
Sign in
Tagged articles
77 articles
Page 1 of 1
MaGe Linux Operations
MaGe Linux Operations
Nov 6, 2025 · Databases

Boost MySQL InnoDB Performance 300%: Complete Buffer Pool Tuning Guide for 32GB‑256GB

This comprehensive guide walks you through MySQL InnoDB buffer pool optimization—from assessing current settings and calculating optimal sizes for 32 GB to 256 GB servers, to configuring instances, enabling pre‑warming, tuning dirty‑page flushing, monitoring key metrics, and troubleshooting common issues—to achieve up to a 300 % throughput increase in production environments.

Database OptimizationInnoDBSQL
0 likes · 33 min read
Boost MySQL InnoDB Performance 300%: Complete Buffer Pool Tuning Guide for 32GB‑256GB
dbaplus Community
dbaplus Community
Jul 14, 2025 · Databases

Why Full Table Scans Won’t Exhaust MySQL Server Memory

Even when scanning a 200 GB InnoDB table on a server with only 100 GB of RAM, MySQL does not consume all memory because it streams results using a limited net_buffer, employs socket send buffers, and InnoDB’s optimized LRU algorithm manages the buffer pool to prevent memory blow‑up.

Full Table ScanInnoDBLRU
0 likes · 12 min read
Why Full Table Scans Won’t Exhaust MySQL Server Memory
Liangxu Linux
Liangxu Linux
Jan 16, 2025 · Databases

Inside MySQL: How Buffer Pools, Indexes, and Logs Power Modern Databases

This article explains MySQL’s internal architecture, covering how data pages, B+‑tree and hash indexes, the Buffer Pool, Adaptive Hash Index, Change Buffer, Undo/Redo logs, the InnoDB storage engine, and the server layer work together to provide fast, reliable CRUD operations and support replication.

Database ArchitectureInnoDBbuffer pool
0 likes · 14 min read
Inside MySQL: How Buffer Pools, Indexes, and Logs Power Modern Databases
Lobster Programming
Lobster Programming
Dec 16, 2024 · Databases

Why MySQL Never Runs Out of Memory During Massive Full Table Scans

Even when scanning tables with tens of millions of rows, MySQL avoids out‑of‑memory crashes by streaming data in small 16 KB net buffers, using socket buffers, and employing an improved LRU algorithm that isolates cold data in the buffer pool’s old generation.

Full Table ScanLRUbuffer pool
0 likes · 5 min read
Why MySQL Never Runs Out of Memory During Massive Full Table Scans
Top Architect
Top Architect
Oct 12, 2024 · Databases

Understanding MySQL Index Structures, Execution Plans, Transaction Isolation Levels, MVCC, and Buffer Pool Mechanisms

This article provides a comprehensive technical guide on MySQL internals, covering the underlying data structures of indexes (B‑tree, B+‑tree, hash), how execution plans are generated and interpreted, the four transaction isolation levels, MVCC implementation, and the InnoDB buffer‑pool architecture.

MVCCSQL Optimizationbuffer pool
0 likes · 22 min read
Understanding MySQL Index Structures, Execution Plans, Transaction Isolation Levels, MVCC, and Buffer Pool Mechanisms
Su San Talks Tech
Su San Talks Tech
Jul 29, 2024 · Databases

Why Is MySQL Query Slow? Hidden Factors and Proven Speed‑Up Tricks

This article explores why MySQL queries can become sluggish beyond just missing indexes, covering the full query execution flow, profiling tools, index pitfalls, connection limits, buffer pool sizing, and practical configuration tips to dramatically improve performance.

Connection PoolIndex OptimizationProfiling
0 likes · 15 min read
Why Is MySQL Query Slow? Hidden Factors and Proven Speed‑Up Tricks
Top Architect
Top Architect
Jul 10, 2024 · Databases

Understanding MySQL Index Structures, Execution Plans, Transactions, and MVCC

This article provides a comprehensive overview of MySQL internals, covering index data structures such as B‑tree and B+‑tree, the differences between MyISAM and InnoDB indexes, SQL execution plan analysis, transaction isolation levels, lock mechanisms, MVCC implementation, and the InnoDB buffer‑pool caching process.

MVCCbuffer poolexecution plan
0 likes · 19 min read
Understanding MySQL Index Structures, Execution Plans, Transactions, and MVCC
Sanyou's Java Diary
Sanyou's Java Diary
Dec 21, 2023 · Databases

What Happens Inside MySQL When You Run an UPDATE? A Deep Dive

This article explains the complete execution process of a MySQL UPDATE statement, covering InnoDB page structures, tablespaces, buffer pool caching, redo/undo logs, binlog, and the two‑phase commit mechanism, helping readers understand how MySQL ensures data consistency and durability.

InnoDBUPDATEbuffer pool
0 likes · 21 min read
What Happens Inside MySQL When You Run an UPDATE? A Deep Dive
ITPUB
ITPUB
Dec 10, 2023 · Databases

Do 20‑Million‑Row MySQL Tables Still Slow Down on SSDs? Experimental Results

The article investigates whether the long‑standing rule of avoiding MySQL tables larger than 20 million rows still holds on modern SSD‑backed instances by creating tables of varying sizes, measuring query latency under different InnoDB buffer pool configurations, and analyzing the impact of caching and index usage.

InnoDBLarge TablesSSD
0 likes · 11 min read
Do 20‑Million‑Row MySQL Tables Still Slow Down on SSDs? Experimental Results
Tencent Database Technology
Tencent Database Technology
Aug 10, 2023 · Databases

Optimizing Buffer Pool Memory Management in TDSQL-C Serverless

This article explains the architecture of TDSQL-C Serverless buffer pool, details how InnoDB buffer pool resize works, analyzes performance bottlenecks such as IO and mutex contention, and presents optimization techniques like chunk pre‑allocation, delayed release, and hash‑resize improvements that make serverless scaling more stable.

Memory ManagementServerlessTDSQL-C
0 likes · 11 min read
Optimizing Buffer Pool Memory Management in TDSQL-C Serverless
政采云技术
政采云技术
Jun 13, 2023 · Databases

MySQL Logical Architecture Design and Performance Optimization

This article explains MySQL's four‑layer logical architecture, describes high‑performance read strategies, details data pages, buffer pool and LRU algorithm, and provides comprehensive guidance on index structures, optimization techniques, and best practices for improving query performance.

Database ArchitectureLRU algorithmbuffer pool
0 likes · 14 min read
MySQL Logical Architecture Design and Performance Optimization
Tencent Database Technology
Tencent Database Technology
Jan 18, 2023 · Databases

In‑depth Analysis of MySQL InnoDB Buffer Pool Architecture and Performance Optimizations

This article provides a comprehensive technical walkthrough of MySQL‑8.0.22 InnoDB's buffer pool, detailing its physical and logical structures, page management algorithms, fast read/write optimizations, change buffer, adaptive hash index, and the complete page‑read call stack, complete with code excerpts and diagrams.

Database PerformanceInnoDBMemory Management
0 likes · 47 min read
In‑depth Analysis of MySQL InnoDB Buffer Pool Architecture and Performance Optimizations
ITPUB
ITPUB
Nov 15, 2022 · Databases

How MySQL Executes an UPDATE: Inside InnoDB Pages, Buffer Pool, and Logs

This article walks through the complete lifecycle of a MySQL UPDATE statement, covering InnoDB page structure, tablespaces, the buffer pool, redo and undo logs, binlog, and the two‑phase commit process, illustrating each step with examples and command outputs.

BinlogInnoDBUPDATE
0 likes · 19 min read
How MySQL Executes an UPDATE: Inside InnoDB Pages, Buffer Pool, and Logs
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 14, 2022 · Databases

Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation

This article investigates a historical MySQL bug where dropping large tables with a sizable buffer pool and Adaptive Hash Index (AHI) can cause severe latency, presents test configurations for 5.7.29 and 8.0.28, compares AHI‑on/off results, shows stack traces, and explains the lazy‑delete fix introduced in 8.0.23.

Adaptive Hash Indexbuffer poolbug
0 likes · 24 min read
Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation
Su San Talks Tech
Su San Talks Tech
Sep 28, 2022 · Databases

Why MySQL Queries Slow Down and How to Speed Them Up

This article explains the common reasons MySQL queries become sluggish—beyond missing indexes—including connection limits, buffer pool size, and query cache, and provides practical solutions such as profiling, adjusting connection pools, tuning InnoDB settings, and using force index.

Connection Poolbuffer poolindexing
0 likes · 16 min read
Why MySQL Queries Slow Down and How to Speed Them Up
JD Cloud Developers
JD Cloud Developers
Sep 27, 2022 · Databases

Unveiling MySQL’s Inner Workings: From SQL Query to InnoDB Storage Engine

This article demystifies MySQL’s processing pipeline by tracing a simple UPDATE statement through the application, service, and storage engine layers, detailing connection handling, SQL parsing, optimization, execution, buffer pool management, and the roles of undo and redo logs in ensuring data integrity.

Database ArchitectureInnoDBSQL Execution
0 likes · 18 min read
Unveiling MySQL’s Inner Workings: From SQL Query to InnoDB Storage Engine
dbaplus Community
dbaplus Community
Jul 11, 2022 · Databases

Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them

This article explains why MySQL queries can become sluggish, covering the full query execution flow, profiling techniques, index pitfalls, connection‑pool limits, buffer‑pool sizing, and additional performance tricks, while providing concrete commands and code examples for each optimization step.

Connection PoolIndex OptimizationProfiling
0 likes · 16 min read
Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them
dbaplus Community
dbaplus Community
Jul 4, 2022 · Databases

Why Large‑Offset LIMIT Is Slow in MySQL and How to Speed It Up

The article explains why a MySQL query with a large LIMIT offset becomes extremely slow, demonstrates the underlying I/O behavior, and shows how rewriting the query with a sub‑query that fetches primary keys first can cut execution time from seconds to milliseconds while also reducing buffer‑pool pollution.

InnoDBLIMITSubquery
0 likes · 9 min read
Why Large‑Offset LIMIT Is Slow in MySQL and How to Speed It Up
Liangxu Linux
Liangxu Linux
Jul 3, 2022 · Databases

What’s the Optimal Batch Size for MySQL Inserts? A Deep Performance Test

This article investigates how many rows should be inserted per batch in MySQL by measuring the impact of packet size limits, buffer pool usage, insert buffers, transaction handling and index structures, and it provides practical recommendations based on tests with millions of rows.

Batch Insertbuffer poolmax_allowed_packet
0 likes · 16 min read
What’s the Optimal Batch Size for MySQL Inserts? A Deep Performance Test
Open Source Linux
Open Source Linux
Jul 1, 2022 · Databases

Understanding MySQL Buffers, Cache, and Zero‑Copy I/O: A Deep Dive

This article explains the differences between buffers and caches, explores MySQL’s buffer pool architecture, details write‑through/write‑back strategies, and reviews key InnoDB parameters such as innodb_flush_log_at_trx_commit and innodb_flush_method for optimizing data durability and performance.

CacheFlushInnoDB
0 likes · 12 min read
Understanding MySQL Buffers, Cache, and Zero‑Copy I/O: A Deep Dive
Ops Development Stories
Ops Development Stories
Jun 21, 2022 · Databases

Inside MySQL UPDATE: How Undo, Redo, and Binlog Work

This article explains in detail what happens inside MySQL when an UPDATE statement is executed, covering the execution flow, the roles of undo log, redo log, and binlog, buffer pool mechanics, two‑phase commit, group commit, and practical optimization tips.

Binlogbuffer poolmysql
0 likes · 40 min read
Inside MySQL UPDATE: How Undo, Redo, and Binlog Work
Top Architect
Top Architect
May 6, 2022 · Databases

Optimizing MySQL Batch Insert Performance: Determining the Ideal Batch Size

This article analyzes MySQL batch insertion by examining field size, max_allowed_packet limits, transaction overhead, buffer pool usage, and empirical tests with varying batch sizes, ultimately recommending a batch size around half of the max_allowed_packet for optimal throughput.

Batch Insertbuffer poolinsert buffer
0 likes · 14 min read
Optimizing MySQL Batch Insert Performance: Determining the Ideal Batch Size
NiuNiu MaTe
NiuNiu MaTe
Mar 30, 2022 · Databases

Why Is MySQL Query Slow? Hidden Factors and Proven Speed‑Up Tricks

This article explains why MySQL queries can become sluggish beyond missing indexes, covering the full query execution flow, profiling tools, index pitfalls, connection‑pool limits, InnoDB buffer‑pool sizing, and practical steps to diagnose and accelerate database performance.

Connection Poolbuffer poolindexing
0 likes · 16 min read
Why Is MySQL Query Slow? Hidden Factors and Proven Speed‑Up Tricks
政采云技术
政采云技术
Mar 29, 2022 · Databases

Performance Comparison of Different Batch Insert Strategies in MySQL

This article evaluates single‑threaded bulk‑insert performance in MySQL by testing various batch sizes, analyzes memory usage and transaction merging, and provides practical recommendations for efficiently generating millions of records.

Bulk InsertDatabase OptimizationPerformance Testing
0 likes · 11 min read
Performance Comparison of Different Batch Insert Strategies in MySQL
Top Architect
Top Architect
Mar 5, 2022 · Databases

Why MySQL LIMIT with Large Offsets Is Slow and How to Optimize It

The article demonstrates that MySQL queries using LIMIT with a large offset cause heavy random I/O by scanning many rows, and shows how rewriting the query with a sub‑query that selects only primary keys dramatically reduces execution time from seconds to milliseconds.

LIMITSQLbuffer pool
0 likes · 8 min read
Why MySQL LIMIT with Large Offsets Is Slow and How to Optimize It
Java Architect Essentials
Java Architect Essentials
Feb 24, 2022 · Databases

Why LIMIT Slows MySQL Queries and How to Speed Them Up

This article analyzes why a MySQL query with a large LIMIT offset can take seconds to run, demonstrates the underlying index and buffer‑pool behavior, and shows how rewriting the query with a sub‑select of primary keys reduces execution time from over 16 seconds to under half a second.

LIMITbuffer poolindex
0 likes · 9 min read
Why LIMIT Slows MySQL Queries and How to Speed Them Up
Programmer DD
Programmer DD
Feb 9, 2022 · Databases

Why Full Table Scans Won’t Exhaust MySQL Server Memory

Even when scanning a 200 GB InnoDB table on a server with only 100 GB RAM, MySQL streams results using a small net buffer and an optimized InnoDB buffer‑pool LRU, so the server’s memory never blows up, though I/O load remains high.

Full Table ScanInnoDBLRU algorithm
0 likes · 11 min read
Why Full Table Scans Won’t Exhaust MySQL Server Memory
Top Architect
Top Architect
Jan 22, 2022 · Databases

Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis

The article explains why large‑offset LIMIT queries on a MySQL table with millions of rows are slow, demonstrates how rewriting the query to use a subquery that first selects primary‑key IDs dramatically reduces execution time, and validates the improvement by measuring buffer‑pool page usage.

Database PerformanceSubquerybuffer pool
0 likes · 9 min read
Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis
JavaEdge
JavaEdge
Jan 21, 2022 · Databases

Can MySQL Handle a 100 GB Full Table Scan Without Crashing?

This article explains why a MySQL query that scans a 100‑gigabyte table and returns millions of rows does not exhaust server memory, describing the net_buffer mechanism, socket send buffer behavior, InnoDB buffer‑pool management, and the improved LRU algorithm used to keep large scans from degrading overall performance.

Full Table ScanInnoDBLRU
0 likes · 8 min read
Can MySQL Handle a 100 GB Full Table Scan Without Crashing?
Java Backend Technology
Java Backend Technology
Jan 15, 2022 · Databases

Why Large OFFSETs Slow MySQL Queries and How Subquery Optimization Fixes It

The article explains how using a large OFFSET in MySQL pagination forces the server to read and discard many rows, causing severe performance degradation, and demonstrates that rewriting the query to first fetch primary‑key IDs via a subquery dramatically reduces I/O and execution time, with buffer‑pool experiments confirming the improvement.

Subquerybuffer poolmysql
0 likes · 9 min read
Why Large OFFSETs Slow MySQL Queries and How Subquery Optimization Fixes It
Java Architect Essentials
Java Architect Essentials
Dec 14, 2021 · Databases

Why LIMIT Can Slow Down MySQL Queries and How to Fix It

Using LIMIT with a large offset in MySQL can cause severe performance degradation due to excessive random I/O, but by rewriting the query to first fetch primary keys in a subquery and then joining, execution time can drop from seconds to milliseconds, as demonstrated with real data.

InnoDBLIMITbuffer pool
0 likes · 10 min read
Why LIMIT Can Slow Down MySQL Queries and How to Fix It
Top Architect
Top Architect
Sep 21, 2021 · Databases

Understanding MySQL LIMIT OFFSET Performance and Buffer‑Pool Impact

The article demonstrates how a large OFFSET in a MySQL LIMIT query forces MySQL to scan millions of index rows and data pages, causing severe slowdown, and shows that rewriting the query with an inner‑join sub‑select dramatically reduces I/O and buffer‑pool usage, confirming the performance difference through experiments.

InnoDBLIMITOFFSET
0 likes · 8 min read
Understanding MySQL LIMIT OFFSET Performance and Buffer‑Pool Impact
21CTO
21CTO
Aug 16, 2021 · Databases

Why LIMIT with Large Offsets Slows MySQL and How to Fix It

This article explains why MySQL queries using LIMIT with a large offset become extremely slow, demonstrates the inefficiency through a 950‑million‑row table example, and shows how rewriting the query with a sub‑select join reduces execution time from seconds to milliseconds while preserving results.

InnoDBSQL Optimizationbuffer pool
0 likes · 9 min read
Why LIMIT with Large Offsets Slows MySQL and How to Fix It
ITPUB
ITPUB
Aug 13, 2021 · Databases

Why LIMIT with Large OFFSET Slows MySQL and How to Speed It Up

When a MySQL query uses LIMIT with a large offset on a table of millions of rows, the database must scan hundreds of thousands of index entries and corresponding clustered rows, causing massive random I/O; rewriting the query with a sub‑query join reduces I/O dramatically, cutting execution time from over a minute to under a second while also preventing buffer‑pool pollution.

InnoDBLIMITSQL
0 likes · 9 min read
Why LIMIT with Large OFFSET Slows MySQL and How to Speed It Up
New Oriental Technology
New Oriental Technology
Jun 28, 2021 · Databases

InnoDB Architecture and Key Features: A Comprehensive Overview

This article provides a comprehensive overview of InnoDB architecture, covering its memory structures, background threads, and key features like checkpoint mechanisms, double write, and neighbor page flushing, essential for understanding MySQL's default storage engine.

Background ThreadsCheckpoint MechanismDatabase Architecture
0 likes · 12 min read
InnoDB Architecture and Key Features: A Comprehensive Overview
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 12, 2020 · Databases

Why LIMIT Offset Slows MySQL Queries and How to Optimize Them

This article explains how using a large LIMIT offset on a 9.5‑million‑row MySQL table causes massive I/O and slow queries, and demonstrates a sub‑query‑based rewrite that fetches only primary keys before joining, dramatically reducing execution time while also showing buffer‑pool effects.

buffer poolindexlimit offset
0 likes · 8 min read
Why LIMIT Offset Slows MySQL Queries and How to Optimize Them
Architect
Architect
Dec 10, 2020 · Databases

Optimizing MySQL LIMIT Offset Queries with Subqueries to Reduce Table Scans

This article demonstrates how to dramatically improve MySQL LIMIT offset query performance by moving the filter into a subquery that selects only primary keys, then joining to retrieve full rows, and validates the approach with buffer pool statistics and execution time measurements.

Subquerybuffer poollimit offset
0 likes · 9 min read
Optimizing MySQL LIMIT Offset Queries with Subqueries to Reduce Table Scans
Top Architect
Top Architect
Apr 30, 2020 · Databases

Why LIMIT with Large Offsets Slows MySQL Queries and How to Optimize It

The article explains why using LIMIT with a large offset in MySQL causes severe performance degradation, demonstrates the problem with real data, and shows how rewriting the query with a sub‑query that selects only primary keys dramatically reduces execution time by avoiding massive random I/O and buffer‑pool pollution.

LIMITbuffer poolindex
0 likes · 8 min read
Why LIMIT with Large Offsets Slows MySQL Queries and How to Optimize It
Java Captain
Java Captain
Apr 5, 2020 · Databases

Optimizing MySQL LIMIT Queries by Reducing Row Lookups

This article explains why large OFFSET values in MySQL LIMIT queries cause severe performance degradation and demonstrates how rewriting the query to fetch primary keys first and then joining reduces execution time from seconds to milliseconds, supported by buffer‑pool analysis and practical test results.

LIMITbuffer poolindex
0 likes · 8 min read
Optimizing MySQL LIMIT Queries by Reducing Row Lookups
Efficient Ops
Efficient Ops
Mar 5, 2020 · Databases

Inside MySQL InnoDB: Unveiling Architecture, Memory Structures, and Transaction Mechanics

This article provides a comprehensive overview of MySQL InnoDB's internal architecture, covering its memory and disk structures, buffer pool, change buffer, adaptive hash index, log buffer, various tablespace types, page layout, undo and redo logs, double‑write buffer, transaction isolation levels, and how the engine satisfies ACID properties.

ACIDInnoDBStorage Engine
0 likes · 32 min read
Inside MySQL InnoDB: Unveiling Architecture, Memory Structures, and Transaction Mechanics
Qunar Tech Salon
Qunar Tech Salon
Feb 10, 2020 · Databases

InnoDB Buffer Pool Management Mechanism and Implementation Details

This article explains the theory behind InnoDB's log management, details the architecture and dynamic sizing of the Buffer Pool, describes its internal data structures and multi‑instance implementation, and provides annotated source code snippets to illustrate how MySQL allocates and manages buffer pages.

Database InternalsInnoDBbuffer pool
0 likes · 15 min read
InnoDB Buffer Pool Management Mechanism and Implementation Details
Java Backend Technology
Java Backend Technology
Dec 1, 2019 · Databases

Why Large LIMIT Offsets Slow MySQL Queries and How to Fix Them

This article explains how using a large OFFSET in a MySQL LIMIT clause forces the server to scan hundreds of thousands of index and data pages, causing massive random I/O, and demonstrates a faster rewrite with an inner join that dramatically reduces buffer‑pool usage and execution time.

InnoDBLIMITbuffer pool
0 likes · 7 min read
Why Large LIMIT Offsets Slow MySQL Queries and How to Fix Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 13, 2019 · Databases

Resolving High SQL‑Kill Rate Caused by Buffer‑Pool Dirty‑Page Saturation in MySQL

The article analyzes a recurring MySQL alarm where over 200 SQL statements are killed per minute due to buffer‑pool latch contention and a near‑90% dirty‑page ratio, then demonstrates how adjusting InnoDB parameters and doubling the buffer‑pool size eliminated the kills and restored performance.

Database operationsDirty PagesSQL Kill
0 likes · 7 min read
Resolving High SQL‑Kill Rate Caused by Buffer‑Pool Dirty‑Page Saturation in MySQL
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 5, 2018 · Operations

Boosting Test Environment Stability: Automated Container Replacement & Buffer Pools

This article analyzes the instability of Alibaba's test environment container provisioning, identifies root causes, and presents a comprehensive solution—including automatic container replacement, a buffer pool, and resource‑pool rationalization—that raised the container success rate to 99.9% and stabilized performance.

Operationsbuffer poolcontainer orchestration
0 likes · 9 min read
Boosting Test Environment Stability: Automated Container Replacement & Buffer Pools
ITPUB
ITPUB
Jun 23, 2017 · Databases

Inside MySQL InnoDB Buffer Pool: Architecture, Data Structures, and Optimization

This article provides an in‑depth technical walkthrough of MySQL InnoDB's Buffer Pool, covering its core data structures, instance layout, LRU and Flush list management, memory allocation strategies, read‑ahead/write‑ahead mechanisms, double‑write buffering, and the specialized threads that keep the pool efficient.

Database InternalsInnoDBLRU
0 likes · 39 min read
Inside MySQL InnoDB Buffer Pool: Architecture, Data Structures, and Optimization
dbaplus Community
dbaplus Community
Jun 11, 2017 · Databases

Boost MySQL 5.7 Restarts with InnoDB Buffer Pool Pre‑Load

This article explains how MySQL 5.7 automatically saves and restores InnoDB buffer‑pool pages, how to tune the innodb_buffer_pool_dump_pct setting, monitor load progress, and handle multi‑node deployments or crashes to achieve faster, more predictable startup performance.

ConfigurationInnoDBbuffer pool
0 likes · 6 min read
Boost MySQL 5.7 Restarts with InnoDB Buffer Pool Pre‑Load
Architect
Architect
Apr 8, 2016 · Databases

InnoDB IO Subsystem and Buffer Pool Memory Management Overview

This article explains InnoDB's file I/O interfaces, asynchronous and synchronous read/write mechanisms, background IO threads, AIO request handling, concurrency controls, prefetch strategies, log write padding, and the evolution of buffer pool initialization, chain management, and page eviction in MySQL 5.7.

InnoDBasynchronous-iobuffer pool
0 likes · 19 min read
InnoDB IO Subsystem and Buffer Pool Memory Management Overview
Architect
Architect
Mar 1, 2016 · Databases

In-depth Overview of MySQL InnoDB Page Types, Compression, IO Subsystem, and Buffer Pool Management

This article provides a comprehensive technical overview of MySQL InnoDB's internal page structures—including compressed, system, external, encrypted, and R‑TREE pages—along with detailed explanations of the IO subsystem, double‑write buffer, temporary tablespaces, and buffer pool memory management mechanisms.

Database InternalsIO SubsystemInnoDB
0 likes · 25 min read
In-depth Overview of MySQL InnoDB Page Types, Compression, IO Subsystem, and Buffer Pool Management