1
object_schema
varchar(64)
utf8mb3_general_ci
Yes
NULL
Object schema.
2
object_name
varchar(64)
utf8mb3_general_ci
Yes
NULL
Object name.
3
waiting_thread_id
bigint(20)
UNSIGNED
No
None
A unique thread identifier.
4
waiting_pid
bigint(20)
UNSIGNED
Yes
NULL
The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
5
waiting_account
text
utf8mb3_general_ci
Yes
NULL
6
waiting_lock_type
varchar(32)
utf8mb3_general_ci
No
None
Lock type. One of BACKUP_FTWRL1, BACKUP_START, BACKUP_TRANS_DML, EXCLUSIVE, INTENTION_EXCLUSIVE, SHARED, SHARED_HIGH_PRIO, SHARED_NO_READ_WRITE, SHARED_NO_WRITE, SHARED_READ, SHARED_UPGRADABLE or SHARED_WRITE.
7
waiting_lock_duration
varchar(32)
utf8mb3_general_ci
No
None
Lock duration. One of EXPLICIT (locks released by explicit action, for example a global lock acquired with FLUSH TABLES WITH READ LOCK) , STATEMENT (locks implicitly released at statement end) or TRANSACTION (locks implicitly released at transaction end).
8
waiting_query
longtext
utf8mb3_general_ci
Yes
NULL
Statement being executed by the thread, or NULL if a statement is not being executed. If a statement results in calling other statements, such as for a stored procedure, the innermost statement from the stored procedure is shown here.
9
waiting_query_secs
bigint(20)
Yes
NULL
Time in seconds the thread has been in its current state.
10
waiting_query_rows_affected
bigint(20)
UNSIGNED
Yes
NULL
Number of rows affected the statement affected.
11
waiting_query_rows_examined
bigint(20)
UNSIGNED
Yes
NULL
Number of rows read during the statement's execution.
12
blocking_thread_id
bigint(20)
UNSIGNED
No
None
A unique thread identifier.
13
blocking_pid
bigint(20)
UNSIGNED
Yes
NULL
The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
14
blocking_account
text
utf8mb3_general_ci
Yes
NULL
15
blocking_lock_type
varchar(32)
utf8mb3_general_ci
No
None
Lock type. One of BACKUP_FTWRL1, BACKUP_START, BACKUP_TRANS_DML, EXCLUSIVE, INTENTION_EXCLUSIVE, SHARED, SHARED_HIGH_PRIO, SHARED_NO_READ_WRITE, SHARED_NO_WRITE, SHARED_READ, SHARED_UPGRADABLE or SHARED_WRITE.
16
blocking_lock_duration
varchar(32)
utf8mb3_general_ci
No
None
Lock duration. One of EXPLICIT (locks released by explicit action, for example a global lock acquired with FLUSH TABLES WITH READ LOCK) , STATEMENT (locks implicitly released at statement end) or TRANSACTION (locks implicitly released at transaction end).
17
sql_kill_blocking_query
varchar(31)
utf8mb3_general_ci
Yes
NULL
18
sql_kill_blocking_connection
varchar(25)
utf8mb3_general_ci
Yes
NULL