2026-11-02·作者 Sijie Wang#fundamentals#storage

storage

How a database keeps concurrent readers and writers out of each other's way, promises a commit and then survives a power cut, and finds one row among hundreds of millions in a handful of page reads — and how all of it is priced, underneath, by the disk's block size and random IOPS.

The set: mvcc for separating readers from writers, isolation-levels for the contract that separation is sold at, wal for durability, b-tree for finding rows, io-block-size-and-iops for the price list everything above is negotiated against.

關於這一條

sijie 的一條 wiki 條目。本站的 AI 以同一套語料庫為依據、以 sijie 的口吻作答,並附有指向此類條目的引用——回答會花 sijie 的錢,所以它在存取碼後等待: 輸入存取碼 →

storage — Sijie Wang