6.36 Sys Schema Table Metadata Lock Waits Metrics

Lists the Sys Schema Table Metadata Lock Waits metrics and provides a brief description of each.

Table 6.36 Sys Schema Table Metadata Lock Waits Metrics

Name	Description
Blocking Account	The account of the session that is blocking the current waiter(s).
Blocking Lock Duration	The lock duration from the metadata lock subsystem for the session blocking the current waiter(s). The value is one of STATEMENT, TRANSACTION, or EXPLICIT. The STATEMENT and TRANSACTION values are for locks that are released at statement or transaction end, respectively. The EXPLICIT value is for locks that survive statement or transaction end and are released explicitly, such as global locks acquired with FLUSH TABLES WITH READ LOCK.
Blocking Lock Type	The lock type from the metadata lock subsystem for the session blocking the current waiter(s). The value is one of INTENTION_EXCLUSIVE, SHARED, SHARED_HIGH_PRIO, SHARED_READ, SHARED_WRITE, SHARED_UPGRADABLE, SHARED_NO_WRITE, SHARED_NO_READ_WRITE, or EXCLUSIVE.
Blocking Pid	The connection ID of the session that is blocking the current waiter(s).
Blocking Thread Id	The Performance Schema THREAD_ID of the session that is blocking the current waiter(s).
Object Name	The table being waited for.
Object Schema	The schema that contains the table.
Waiting Account	The account of the session that is waiting.
Waiting Lock Duration	The lock duration from the metadata lock subsystem for the session that is waiting. The value is one of STATEMENT, TRANSACTION, or EXPLICIT. The STATEMENT and TRANSACTION values are for locks that are released at statement or transaction end, respectively. The EXPLICIT value is for locks that survive statement or transaction end and are released explicitly, such as global locks acquired with FLUSH TABLES WITH READ LOCK.
Waiting Lock Type	The lock type from the metadata lock subsystem for the session that is waiting. The value is one of INTENTION_EXCLUSIVE, SHARED, SHARED_HIGH_PRIO, SHARED_READ, SHARED_WRITE, SHARED_UPGRADABLE, SHARED_NO_WRITE, SHARED_NO_READ_WRITE, or EXCLUSIVE.
Waiting Pid	The connection ID of the session that is waiting.
Waiting Query	The statement that is currently being blocked.
Waiting Query Rows Affected	The number of rows that the statement currently waiting has already changed.
Waiting Query Rows Examined	The number of rows that the statement currently waiting has already read.
Waiting Query Secs	The number of seconds that the waiting statement has been running for.
Waiting Thread Id	The Performance Schema THREAD_ID of the session that is waiting.