Performance Schema events_stages_history_long Table
events_stages_history_long table by default contains the ten thousand most recent completed stage events. This number can be adjusted by setting the performance_schema_events_stages_history_long_size system variable when the server starts up.
The table structure is identical to the
events_stage_current table structure, and contains the following columns:
|Thread associated with the event. Together with |
|Thread's current event number at the start of the event. Together with |
|Event instrument name and a NAME from the |
|Name and line number of the source file containing the instrumented code that produced the event.|
|Value in picoseconds when the event timing started or NULL if timing is not collected.|
|Value in picoseconds when the event timing ended, or NULL if timing is not collected.|
|Value in picoseconds of the event's duration or NULL if timing is not collected.|
|Nesting event type. One of |
It is possible to empty this table with a
TRUNCATE TABLE statement.