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
SPINS
int(10)
UNSIGNED
Yes
NULL
Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
10
OBJECT_SCHEMA
varchar(64)
utf8_general_ci
Yes
NULL
Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
11
OBJECT_NAME
varchar(512)
utf8_general_ci
Yes
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
INDEX_NAME
varchar(64)
utf8_general_ci
Yes
NULL
Name of the index, PRIMARY for the primary key, or NULL for no index used.
13
OBJECT_TYPE
varchar(64)
utf8_general_ci
Yes
NULL
FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
14
OBJECT_INSTANCE_BEGIN
bigint(20)
UNSIGNED
No
None
Address in memory of the object.
15
NESTING_EVENT_ID
bigint(20)
UNSIGNED
Yes
NULL
EVENT_ID of event within which this event nests.
16
NESTING_EVENT_TYPE
enum('STATEMENT', 'STAGE', 'WAIT')
utf8_general_ci
Yes
NULL
Nesting event type. Either statement, stage or wait.
17
OPERATION
varchar(32)
utf8_general_ci
No
None
Operation type, for example read, write or lock
18
NUMBER_OF_BYTES
bigint(20)
Yes
NULL
Number of bytes that the operation read or wrote, or NULL for table I/O waits.
19
FLAGS
int(10)
UNSIGNED
Yes
NULL
Reserved for use in the future.
