hard20 pts · first answer countsmysqllocking
InnoDB gap locks
In MySQL InnoDB at the default REPEATABLE READ level, session A runs SELECT * FROM t WHERE id BETWEEN 10 AND 20 FOR UPDATE inside a transaction. Session B tries INSERT INTO t (id) VALUES (15), and no row with id 15 exists. What happens?
Discussion 0
Join free to post in the discussion.
Related questions
- Why InnoDB over MyISAMDatabase Administrator
- Finding slow MySQL queriesDatabase Administrator
- Workers fighting over jobsDatabase Administrator
- MySQL default isolation levelDatabase Administrator
- Restoring a Percona XtraBackupDatabase Administrator
- A migration froze the whole appDatabase Administrator
- Row vs statement binlog formatDatabase Administrator
- Fixing a recurring deadlockDatabase Administrator