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

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