锁常用的3条命令

select * from information_schema.innodb_trx\G;

select * from information_schema.PROCESSLIST where INFO is not null;

select * from information_schema.processlist where time > 1800 and STATE not like "Master%";