MySQL
8 items using MySQL
Blog Posts
MySQL Internals Series, Part 7: Connection Management & Thread Model
How MySQL handles concurrent connections — thread pool, connection limits, resource management, and why connection pooling is essential.
MySQL Internals Series, Part 6: Binary Logging & Replication
How MySQL survives crashes and enables replication — binary log format, GTID, crash recovery, and streaming replication.
MySQL Internals Series, Part 5: Buffer Pool & Memory Management
How InnoDB caches pages in memory — buffer pool, LRU eviction, dirty pages, checkpoints, and sizing.
MySQL Internals Series, Part 4: Query Execution & Optimization
How MySQL optimizes queries — cost model, statistics, execution plans, and steering the optimizer with hints.
MySQL Internals Series, Part 3: Indexes & B-Trees
How MySQL indexes work — B-tree structure, clustered vs secondary, covering indexes, adaptive hash indexes, and index fragmentation.
MySQL Internals Series, Part 2: MVCC & Transactions
How MySQL isolates transactions — MVCC, undo logs, transaction IDs, isolation levels, and the purge thread.
MySQL Internals Series, Part 1: Storage Engine & InnoDB Basics
How InnoDB stores data on disk — page structure, row format, clustered indexes, B-trees, and why the primary key matters.
MySQL Internals Series, Part 0: Overview
A roadmap through MySQL 8.4 LTS internals — from storage engines to replication. Why understanding the engine matters and what you'll learn.