mysql事务监控语句

原创于 2025-12-20 11:54:34 发布 · 142 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#mysql #数据库

收录于

MySQL 专栏收录该内容

25 篇文章

订阅专栏

-- 查看活跃事务
SELECT * FROM information_schema.INNODB_TRX\G

-- 查看锁信息
SELECT * FROM information_schema.INNODB_LOCKS;
SELECT * FROM information_schema.INNODB_LOCK_WAITS;

-- 查看回滚段状态
SELECT * FROM information_schema.INNODB_ROLLBACK_SEGMENTS;


-- 查找运行时间超过60秒的事务
SELECT trx_id, trx_started, TIMEDIFF(NOW(), trx_started) as duration,trx_state, trx_query FROM information_schema.INNODB_TRX WHERE TIMEDIFF(NOW(), trx_started) > '00:01:00' ORDER BY trx_started;


-- 监控事务
SELECT COUNT(*) as active_transactions,MAX(TIMEDIFF(NOW(), trx_started)) as longest_tx FROM information_schema.INNODB_TRX;