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.

DatabaseLocksImplicitLockInnoDB

0 likes · 9 min read

Understanding Implicit Locks in MySQL InnoDB

dbaplus Community

Aug 3, 2020 · Databases

Why Oracle OOM Happens: Hidden Lock Leak and How to Diagnose It

This article explains the meaning of Java OOM errors, presents a real‑world case where an Oracle database lock caused a slow memory leak leading to OOM, details the lock types and modes, provides SQL to identify and kill offending sessions, and offers best‑practice tips to avoid lock‑related performance issues.

DatabaseLocksJavaOracle

0 likes · 10 min read

Why Oracle OOM Happens: Hidden Lock Leak and How to Diagnose It