MySQL Gap Lock: Where Are They Stored and How They Work

In MySQL, gap locks are stored in the InnoDB lock table. The InnoDB storage engine utilizes these locks to prevent phantom reads and ensure data consistency in concurrent transactions. Gap locks are employed to prevent other transactions from inserting new rows into a range of indexed records, thereby maintaining the integrity of the index.