Understand deadlock by gap locking in InnoDB

When we develop a web application, sometimes we want to implement a DB-related logic like SELECT and INSERT if the row is not found. However, this may cause deadlock in InnoDB under a specific condition. This article explains what is a Gap lock, and ...