sessionA:
test>begin
-> ;
Query OK, 0 rows affected (0.00 sec)
test>select * from tt where id_test=1234 lock in share mode;
±—±--------+
| id | id_test |
±—±--------+
| 4 | 1234 |
±—±--------+
1 row in set (0.01 sec)
sessionB:
test>delete from tt where id_test=1234;
卡住
sessionA:
test>delete from tt where id_test=1234;
Query OK, 1 row affected (0.00 sec)
sessionb被杀掉,a执行
查看锁信息
(none)>show engine innodb status\G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
2016-05-09 16:26:27 7f8ee2123700 INNODB MONITOR OUTPUT
Per second averages calculated from the last 18 seconds
BACKGROUND THREAD
srv_master_thread loops: 9 srv_active, 0 srv_shutdown, 191469 srv_idle
srv_master_thread log flush and writes: 191478
SEMAPHORES
OS WAIT ARRAY INFO: reservation count 23
OS WAIT ARRAY INFO: signal count 23
Mutex spin waits 16, rounds 210, OS waits 7
RW-shared spins 16, rounds 480, OS waits 16
RW-excl spins 0, rounds 0, OS waits 0
Spin rounds per wait: 13.12 mutex, 30.00 RW-shared, 0.00 RW-excl
LATEST DETECTED DEADLOCK</