Xiaolei Talks DB

Jul 21, 2021 · Databases

Optimistic vs Pessimistic Transactions in TiDB: 10x Performance Boost

This article compares TiDB's optimistic and pessimistic transaction models through a real‑world high‑concurrency write‑conflict scenario, showing how pessimistic locking can achieve over ten times higher throughput than optimistic retries.