Shulou(Shulou.com)06/01 Report--

1 、 infomation_schema.innodb_lock_waits

+-+ +

| | Field | Type | Null | Key | Default | Extra | |

+-+ +

| | requesting_trx_id | varchar (18) | NO | # id of the transaction requesting lock |

| | requested_lock_id | varchar (81) | NO | # id for requesting lock |

| | blocking_trx_id | varchar (18) | NO | # id of transactions with locks |

| | blocking_lock_id | varchar (81) | NO | # id with lock |

+-+ +

2 、 information_schema.innodb_trx

+-+ +

| | Field | Type | Null | Key | Default | Extra | |

+-+ +

| | trx_id | varchar (18) | NO | # transaction id |

| | trx_state | varchar (13) | NO | # transaction execution status |

| | trx_started | datetime | NO | | 0000-0000: 00:00 | | # time when the transaction starts |

| | trx_requested_lock_id | varchar (81) | YES | | NULL | | # Lock id that the transaction is waiting for |

| | trx_wait_started | datetime | YES | | NULL | | # time for the transaction to wait for the lock to start |

| | trx_weight | bigint (21) unsigned | NO | | 0 | | # transaction weight, which mainly reflects the number of rows modified and locked by the transaction |

| | trx_mysql_thread_id | bigint (21) unsigned | NO | | 0 | | # id of the corresponding thread of the transaction |

| | trx_query | varchar (1024) | YES | | NULL | | # transaction SQL statement |

| | trx_operation_state | varchar (64) | YES | | NULL | | # current operation of the transaction |

| | trx_tables_in_use | bigint (21) unsigned | NO | | 0 | | # number of tables currently used by SQL in transaction processing |

| | trx_tables_locked | bigint (21) unsigned | NO | | 0 | | # the number of tables in the transaction that the SQL currently owns row locks |

| | trx_lock_structs | bigint (21) unsigned | NO | | 0 | | # number of locks retained by the transaction |

| | trx_lock_memory_bytes | bigint (21) unsigned | NO | | 0 | | # memory occupied by transaction lock structure |

| | trx_rows_locked | bigint (21) unsigned | NO | | 0 | | # approximate number of rows locked by the transaction |

| | trx_rows_modified | bigint (21) unsigned | NO | | 0 | | # number of rows modified and inserted by the transaction |

| | trx_concurrency_tickets | bigint (21) unsigned | NO | | 0 | | # indicates the amount of work to be processed before the current transaction is swapped out |

| | trx_isolation_level | varchar (16) | NO | # isolation level of the current transaction |

| | trx_unique_checks | int (1) | NO | | 0 | | # only check whether the current transaction is enabled |

| | trx_foreign_key_checks | int (1) | NO | | 0 | | # Foreign key checks whether the current transaction is enabled |

| | trx_last_foreign_key_error | varchar (256) | YES | | NULL | | # details of recent foreign key error reports |

| | trx_adaptive_hash_latched | int (1) | NO | | 0 | | # whether the current transaction locks adaptive hash indexing |

| | trx_adaptive_hash_timeout | bigint (21) unsigned | NO | | 0 | | # indicates whether the current transaction abandons or retains the value of searching the adaptive index. If it is 0, it will be abandoned immediately. |

| | trx_is_read_only | int (1) | NO | | 0 | | # whether the current transaction is read-only. 1 is read-only. |

| | trx_autocommit_non_locking | int (1) | NO | | 0 | | # indicates whether the current transaction is automatically committed without locking |

+-+ +

3 、 information_schema.innodb_locks

+-+ +

| | Field | Type | Null | Key | Default | Extra | |

+-+ +

| | lock_id | varchar (81) | NO | # Lock id |

| | lock_trx_id | varchar (18) | NO | # id of transactions with locks |

| | lock_mode | varchar (32) | NO | # Lock mode |

| | lock_type | varchar (32) | NO | # Lock type |

| | lock_table | varchar (1024) | NO | # locked table |

| | lock_index | varchar (1024) | YES | | NULL | | # locked index |

| | lock_space | bigint (21) unsigned | YES | | NULL | | # locked table space number |

| | lock_page | bigint (21) unsigned | YES | | NULL | | # locked page number |

| | lock_rec | bigint (21) unsigned | YES | | NULL | | # locked record number |

| | lock_data | varchar (8192) | YES | | NULL | | # locked data |

+-+ +

4 、 information_schema.processlist

+-+ +

| | Field | Type | Null | Key | Default | Extra | |

+-+ +

| | ID | bigint (21) unsigned | NO | | 0 | | # id of the connection thread |

| | USER | varchar (32) | NO | # Log in to the user of mysql |

| | HOST | varchar (64) | NO | # Host name or address of login mysql: Port |

| | DB | varchar (64) | YES | | NULL | | # Log in to the database name of mysql |

| | COMMAND | varchar (16) | NO | # the type of command currently running by the connection thread |

| | TIME | int (7) | NO | | 0 | | # the number of seconds that the connection thread is in the current state |

| | STATE | varchar (64) | YES | | NULL | | # current status of the connection thread |

| | INFO | longtext | YES | | NULL | | # statement currently being executed by the connection thread |

+-+ +

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.