|
|
1 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
|
|
|
|
2 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
|
|
|
|
3 |
|
bigint(20)
|
|
UNSIGNED |
Ja |
NULL
|
NULL when the event starts, set to the thread's current event number at the end of the event.
|
|
|
|
4 |
|
varchar(128)
|
utf8_general_ci
|
|
Nein |
kein(e)
|
Event instrument name and a NAME from the setup_instruments table
|
|
|
|
5 |
|
varchar(64)
|
utf8_general_ci
|
|
Ja |
NULL
|
Name and line number of the source file containing the instrumented code that produced the event.
|
|
|
|
6 |
|
bigint(20)
|
|
UNSIGNED |
Ja |
NULL
|
Value in picoseconds when the event timing started or NULL if timing is not collected.
|
|
|
|
7 |
|
bigint(20)
|
|
UNSIGNED |
Ja |
NULL
|
Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
|
|
|
|
8 |
|
bigint(20)
|
|
UNSIGNED |
Ja |
NULL
|
Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
|
|
|
|
9 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
|
|
|
|
10 |
|
longtext
|
utf8_general_ci
|
|
Ja |
NULL
|
The SQL statement, or NULL if the command is not associated with an SQL statement.
|
|
|
|
11 |
|
varchar(32)
|
utf8_general_ci
|
|
Ja |
NULL
|
Statement digest.
|
|
|
|
12 |
|
longtext
|
utf8_general_ci
|
|
Ja |
NULL
|
Statement digest text.
|
|
|
|
13 |
|
varchar(64)
|
utf8_general_ci
|
|
Ja |
NULL
|
Statement's default database for the statement, or NULL if there was none.
|
|
|
|
14 |
|
varchar(64)
|
utf8_general_ci
|
|
Ja |
NULL
|
Reserved, currently NULL
|
|
|
|
15 |
|
varchar(64)
|
utf8_general_ci
|
|
Ja |
NULL
|
Reserved, currently NULL
|
|
|
|
16 |
|
varchar(64)
|
utf8_general_ci
|
|
Ja |
NULL
|
Reserved, currently NULL
|
|
|
|
17 |
|
bigint(20)
|
|
UNSIGNED |
Ja |
NULL
|
Address in memory of the statement object.
|
|
|
|
18 |
|
int(11)
|
|
|
Ja |
NULL
|
Error code. See MariaDB Error Codes for a full list.
|
|
|
|
19 |
|
varchar(5)
|
utf8_general_ci
|
|
Ja |
NULL
|
The SQLSTATE value.
|
|
|
|
20 |
|
varchar(128)
|
utf8_general_ci
|
|
Ja |
NULL
|
Statement error message. See MariaDB Error Codes.
|
|
|
|
21 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
|
|
|
|
22 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of warnings from the diagnostics area.
|
|
|
|
23 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of rows affected the statement affected.
|
|
|
|
24 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of rows returned.
|
|
|
|
25 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of rows read during the statement's execution.
|
|
|
|
26 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of on-disk temp tables created by the statement.
|
|
|
|
27 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of temp tables created by the statement.
|
|
|
|
28 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of joins performed by the statement which did not use an index.
|
|
|
|
29 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of joins performed by the statement which used a range search of the first table.
|
|
|
|
30 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of joins performed by the statement which used a range of the first table.
|
|
|
|
31 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of joins without keys performed by the statement that check for key usage after each row.
|
|
|
|
32 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of joins performed by the statement which used a full scan of the first table.
|
|
|
|
33 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
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 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of sorts performed by the statement which used a range.
|
|
|
|
35 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of rows sorted by the statement.
|
|
|
|
36 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
Number of sorts performed by the statement which used a full table scan.
|
|
|
|
37 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
0 if the statement performed a table scan with an index, 1 if without an index.
|
|
|
|
38 |
|
bigint(20)
|
|
UNSIGNED |
Nein |
kein(e)
|
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 |
|
bigint(20)
|
|
UNSIGNED |
Ja |
NULL
|
Reserved, currently NULL.
|
|
|
|
40 |
|
enum('STATEMENT', 'STAGE', 'WAIT')
|
utf8_general_ci
|
|
Ja |
NULL
|
Reserved, currently NULL.
|
|
