查看当前正在执行的事务 select * from information_schema.innodb_trx 获取执行时间大于30秒的事务 select * from information_schema.innodb_trx where TIME_TO_SEC(timediff(now(),trx_started))>30