------------------------
LATEST DETECTED DEADLOCK
------------------------
140824 1:01:24
*** (1) TRANSACTION:
TRANSACTION 110E, ACTIVE 73 sec starting index read ## 事务ID=110E,活跃了73s
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 376, 2 row lock(s) ## 有2个行锁
MySQL thread id 1, OS thread handle 0x7f55ea639700, query id 81 localhost root updating ## 该事务的线程ID=1
delete from t1 where a=1 ## 这是当前事务执行的SQL
*** (1) WAITING FOR THIS LOCK TO BE GRANTED: ## 上面SQL等待的锁信息
RECORD LOCKS space id 12 page no 3 n bits 80 index `PRIMARY` of table `test`.`t1` trx id 110E lock_mode X locks rec but not gap waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 ## 等待在主键上的page num=3上有加一个X锁(not gap waiting),锁80 bits
0: len 4; hex 80000001; asc