Performance Schema table_handles Table

MariaDB starting with 10.5.2

The table_handles table was added in MariaDB 10.5.2.

The table_handles table contains table lock information. It uses the wait/lock/table/sql/handler instrument, which is enabled by default.

Information includes which table handles are open, which sessions are holding the locks, and how they are locked.

The table is read-only, and TRUNCATE TABLE cannot be performed on the table.

The maximum number of opened table objects is determined by the performance_schema_max_table_handles system variable.

The table contains the following columns:

Column
Description

Column

Description

OBJECT_TYPE

The table opened by a table handle.

OBJECT_SCHEMA

The schema that contains the object.

OBJECT_NAME

The name of the instrumented object.

OBJECT_INSTANCE_BEGIN

The table handle address in memory.

OWNER_THREAD_ID

The thread owning the table handle.

OWNER_EVENT_ID

The event which caused the table handle to be opened.

INTERNAL_LOCK

The table lock used at the SQL level.

EXTERNAL_LOCK

The table lock used at the storage engine level.

This page is licensed: CC BY-SA / Gnu FDL

Last updated

Was this helpful?