table_handles
This page is part of MariaDB's Documentation.
The parent of this page is: Performance Schema for MariaDB Enterprise Server
Topics on this page:
Overview
In 23.08 ES, 23.07 ES, 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS:
A description for this Performance-schema Table has not yet been added to this Documentation.
In 23.08 ES, 23.07 ES, 10.6 ES, 10.5 ES:
A description for this Performance-schema Table has not yet been added to this Documentation.
In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
In 10.4 ES:
Not present
USAGE
DETAILS
SYNONYMS
SCHEMA
CREATE TABLE `table_handles` (
`OBJECT_TYPE` varchar(64) NOT NULL COMMENT 'The table opened by a table handle.',
`OBJECT_SCHEMA` varchar(64) NOT NULL COMMENT 'The schema that contains the object.',
`OBJECT_NAME` varchar(64) NOT NULL COMMENT 'The name of the instrumented object.',
`OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL COMMENT 'The table handle address in memory.',
`OWNER_THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The thread owning the table handle.',
`OWNER_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The event which caused the table handle to be opened.',
`INTERNAL_LOCK` varchar(64) DEFAULT NULL COMMENT 'The table lock used at the SQL level.',
`EXTERNAL_LOCK` varchar(64) DEFAULT NULL COMMENT 'The table lock used at the storage engine level.'
)
PARAMETERS
SKYSQL
PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
Release Series | History |
---|---|
23.08 Enterprise |
|
23.07 Enterprise |
|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
---|---|
23.08 Enterprise |
|
23.07 Enterprise |
|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|