SELECT *, TIME_TO_SEC(TIMEDIFF(now(),trx_started)) lock_time_sec FROM information_schema.innodb_trx JOIN information_schema.processlist ON processlist.ID=innodb_trx.trx_mysql_thread_id WHERE state='waiting for handler commit' ORDER BY trx_started\G
*************************** 1. row ***************************
trx_id: 6669150460
trx_state: RUNNING
trx_started: 2020-11-30 10:11:31
trx_requested_lock_id: NULL
trx_wait_started: NULL
trx_weight: 2
trx_mysql_thread_id: 352
trx_query: NULL
trx_operation_state: NULL
trx_tables_in_use: 0
trx_tables_locked: 1
trx_lock_structs: 1
trx_lock_memory_bytes: 1136
trx_rows_locked: 0
trx_rows_modified: 1
trx_concurrency_tickets: 0
trx_isolation_level: READ UNCOMMITTED
trx_unique_checks: 1
trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
trx_adaptive_hash_latched: 0
trx_adaptive_hash_timeout: 0
trx_is_read_only: 0
trx_autocommit_non_locking: 0
trx_schedule_weight: NULL
ID: 352
USER: system user
HOST:
DB: NULL
COMMAND: Query
TIME: 1696
STATE: waiting for handler commit
INFO: NULL
lock_time_sec: 0
*************************** 2. row ***************************
trx_id: 6669150459
trx_state: RUNNING
trx_started: 2020-11-30 10:11:31
trx_requested_lock_id: NULL
trx_wait_started: NULL
trx_weight: 3
trx_mysql_thread_id: 351
trx_query: NULL
trx_operation_state: NULL
trx_tables_in_use: 0
trx_tables_locked: 1
trx_lock_structs: 2
trx_lock_memory_bytes: 1136
trx_rows_locked: 1
trx_rows_modified: 1
trx_concurrency_tickets: 0
trx_isolation_level: READ UNCOMMITTED
trx_unique_checks: 1
trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
trx_adaptive_hash_latched: 0
trx_adaptive_hash_timeout: 0
trx_is_read_only: 0
trx_autocommit_non_locking: 0
trx_schedule_weight: NULL
ID: 351
USER: system user
HOST:
DB: NULL
COMMAND: Query
TIME: 1696
STATE: waiting for handler commit
INFO: NULL
lock_time_sec: 0