🗓️ 13082024 1042
📎 #wip #mysql
innodb_concurrency_control
InnoDB & Concurrency Control: InnoDB uses a technique called Multi-Version Concurrency Control (MVCC) to allow multiple transactions to access the same data concurrently without interfering with each other. It achieves this using a combination of row-level locking and maintaining multiple versions of each row.