10.13 Performance Schema Lock Tables

10.13.1 The data_locks Table

10.13.2 The data_lock_waits Table

10.13.3 The metadata_locks Table

10.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.