Column | Type | Null | Default | Comments |
---|---|---|---|---|
THREAD_ID | bigint(20) | No | ||
EVENT_ID | bigint(20) | No | ||
END_EVENT_ID | bigint(20) | Yes | NULL | |
EVENT_NAME | varchar(128) | No | ||
SOURCE | varchar(64) | Yes | NULL | |
TIMER_START | bigint(20) | Yes | NULL | |
TIMER_END | bigint(20) | Yes | NULL | |
TIMER_WAIT | bigint(20) | Yes | NULL | |
LOCK_TIME | bigint(20) | No | ||
SQL_TEXT | longtext | Yes | NULL | |
DIGEST | varchar(32) | Yes | NULL | |
DIGEST_TEXT | longtext | Yes | NULL | |
CURRENT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_TYPE | varchar(64) | Yes | NULL | |
OBJECT_SCHEMA | varchar(64) | Yes | NULL | |
OBJECT_NAME | varchar(64) | Yes | NULL | |
OBJECT_INSTANCE_BEGIN | bigint(20) | Yes | NULL | |
MYSQL_ERRNO | int(11) | Yes | NULL | |
RETURNED_SQLSTATE | varchar(5) | Yes | NULL | |
MESSAGE_TEXT | varchar(128) | Yes | NULL | |
ERRORS | bigint(20) | No | ||
WARNINGS | bigint(20) | No | ||
ROWS_AFFECTED | bigint(20) | No | ||
ROWS_SENT | bigint(20) | No | ||
ROWS_EXAMINED | bigint(20) | No | ||
CREATED_TMP_DISK_TABLES | bigint(20) | No | ||
CREATED_TMP_TABLES | bigint(20) | No | ||
SELECT_FULL_JOIN | bigint(20) | No | ||
SELECT_FULL_RANGE_JOIN | bigint(20) | No | ||
SELECT_RANGE | bigint(20) | No | ||
SELECT_RANGE_CHECK | bigint(20) | No | ||
SELECT_SCAN | bigint(20) | No | ||
SORT_MERGE_PASSES | bigint(20) | No | ||
SORT_RANGE | bigint(20) | No | ||
SORT_ROWS | bigint(20) | No | ||
SORT_SCAN | bigint(20) | No | ||
NO_INDEX_USED | bigint(20) | No | ||
NO_GOOD_INDEX_USED | bigint(20) | No | ||
NESTING_EVENT_ID | bigint(20) | Yes | NULL | |
NESTING_EVENT_TYPE | enum('STATEMENT', 'STAGE', 'WAIT') | Yes | NULL |