--source include/have_innodb.inc set transaction isolation level REPEATABLE READ; CREATE TABLE t (i INT) ENGINE = InnoDB; INSERT INTO t (i) VALUES(1); CREATE TABLE t1 (i INT) ENGINE = InnoDB; INSERT INTO t1 (i) VALUES(1); START TRANSACTION; SELECT * FROM t WHERE i = 1 LOCK IN SHARE MODE; connect(addconroot, localhost, root,,); connection addconroot; set transaction isolation level REPEATABLE READ; START TRANSACTION; DELETE FROM t1 WHERE i = 1; show global status where Variable_name = 'Innodb_row_lock_current_waits'; show status where Variable_name = 'Innodb_row_lock_current_waits'; --send DELETE FROM t WHERE i = 1 connect(addconroot1, localhost, root,,); connection addconroot1; --send DELETE FROM t1 WHERE i = 1 -- connection default show global status where Variable_name = 'Innodb_row_lock_current_waits'; show status where Variable_name = 'Innodb_row_lock_current_waits'; --error 1213 DELETE FROM t WHERE i = 1; show global status where Variable_name = 'Innodb_row_lock_current_waits'; sleep 10; show global status where Variable_name = 'Innodb_row_lock_current_waits'; rollback; show global status where Variable_name = 'Innodb_row_lock_current_waits'; sleep 10; show global status where Variable_name = 'Innodb_row_lock_current_waits'; connection addconroot; --reap rollback; connection addconroot1; --reap rollback; show global status where Variable_name = 'Innodb_row_lock_current_waits'; sleep 10; show global status where Variable_name = 'Innodb_row_lock_current_waits';