0
0
0
Name INNODB_TRX Ver.  MySQL(5.7) INFORMATION_SCHEMA
Id. INNODB_TRX Func SIUDCEDITEXCEL
Desc.
No. 　Col Name　 CSVTSV\n 　Col Id.　 CSVTSV\n Data Type Null PK Code Def Relation Comment
1 TRX_ID TRX_ID VARCHAR(18) No  
2 TRX_STATE TRX_STATE VARCHAR(13) No  
3 TRX_STARTED TRX_STARTED DATETIME No   '0000-00-00 00:00:00'
4 TRX_REQUESTED_LOCK_ID TRX_REQUESTED_LOCK_ID VARCHAR(81)  
5 TRX_WAIT_STARTED TRX_WAIT_STARTED DATETIME  
6 TRX_WEIGHT TRX_WEIGHT BIGINT(21) UNSIGNED No   0
7 TRX_MYSQL_THREAD_ID TRX_MYSQL_THREAD_ID BIGINT(21) UNSIGNED No   0
8 TRX_QUERY TRX_QUERY VARCHAR(1024)  
9 TRX_OPERATION_STATE TRX_OPERATION_STATE VARCHAR(64)  
10 TRX_TABLES_IN_USE TRX_TABLES_IN_USE BIGINT(21) UNSIGNED No   0
11 TRX_TABLES_LOCKED TRX_TABLES_LOCKED BIGINT(21) UNSIGNED No   0
12 TRX_LOCK_STRUCTS TRX_LOCK_STRUCTS BIGINT(21) UNSIGNED No   0
13 TRX_LOCK_MEMORY_BYTES TRX_LOCK_MEMORY_BYTES BIGINT(21) UNSIGNED No   0
14 TRX_ROWS_LOCKED TRX_ROWS_LOCKED BIGINT(21) UNSIGNED No   0
15 TRX_ROWS_MODIFIED TRX_ROWS_MODIFIED BIGINT(21) UNSIGNED No   0
16 TRX_CONCURRENCY_TICKETS TRX_CONCURRENCY_TICKETS BIGINT(21) UNSIGNED No   0
17 TRX_ISOLATION_LEVEL TRX_ISOLATION_LEVEL VARCHAR(16) No  
18 TRX_UNIQUE_CHECKS TRX_UNIQUE_CHECKS INT(1) No   0
19 TRX_FOREIGN_KEY_CHECKS TRX_FOREIGN_KEY_CHECKS INT(1) No   0
20 TRX_LAST_FOREIGN_KEY_ERROR TRX_LAST_FOREIGN_KEY_ERROR VARCHAR(256)  
21 TRX_ADAPTIVE_HASH_LATCHED TRX_ADAPTIVE_HASH_LATCHED INT(1) No   0
22 TRX_ADAPTIVE_HASH_TIMEOUT TRX_ADAPTIVE_HASH_TIMEOUT BIGINT(21) UNSIGNED No   0
23 TRX_IS_READ_ONLY TRX_IS_READ_ONLY INT(1) No   0
24 TRX_AUTOCOMMIT_NON_LOCKING TRX_AUTOCOMMIT_NON_LOCKING INT(1) No   0
5.2.0 -  zumuzack.com