死锁

锁等待的对应关系
select * from information_schema.innodb_lock_waits;

当前出现的锁
select * from information_schema.innodb_locks;

当前运行的所有事务
select * from information_schema.innodb_trx;

当前线程详情
show full processlist;

查看最近死锁的日志
show engine innodb status