prepared_statements_instances
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: Performance Schema
Topics on this page:
Overview
- In 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 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
See also: Performance Schema in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
SCHEMA
CREATE TABLE `prepared_statements_instances` (
`OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL,
`STATEMENT_ID` bigint(20) unsigned NOT NULL,
`STATEMENT_NAME` varchar(64) DEFAULT NULL,
`SQL_TEXT` longtext NOT NULL,
`OWNER_THREAD_ID` bigint(20) unsigned NOT NULL,
`OWNER_EVENT_ID` bigint(20) unsigned NOT NULL,
`OWNER_OBJECT_TYPE` enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER') DEFAULT NULL,
`OWNER_OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
`OWNER_OBJECT_NAME` varchar(64) DEFAULT NULL,
`TIMER_PREPARE` bigint(20) unsigned NOT NULL,
`COUNT_REPREPARE` bigint(20) unsigned NOT NULL,
`COUNT_EXECUTE` bigint(20) unsigned NOT NULL,
`SUM_TIMER_EXECUTE` bigint(20) unsigned NOT NULL,
`MIN_TIMER_EXECUTE` bigint(20) unsigned NOT NULL,
`AVG_TIMER_EXECUTE` bigint(20) unsigned NOT NULL,
`MAX_TIMER_EXECUTE` bigint(20) unsigned NOT NULL,
`SUM_LOCK_TIME` bigint(20) unsigned NOT NULL,
`SUM_ERRORS` bigint(20) unsigned NOT NULL,
`SUM_WARNINGS` bigint(20) unsigned NOT NULL,
`SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL,
`SUM_ROWS_SENT` bigint(20) unsigned NOT NULL,
`SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL,
`SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL,
`SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL,
`SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL,
`SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL,
`SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL,
`SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL,
`SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL,
`SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL,
`SUM_SORT_RANGE` bigint(20) unsigned NOT NULL,
`SUM_SORT_ROWS` bigint(20) unsigned NOT NULL,
`SUM_SORT_SCAN` bigint(20) unsigned NOT NULL,
`SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL,
`SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL
)
CHANGE HISTORY
Release Series | History |
|---|---|
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 |
|
EXTERNAL REFERENCES
Information specific to MariaDB SkySQL can be found on the prepared_statements_instances page in the SkySQL Documentation.