RECORD LOCKS space id 0 page no 46 n bits 80 index PRIMARY of table `test`.`t1` trx id 227600 lock_mode X locks rec but not gap waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 0000000a; asc ;; 1: len 6; hex 000000035...
*** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 11 page no 5 n bits 72 index idx_stuno of table cw***.***student trx id 2321 lock_mode X locks gap before rec insert intention waiting 表示事务 2 的 insert 语句正在等待插入意向锁 lock_mode X locks gap before ...
RECORD LOCKS space id 50 page no 6 n bits 72 index uc2 of table `test`.`dl` trx id 1422664 lock_mode X locks gap before rec Record lock, heap no 3 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id ...
*** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 11 page no 5 n bits 72 index idx_stuno of tablecw**.**studenttrx id 2321 lock_mode X locks gap before rec insert intention waiting 表示事务 2 的 insert 语句正在等待插入意向锁 lock_mode X locks gap before rec in...
3)正在等待锁释放(WAITING FOR THIS LOCK TO BE GRANTED),插入意向排他锁(lock_mode X locks gap before rec insert intention waiting),普通索引(idx_name),物理记录(PHYSICAL RECORD),间隙区间(未知,Wei); 第二部分 1)找到关键词TRANSACTION,事务38049 ...
*** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 11 page no 5 n bits 72 index idx_stuno of table `cw`.`student` trx id 2322 lock_mode X waiting RECORD LOCKS 表示记录锁, 此条内容表示事务 1 正在等待表 student 上的 idx_stuno 的 X 锁,本案例中其实是 Next-Key...
*** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 2632 page no 5065 n bits 440 index `uniq_table_name_col1` of table `tablename` trx id 46497170214 lock mode S rec but not gap Record lock, heap no 374 *** (2) WAITING FOR THIS LOCK TO BE GRANTED: ...
Record lock, heap no 55 PHYSICAL RECORD: n_fields 16; compact format; info bits 0 *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 388279 page no 4 n bits 152 index PRIMARY of table `test`.`test` trx id 12739557 lock_mode X locks rec but not gap waiting ...
Record lock, heap no 4 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 50 page no 6 n bits 72 index uc2 of table `test`.`dl` trx id 1422661 lock_mode X locks gap before rec insert intention waiting...
记录锁Record Lock 记录锁是对索引记录的锁。例SELECT c1 FROM t WHERE c1 = 10 FOR UPDATE;阻止任何其他事务插入、更新或删除值为 的t.c1行10。 插入意向锁Insert Intention Locks 插入意向锁是一种INSERT在行插入之前由操作设置的间隙锁。此锁表示插入的意图,即如果插入到同一索引间隙中的多个事务未插入到间隙...