性能查找锁表的sql

SELECT * FROM information_schema.innodb_lock_waits ;

SELECT * FROM information_schema.innodb_locks ;

SELECT * FROM information_schema.innodb_trx ;

SELECT * FROM information_schema.processlist WHERE command<>'Sleep' ;