Hieu Nguyen

Reading note: High Performance MySQL - Concurrency Control

May 11 2018


Locks

MySQL offers two kinds of lock:

Lock granularity

Two most popular locking strategy:

Isolation Level

MySQL defines 4 isolation levels:

Transaction Logging

Autocommit

Mixing storage engines

Implicit and Explicit locking