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 ...
tanishiking.hashnode.dev4 min read