prepared_statements_instances

1024 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_INSTANCE_BEGIN BIGINT UNSIGNED 20 null
STATEMENT_ID BIGINT UNSIGNED 20 null
processlist.ID Implied ConstraintR
STATEMENT_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
SQL_TEXT LONGTEXT 2147483647 null
OWNER_THREAD_ID BIGINT UNSIGNED 20 null
OWNER_EVENT_ID BIGINT UNSIGNED 20 null
processlist.ID Implied ConstraintR
OWNER_OBJECT_TYPE enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER') 9 √ null
OWNER_OBJECT_SCHEMA VARCHAR 64 √ null
OWNER_OBJECT_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
TIMER_PREPARE BIGINT UNSIGNED 20 null
COUNT_REPREPARE BIGINT UNSIGNED 20 null
COUNT_EXECUTE BIGINT UNSIGNED 20 null
SUM_TIMER_EXECUTE BIGINT UNSIGNED 20 null
MIN_TIMER_EXECUTE BIGINT UNSIGNED 20 null
AVG_TIMER_EXECUTE BIGINT UNSIGNED 20 null
MAX_TIMER_EXECUTE BIGINT UNSIGNED 20 null
SUM_LOCK_TIME BIGINT UNSIGNED 20 null
SUM_ERRORS BIGINT UNSIGNED 20 null
SUM_WARNINGS BIGINT UNSIGNED 20 null
SUM_ROWS_AFFECTED BIGINT UNSIGNED 20 null
SUM_ROWS_SENT BIGINT UNSIGNED 20 null
SUM_ROWS_EXAMINED BIGINT UNSIGNED 20 null
SUM_CREATED_TMP_DISK_TABLES BIGINT UNSIGNED 20 null
SUM_CREATED_TMP_TABLES BIGINT UNSIGNED 20 null
SUM_SELECT_FULL_JOIN BIGINT UNSIGNED 20 null
SUM_SELECT_FULL_RANGE_JOIN BIGINT UNSIGNED 20 null
SUM_SELECT_RANGE BIGINT UNSIGNED 20 null
SUM_SELECT_RANGE_CHECK BIGINT UNSIGNED 20 null
SUM_SELECT_SCAN BIGINT UNSIGNED 20 null
SUM_SORT_MERGE_PASSES BIGINT UNSIGNED 20 null
SUM_SORT_RANGE BIGINT UNSIGNED 20 null
SUM_SORT_ROWS BIGINT UNSIGNED 20 null
SUM_SORT_SCAN BIGINT UNSIGNED 20 null
SUM_NO_INDEX_USED BIGINT UNSIGNED 20 null
SUM_NO_GOOD_INDEX_USED BIGINT UNSIGNED 20 null
SUM_CPU_TIME BIGINT UNSIGNED 20 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc OBJECT_INSTANCE_BEGIN
OWNER_OBJECT_TYPE Performance Asc/Asc/Asc OWNER_OBJECT_TYPE + OWNER_OBJECT_SCHEMA + OWNER_OBJECT_NAME
OWNER_THREAD_ID Must be unique Asc/Asc OWNER_THREAD_ID + OWNER_EVENT_ID
STATEMENT_ID Performance Asc STATEMENT_ID
STATEMENT_NAME Performance Asc STATEMENT_NAME

Relationships

Close relationships within degrees of separation