Transactions and concurrent writes

Verify commit, rollback, affected rows and connection-scoped row locks.

MySQL transactions, affected rows and row locks

Verify commit/rollback and held-row conflicts with explicit failure and retry boundaries.