MySQL :: MySQL 9.1 Reference Manual :: 29.12.13 Performance Schema Lock Tables

PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb

version 9.1

9.6
9.5
9.4
9.3
9.2
9.0
8.4 current
8.0
5.7

8.0 Japanese

MySQL 9.1 Reference Manual / ... / Performance Schema Lock Tables

The Performance Schema exposes lock information through these tables:

data_locks: Data locks held and requested
data_lock_waits: Relationships between data lock owners and data lock requestors blocked by those owners
metadata_locks: Metadata locks held and requested
table_handles: Table locks held and requested

The following sections describe these tables in more detail.

PREV HOME UP NEXT

PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb