监控大批量的插入,修改和删除: mysql> insert into aaa select * from aaa; mysql> SELECT trx_id, trx_state, trx_started, trx_wait_started, trx_weight, trx_mysql_thread_id, trx_query, trx_operation_state, TRX_TABLES_IN_USE, trx_rows_locked FROM information_schema.innodb_trx; +--------+-----------+---------------------+------------------+------------+---------------------+-----------------------------------+---------------------+-------------------+-----------------+ | trx_id | trx_state | trx_started | trx_wait_started | trx_weight | trx_mysql_thread_id | trx_query | trx_operation_state | TRX_TABLES_IN_USE | trx_rows_locked | +--------+-----------+---------------------+------------------+------------+---------------------+-----------------------------------+---------------------+-------------------+-----------------+ | 2350 | RUNNING | 2016-05-11 16:51:11 | NULL | 3760181 | 83 | insert into aaa select * from aaa | fetching rows | 2 | 7354648 | +--------+-----------+---------------------+------------------+------------+---------------------+-----------------------------------+---------------------+-------------------+-----------------+ 1 row in set (0.03 sec)