Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  Sys Schema Table Metadata Lock Waits Metrics

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

NameDescription
Blocking AccountThe account of the session that is blocking the current waiter(s).
Blocking Lock DurationThe 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 TypeThe 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 PidThe connection ID of the session that is blocking the current waiter(s).
Blocking Thread IdThe Performance Schema THREAD_ID of the session that is blocking the current waiter(s).
Object NameThe table being waited for.
Object SchemaThe schema that contains the table.
Waiting AccountThe account of the session that is waiting.
Waiting Lock DurationThe 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 TypeThe 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 PidThe connection ID of the session that is waiting.
Waiting QueryThe statement that is currently being blocked.
Waiting Query Rows AffectedThe number of rows that the statement currently waiting has already changed.
Waiting Query Rows ExaminedThe number of rows that the statement currently waiting has already read.
Waiting Query SecsThe number of seconds that the waiting statement has been running for.
Waiting Thread IdThe Performance Schema THREAD_ID of the session that is waiting.