How does one use NESTING_EVENT_ID?
Below I’ve selected from events_waits_history_long for a
single thread, but none of the NESTING_EVENT_ID values show
up in EVENT_ID or END_EVENT_ID.
To simplify things , I’m just showing the data for one THREAD_ID
listed in order of TIMER_START.
mysql> select
THREAD_ID,
EVENT_ID,
END_EVENT_ID,
NESTING_EVENT_ID,
NESTING_EVENT_TYPE,
EVENT_NAME,
SOURCE,
TIMER_WAIT,
SPINS,
OBJECT_SCHEMA,
OBJECT_NAME,
INDEX_NAME,
OBJECT_TYPE,
OBJECT_TYPE,
OBJECT_INSTANCE_BEGIN,
OPERATION,
NUMBER_OF_BYTES,
FLAGS
from
performance_schema.events_waits_history_long
where
THREAD_ID in ( select max(thread_id) from performance_schema.events_waits_history_long where …
[Read more]