mysql 监控 大批量的插入,删除,和修改

监控大批量的插入,修改和删除:

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)

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6200070.html