事务统计SQL

 查看长时间运行的事务 时间超过60S

select * from information_schema.innodb_trx where TIME_TO_SEC(timediff(now(),trx_started))>60