SELECT
a.id,a.user,a.host,b.trx_started,b.trx_query
FROM information_schema.processlist a RIGHT OUTER JOIN information_schema.innodb_trx b
ON a.id = b.trx_mysql_thread_id;
mysql 查看未提交的事务
最新推荐文章于 2024-04-25 14:01:01 发布
SELECT
a.id,a.user,a.host,b.trx_started,b.trx_query
FROM information_schema.processlist a RIGHT OUTER JOIN information_schema.innodb_trx b
ON a.id = b.trx_mysql_thread_id;