trx_operation_state:事务当前操作的状态。例如,它可能显示“executing”或者“fetching rows” trx_tables_in_use:事务当前使用的表的数量。 trx_tables_locked:事务当前锁定的表的数量。 trx_lock_structs:事务持有的锁结构的数量 trx_lock_memory_bytes:事务持有的锁所占用
trx_operation_state: sleeping before entering InnoDB trx_concurrency_tickets: 0 我们可以看到事务操作状态被标记为‘sleeping before entering InnoDB’。但是需要注意一点的是对于只读事务比如select操作而言,show engine innodb status可能看不到。但是遗憾的是案例中朋友并没有采集trx_operation_state的值。 四、模拟...
trx_query: select count(*) from john where table_name='CHARACTER_SETS' for update//锁等待的语句// trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 376 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrenc...
trx_operation_state: fetchingrowstrx_tables_in_use:15trx_tables_locked:3597trx_lock_structs:1856514trx_lock_memory_bytes:169681104trx_rows_locked:101871982trx_rows_modified:0trx_concurrency_tickets:2338trx_isolation_level:REPEATABLEREADtrx_unique_checks:1trx_foreign_key_checks:1trx_last_foreign_key_e...
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_started: 2021-08-11 03:49:50 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1856514 trx_mysql_thread_id: 6891 trx_query: INSERT INTO db01.tb_mrt_par_user_order_info_d ( deal_date ……忽略字段信息 ,copartner_code trx_operation_state: fetching rows trxtables_in...
trx_operation_state:事务当操作的类型 如updating or deleting,starting index read等 trx_tables_in_use:查询用到的表的数量 trx_tables_locked:查询加行锁的表的数量 trx_rows_locked:事务锁住的行数(不是准确数字) trx_rows_modified:事务插入或者修改的行数 ...
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_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_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 |...