InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive) All together now Let’s now put together all that we’ve learned in InnoDB Data Locking – Part 2 “Locks” about table and record locks to understand following situation: mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM t FOR SHARE; +—-+ | id | +—-+ | 5 | | 10 | | 42 | +—-+ 3 rows in set (0.00 sec) mysql> DELETE FROM t WHERE id=10; Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t VALUES (4); Query OK, 1 row affected (0.00 sec) mysql> SELECT INDEX_NAME,LOCK_TYPE,LOCK_DATA,LOCK_MODE FROM performance_schema.data_locks … Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive)