events_statements_current

2560 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
THREAD_ID BIGINT UNSIGNED 20 null
EVENT_ID BIGINT UNSIGNED 20 null
END_EVENT_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
EVENT_NAME VARCHAR 128 null
SOURCE VARCHAR 64 √ null
TIMER_START BIGINT UNSIGNED 20 √ null
TIMER_END BIGINT UNSIGNED 20 √ null
TIMER_WAIT BIGINT UNSIGNED 20 √ null
LOCK_TIME BIGINT UNSIGNED 20 null
SQL_TEXT LONGTEXT 2147483647 √ null
DIGEST VARCHAR 64 √ null
DIGEST_TEXT LONGTEXT 2147483647 √ null
CURRENT_SCHEMA VARCHAR 64 √ null
OBJECT_TYPE VARCHAR 64 √ null
OBJECT_SCHEMA VARCHAR 64 √ null
OBJECT_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
OBJECT_INSTANCE_BEGIN BIGINT UNSIGNED 20 √ null
MYSQL_ERRNO INT 10 √ null
RETURNED_SQLSTATE VARCHAR 5 √ null
MESSAGE_TEXT VARCHAR 128 √ null
ERRORS BIGINT UNSIGNED 20 null
WARNINGS BIGINT UNSIGNED 20 null
ROWS_AFFECTED BIGINT UNSIGNED 20 null
ROWS_SENT BIGINT UNSIGNED 20 null
ROWS_EXAMINED BIGINT UNSIGNED 20 null
CREATED_TMP_DISK_TABLES BIGINT UNSIGNED 20 null
CREATED_TMP_TABLES BIGINT UNSIGNED 20 null
SELECT_FULL_JOIN BIGINT UNSIGNED 20 null
SELECT_FULL_RANGE_JOIN BIGINT UNSIGNED 20 null
SELECT_RANGE BIGINT UNSIGNED 20 null
SELECT_RANGE_CHECK BIGINT UNSIGNED 20 null
SELECT_SCAN BIGINT UNSIGNED 20 null
SORT_MERGE_PASSES BIGINT UNSIGNED 20 null
SORT_RANGE BIGINT UNSIGNED 20 null
SORT_ROWS BIGINT UNSIGNED 20 null
SORT_SCAN BIGINT UNSIGNED 20 null
NO_INDEX_USED BIGINT UNSIGNED 20 null
NO_GOOD_INDEX_USED BIGINT UNSIGNED 20 null
NESTING_EVENT_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') 11 √ null
NESTING_EVENT_LEVEL INT 10 √ null
STATEMENT_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
CPU_TIME BIGINT UNSIGNED 20 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc THREAD_ID + EVENT_ID

Relationships

Close relationships within degrees of separation