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