MySQL - day 9 - Blocking

Опубликовано: 15 Март 2026
на канале: SQL Depository

2,011

Start Transaction;
Update employees set birth_date='1953-09-03' where emp_no=10001;

Start Transaction;

Update employees set birth_date='1953-09-04' where emp_no=10001;

select * from information_schema.innodb_trx\G

SELECT
r.trx_id waiting_trx_id,
r.trx_mysql_thread_id waiting_thread,
r.trx_query waiting_query,
b.trx_id blocking_trx_id,
b.trx_mysql_thread_id blocking_thread,
b.trx_query blocking_query
FROM information_schema.innodb_lock_waits w
INNER JOIN information_schema.innodb_trx b
ON b.trx_id = w.blocking_trx_id
INNER JOIN information_schema.innodb_trx r
ON r.trx_id = w.requesting_trx_id;