Interview notes: how I answered a question about the MySQL concurrency model
Most MySQL articles stop at "how to use it" and never cover "when not to use it". This is an attempt at the second half.
# Load test: do not jump straight to the max concurrency. # Ramp it up, otherwise you miss the knee. for c in 50 100 200 400 800; do wrk -t8 -c$c -d60s --latency http://127.0.0.1:8080/api/feed sleep 20 done
What genuinely surprised me was the tail. The average looked great while P99 jumped by an order of magnitude past some threshold. The cause was not MySQL itself but our upstream connection reuse — the load test traffic was too clean and hid the long-tail requests.
On trade-offs, my view is this: if nobody on the team owns this area long-term, do not introduce a second mechanism. With two coexistence you first have to work out which one is even in play when things break, and that costs far more than the performance you saved.
Worth noting: the official docs do cover this, just in a very inconspicuous spot. I only found it reading the source comments, where the author explains the reasoning — roughly "so that it degrades into predictable behaviour in extreme cases".
We also fixed monitoring along the way: replaced average-based alerts with percentiles and split them per endpoint. False alerts dropped by about seventy percent and the on-call rotation visibly cheered up.