监控大批量的插入,修改和删除:
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)
