Understanding MySQL Locks: Which Queries Actually Acquire Locks?

This article breaks down MySQL's complex locking mechanisms—global, table, and row locks—explaining how different SELECT statements, transaction isolation levels, and index types affect lock acquisition, and provides practical test scripts and visual examples to help developers master lock behavior.

InnoDBIsolationLevelLocks

0 likes · 14 min read

Understanding MySQL Locks: Which Queries Actually Acquire Locks?

System Architect Go

Jul 26, 2017 · Databases

Handling Concurrent Updates in MySQL InnoDB with Sequelize: Transaction Isolation and Row Locks

This article explains how concurrent transactions updating the same MySQL InnoDB row can cause inconsistent results, reviews InnoDB isolation levels and lock types, and demonstrates using SERIALIZABLE isolation combined with exclusive row locks in Sequelize to ensure correct sequential updates.

InnoDBIsolationLevelRowLock

0 likes · 4 min read

Handling Concurrent Updates in MySQL InnoDB with Sequelize: Transaction Isolation and Row Locks