Set an appropriate transaction isolation level

Set an appropriate transaction isolation level | BeforeMerge Rules | BeforeMerge

Why this matters

InnoDB defaults to REPEATABLE READ, which can hold gap locks and increase deadlocks in high-write workloads. Many OLTP systems run better on READ COMMITTED. Pick the level that matches your consistency requirements rather than accepting the default blindly.

-- Good: choose deliberately for the workload
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
 
START TRANSACTION;
-- ... statements ...
COMMIT;

Why This Matters

Related Rules

Catch this automatically on every PR

Why this matters