Locks in InnoDB: from the global lock to gap locks, read through data_locks
A money transfer that drives a balance negative, MySQL's lock types from global down to row level (intention, AUTO-INC, record, gap, next-key, insert intention), and performance_schema.data_locks for each kind of statement at REPEATABLE READ and READ COMMITTED, measured on MySQL 8.4.