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%";
原文：https://www.cnblogs.com/long2-20160310/p/14786549.html