Aikesheng Open Source Community

Aug 6, 2021 · Databases

Exploring the Relationship Between InnoDB Locks and Buffer Pool Size in MySQL

This article conducts a hands‑on experiment to demonstrate how a transaction that acquires many InnoDB locks consumes buffer‑pool memory, leading to the "total number of locks exceeds the lock table size" error when buffer‑pool usage approaches its theoretical 75% threshold.