Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
INNODB_TRX
|
trx_id
|
varchar(18)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
INNODB_TRX
|
trx_state
|
varchar(13)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
INNODB_TRX
|
trx_started
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_requested_lock_id
|
varchar(81)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
INNODB_TRX
|
trx_wait_started
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_weight
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_mysql_thread_id
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_query
|
varchar(1024)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
INNODB_TRX
|
trx_operation_state
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
INNODB_TRX
|
trx_tables_in_use
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_tables_locked
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_lock_structs
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_lock_memory_bytes
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_rows_locked
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_rows_modified
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_concurrency_tickets
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_isolation_level
|
varchar(16)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
INNODB_TRX
|
trx_unique_checks
|
int(1)
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_foreign_key_checks
|
int(1)
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_last_foreign_key_error
|
varchar(256)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
INNODB_TRX
|
trx_adaptive_hash_latched
|
int(1)
|
|
|
|
|
NULL
|
NULL
|
|
INNODB_TRX
|
trx_adaptive_hash_timeout
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|