Aikesheng Open Source Community

Aug 28, 2024 · Databases

Understanding Implicit Locks in MySQL InnoDB

This article explains what implicit locks are in MySQL InnoDB, how to identify their presence on primary and secondary index records, the conditions under which they appear, and the process by which they are converted into explicit locks that can be inspected via performance_schema.