1
THREAD_ID
bigint(20)
UNSIGNED
No
None
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
2
EVENT_ID
bigint(20)
UNSIGNED
No
None
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
3
END_EVENT_ID
bigint(20)
UNSIGNED
Yes
NULL
NULL when the event starts, set to the thread's current event number at the end of the event.
4
EVENT_NAME
varchar(128)
utf8_general_ci
No
None
Event instrument name and a NAME from the setup_instruments table
5
SOURCE
varchar(64)
utf8_general_ci
Yes
NULL
Name and line number of the source file containing the instrumented code that produced the event.
6
TIMER_START
bigint(20)
UNSIGNED
Yes
NULL
Value in picoseconds when the event timing started or NULL if timing is not collected.
7
TIMER_END
bigint(20)
UNSIGNED
Yes
NULL
Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
8
TIMER_WAIT
bigint(20)
UNSIGNED
Yes
NULL
Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
9
LOCK_TIME
bigint(20)
UNSIGNED
No
None
Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
10
SQL_TEXT
longtext
utf8_general_ci
Yes
NULL
The SQL statement, or NULL if the command is not associated with an SQL statement.
11
DIGEST
varchar(32)
utf8_general_ci
Yes
NULL
Statement digest.
12
DIGEST_TEXT
longtext
utf8_general_ci
Yes
NULL
Statement digest text.
13
CURRENT_SCHEMA
varchar(64)
utf8_general_ci
Yes
NULL
Statement's default database for the statement, or NULL if there was none.
14
OBJECT_TYPE
varchar(64)
utf8_general_ci
Yes
NULL
Reserved, currently NULL
15
OBJECT_SCHEMA
varchar(64)
utf8_general_ci
Yes
NULL
Reserved, currently NULL
16
OBJECT_NAME
varchar(64)
utf8_general_ci
Yes
NULL
Reserved, currently NULL
17
OBJECT_INSTANCE_BEGIN
bigint(20)
UNSIGNED
Yes
NULL
Address in memory of the statement object.
18
MYSQL_ERRNO
int(11)
Yes
NULL
Error code. See MariaDB Error Codes for a full list.
19
RETURNED_SQLSTATE
varchar(5)
utf8_general_ci
Yes
NULL
The SQLSTATE value.
20
MESSAGE_TEXT
varchar(128)
utf8_general_ci
Yes
NULL
Statement error message. See MariaDB Error Codes.
21
ERRORS
bigint(20)
UNSIGNED
No
None
0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
22
WARNINGS
bigint(20)
UNSIGNED
No
None
Number of warnings from the diagnostics area.
23
ROWS_AFFECTED
bigint(20)
UNSIGNED
No
None
Number of rows affected the statement affected.
24
ROWS_SENT
bigint(20)
UNSIGNED
No
None
Number of rows returned.
25
ROWS_EXAMINED
bigint(20)
UNSIGNED
No
None
Number of rows read during the statement's execution.
26
CREATED_TMP_DISK_TABLES
bigint(20)
UNSIGNED
No
None
Number of on-disk temp tables created by the statement.
27
CREATED_TMP_TABLES
bigint(20)
UNSIGNED
No
None
Number of temp tables created by the statement.
28
SELECT_FULL_JOIN
bigint(20)
UNSIGNED
No
None
Number of joins performed by the statement which did not use an index.
29
SELECT_FULL_RANGE_JOIN
bigint(20)
UNSIGNED
No
None
Number of joins performed by the statement which used a range search of the first table.
30
SELECT_RANGE
bigint(20)
UNSIGNED
No
None
Number of joins performed by the statement which used a range of the first table.
31
SELECT_RANGE_CHECK
bigint(20)
UNSIGNED
No
None
Number of joins without keys performed by the statement that check for key usage after each row.
32
SELECT_SCAN
bigint(20)
UNSIGNED
No
None
Number of joins performed by the statement which used a full scan of the first table.
33
SORT_MERGE_PASSES
bigint(20)
UNSIGNED
No
None
Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the sort_buffer_size.
34
SORT_RANGE
bigint(20)
UNSIGNED
No
None
Number of sorts performed by the statement which used a range.
35
SORT_ROWS
bigint(20)
UNSIGNED
No
None
Number of rows sorted by the statement.
36
SORT_SCAN
bigint(20)
UNSIGNED
No
None
Number of sorts performed by the statement which used a full table scan.
37
NO_INDEX_USED
bigint(20)
UNSIGNED
No
None
0 if the statement performed a table scan with an index, 1 if without an index.
38
NO_GOOD_INDEX_USED
bigint(20)
UNSIGNED
No
None
0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the EXPLAIN article.
39
NESTING_EVENT_ID
bigint(20)
UNSIGNED
Yes
NULL
Reserved, currently NULL.
40
NESTING_EVENT_TYPE
enum('STATEMENT', 'STAGE', 'WAIT')
utf8_general_ci
Yes
NULL
Reserved, currently NULL.