|
|
1 |
|
bigint(20)
|
|
UNSIGNED |
否 |
無 |
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
|
|
|
|
2 |
|
bigint(20)
|
|
UNSIGNED |
否 |
無 |
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
|
|
|
|
3 |
|
bigint(20)
|
|
UNSIGNED |
是 |
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
|
|
否 |
無 |
Event instrument name and a NAME from the setup_instruments table
|
|
|
|
5 |
|
varchar(64)
|
utf8_general_ci
|
|
是 |
NULL |
Name and line number of the source file containing the instrumented code that produced the event.
|
|
|
|
6 |
|
bigint(20)
|
|
UNSIGNED |
是 |
NULL |
Value in picoseconds when the event timing started or NULL if timing is not collected.
|
|
|
|
7 |
|
bigint(20)
|
|
UNSIGNED |
是 |
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 |
是 |
NULL |
Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
|
|
|
|
9 |
|
int(10)
|
|
UNSIGNED |
是 |
NULL |
Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
|
|
|
|
10 |
|
varchar(64)
|
utf8_general_ci
|
|
是 |
NULL |
Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
|
|
|
|
11 |
|
varchar(512)
|
utf8_general_ci
|
|
是 |
NULL |
File name for file I/O objects, table name for table I/O objects, the socket's IP:PORT value for a socket object or NULL for a synchronization object.
|
|
|
|
12 |
|
varchar(64)
|
utf8_general_ci
|
|
是 |
NULL |
Name of the index, PRIMARY for the primary key, or NULL for no index used.
|
|
|
|
13 |
|
varchar(64)
|
utf8_general_ci
|
|
是 |
NULL |
FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
|
|
|
|
14 |
|
bigint(20)
|
|
UNSIGNED |
否 |
無 |
Address in memory of the object.
|
|
|
|
15 |
|
bigint(20)
|
|
UNSIGNED |
是 |
NULL |
EVENT_ID of event within which this event nests.
|
|
|
|
16 |
|
enum('STATEMENT', 'STAGE', 'WAIT')
|
utf8_general_ci
|
|
是 |
NULL |
Nesting event type. Either statement, stage or wait.
|
|
|
|
17 |
|
varchar(32)
|
utf8_general_ci
|
|
否 |
無 |
Operation type, for example read, write or lock
|
|
|
|
18 |
|
bigint(20)
|
|
|
是 |
NULL |
Number of bytes that the operation read or wrote, or NULL for table I/O waits.
|
|
|
|
19 |
|
int(10)
|
|
UNSIGNED |
是 |
NULL |
Reserved for use in the future.
|
|
