Understanding the Fine Print of Foreign Keys in MySQL: How to Ensure Referential Integrity When INSERT Values Are Not Enforced

Understanding the Locking Mechanism of MySQL's SELECT FOR UPDATE Statement: A Study on Row-Level and Table-Level Locks.