SELECT * FROM information_schema.INNODB_LOCKs; ## 当前运行的所有事务
SELECT * FROM information_schema.INNODB_TRX; ## 当前出现的锁
SELECT * FROM information_schema.INNODB_LOC_waits; ## 锁等待的对应关系
##查询被锁的表
SHOW OPEN TABLES WHERE In_use > 0;
show processlist; ##kill id
kill 64262;
kill 64259;
kill 64254;
kill 64253;
kill 64252;
kill 64251;
kill 64248;
kill 64247;
kill 64246;
kill 64245;
kill 64236;
kill 64224;
kill 64221;
kill 64189;
kill 64188;