Concurrency vs. Throughput: why more parallelism can make databases slower
Summary
A production MySQL throughput incident demonstrates how high concurrency and long transactions can degrade performance due to snapshot reads and backpressure. The article discusses root causes, like long-running transactions, and practical fixes using Vitess transaction pools and queuing to restore throughput and stability.