找最老事务
找最老事务
SELECT trx_id, trx_state, trx_started,
TIMESTAMPDIFF(SECOND, trx_started, NOW()) AS age_s,
trx_rows_modified, trx_mysql_thread_id, trx_query
FROM information_schema.INNODB_TRX
ORDER BY trx_started LIMIT 10;| trx_state | RUNNING / LOCK WAIT / ROLLING BACK |
|---|---|
| age | 长事务判定：超过业务阈（如 60s）告警 |
| rows_modified | 已改行数——评估回滚代价 |
监控系统按 age 阈值告警「长事务」，比事故后排查提前一步。