Mysql 如何发现InnoDB大事务

方法1、Use INFORMATION_SCHEMA

information_schema.innodb_trx表的trx_rows_modified列显示事务处理了多少行

(Sat Sep 2 11:21:53 2023)[root@GreatSQL][(none)]>select trx_id, trx_state,trx_started, trx_rows_modified from information_schema.innodb_trx order by trx_rows_modified desc limit 20; +---------+-----------+---------------------+-------------------+ | trx_id | trx_state | trx_started | trx_rows_modified | +---------+-----------+---------------------+-------------------+ | 1337785 | RUNNING | 2023-09-02 11:12:11 | 6 | +---------+-----------+---------------------+-------------------+ 1 row in set (0.00 sec)