Performance Schema events_stages_history Table
MariaDB starting with 10.0
events_stages_history table by default contains the ten most recent completed stage events per thread. This number can be adjusted by setting the performance_schema_events_stages_history_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 and line number of the source file containing the instrumented code that produced the event.|
|Value in picoseconds when the event timing started or |
|Value in picoseconds when the event timing ended, or |
|Value in picoseconds of the event's duration or |
|Nesting event type. Either |
It is possible to empty this table with a
TRUNCATE TABLE statement.