trx_operation_state:事务当操作的类型 如updating or deleting,starting index read等 trx_tables_in_use:查询用到的表的数量 trx_tables_locked:查询加行锁的表的数量 trx_rows_locked:事务锁住的行数(不是准确数字) trx_rows_modified:事务插入或者修改的行数 INNODB_LOCKS表 比较常用的列: lock_id 锁ID lo...
#2 0x00000000009e4dea in srv_conc_enter_innodb_with_atomics (trx=trx@entry=0x7fba4802f9c8) at /home/install/lnmp1.5/src/mysql-5.6.40/storage/innobase/srv/srv0conc.cc:276 #3 srv_conc_enter_innodb (trx=trx@entry=0x7fba4802f9c8) at /home/install/lnmp1.5/src/mysql-5.6.40/storage/inn...
trx_operation_state: NULL trx_tables_in_use: 15 trx_tables_locked: 3442 trx_lock_structs: 1755570 trx_lock_memory_bytes: 159899856 trx_rows_locked: 91807791 trx_rows_modified: 0 trx_concurrency_tickets: 3903 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: ...
#2 0x00000000009e4dea in srv_conc_enter_innodb_with_atomics (trx=trx@entry=0x7fba4802f9c8) at /home/install/lnmp1.5/src/mysql-5.6.40/storage/innobase/srv/srv0conc.cc:276 #3 srv_conc_enter_innodb (trx=trx@entry=0x7fba4802f9c8) at /home/install/lnmp1.5/src/mysql-5.6.40/storage/inn...
5 rows in set (0.00 sec) mysql> mysql> mysql> mysql> mysql> select trx_id,trx_state,trx_query,trx_operation_state,trx_concurrency_tickets from information_schema.innodb_trx \G show processlist; *** 1. row *** trx_id: 84529 trx_state: RUNNING trx_query: insert into baguait4 select...
trx_weight: 15905 trx_mysql_thread_id: 10/在process 里面的id值/ trx_query: select count(*) from john for update;/当前执行的语句/ trx_operation_state: fetching rows trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 15905 ...
trx_state: RUNNING trx_query: select * from baguait1 trx_operation_state: sleeping before entering InnoDB trx_concurrency_tickets: 0 3 rows in set (0.00 sec) +---+---+---+---+---+---+---+---+---+---+ | Id | User | Host | db | Command | Time | State | Info |...
trx_mysql_thread_id:11528 trx_query: INSERT INTO db01.tb_mrt_par_user_order_info_d ( deal_date ……忽略字段信息 ,copartner_code trx_operation_state: NULL trx_tables_in_use:15 trx_tables_locked:3442 trx_lock_structs:1755570 trx_lock_memory_bytes:159899856 ...
从上面可看出,“Purge done for trx's n:o”一直未变,而“History list length”在缓慢增长。 查看当前事务状态 SELECTtrx_id,trx_state,trx_operation_state, trx_isolation_level,trx_startedFROMinformation_schema.INNODB_TRX ORDER BY trx_started; ...
trx_query: select * from baguait1 trx_operation_state: sleeping before entering InnoDB trx_concurrency_tickets: 0 3 rows in set (0.00 sec) +---+---+---+---+---+---+---+---+---+---+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | ...