show status like 'innodb_row_lock%'; select * from information_schema.innodb_locks; select * from information_schema.innodb_lock_waits; show OPEN TABLES where In_use > 0;
select * from information_schema.innodb_trx;
kill 88693;//kill threadid,需要用锁表的用户执行