29.12.13 Performance Schema Lock Tables

29.12.13.1 The data_locks Table

29.12.13.2 The data_lock_waits Table

29.12.13.3 The metadata_locks Table

29.12.13.4 The table_handles Table

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.