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.
Database ConcurrencyOptimistic TransactionPessimistic Transaction
0 likes · 14 min read