information_schema.innodb_trx.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
innodb_trx |
||||||||
trx_adaptive_hash_latched |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
trx_adaptive_hash_timeout |
BIGINT NOT NULL:
5.7-8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
trx_autocommit_non_locking |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_concurrency_tickets |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_foreign_key_checks |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_is_read_only |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_isolation_level |
VARCHAR NOT NULL:
5.7-8
| ENUM NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_last_foreign_key_error |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_lock_memory_bytes |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_lock_structs |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_mysql_thread_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_operation_state |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_query |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_requested_lock_id |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_rows_locked |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_rows_modified |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_schedule_weight |
BIGINT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
trx_started |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_state |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_tables_in_use |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_tables_locked |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_unique_checks |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_wait_started |
DATETIME NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_weight |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||