Keyboard shortcuts

Press ← or → to navigate between chapters

Press ? to show this help

Press Esc to hide this help

Storage Engine

The storage engine is where the logical world of SQL tables and rows meets the physical world of disk blocks and bytes. Understanding how data is laid out on disk is fundamental to understanding database performance, concurrency control, and recovery.

This section is divided into the following parts:

  • Disk I/O: A look at the asynchronous I/O layer using io_uring.
  • Page & Tuple Layout: A deep dive into how pages and tuples are physically structured on disk, including the slotted page layout.
  • Table Heap: Explains how tuple versions are managed for MVCC.