数据库事务查询

trx.sql

# 事务隔离级别,
# READ-UNCOMMITTED 读未提交
# READ-COMMITTED 读提交
# REPEATABLE-READ 可重复读
# SERIALIZABLE 串行化
show variables like 'transaction_isolation';

# 事务事件执行事件大于 60 秒的操作
select * from information_schema.innodb_trx where TIME_TO_SEC(timediff(now(),trx_started))>60;