Code AnalysisIntermediate 60s

Full table lock from a long transaction

Why can this cause broad latency spikes?

Starter code

BEGIN;
UPDATE inventory SET qty = qty - 1 WHERE sku = ?;
-- application does a slow external HTTP call here
COMMIT;

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.