| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| trx_id | varchar(18) | No | ||
| trx_state | varchar(13) | No | ||
| trx_started | datetime | No | 0000-00-00 00:00:00 | |
| trx_requested_lock_id | varchar(81) | Yes | NULL | |
| trx_wait_started | datetime | Yes | NULL | |
| trx_weight | bigint(21) | No | 0 | |
| trx_mysql_thread_id | bigint(21) | No | 0 | |
| trx_query | varchar(1024) | Yes | NULL | |
| trx_operation_state | varchar(64) | Yes | NULL | |
| trx_tables_in_use | bigint(21) | No | 0 | |
| trx_tables_locked | bigint(21) | No | 0 | |
| trx_lock_structs | bigint(21) | No | 0 | |
| trx_lock_memory_bytes | bigint(21) | No | 0 | |
| trx_rows_locked | bigint(21) | No | 0 | |
| trx_rows_modified | bigint(21) | No | 0 | |
| trx_concurrency_tickets | bigint(21) | No | 0 | |
| trx_isolation_level | varchar(16) | No | ||
| trx_unique_checks | int(1) | No | 0 | |
| trx_foreign_key_checks | int(1) | No | 0 | |
| trx_last_foreign_key_error | varchar(256) | Yes | NULL | |
| trx_adaptive_hash_latched | int(1) | No | 0 | |
| trx_adaptive_hash_timeout | bigint(21) | No | 0 | |
| trx_is_read_only | int(1) | No | 0 | |
| trx_autocommit_non_locking | int(1) | No | 0 |