MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide

22.12.6.1 The events_statements_current Table

The events_statements_current table contains current statement events. The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size.

Of the tables that contain statement event rows, events_statements_current is the most fundamental. Other tables that contain statement event rows are logically derived from the current events. For example, the events_statements_history and events_statements_history_long tables are collections of the most recent statement events that have ended, up to a maximum number of rows per thread and globally across all threads, respectively.

For more information about the relationship between the three events_statements_xxx event tables, see Section 22.9, “Performance Schema Tables for Current and Historical Events”.

For information about configuring whether to collect statement events, see Section 22.12.6, “Performance Schema Statement Event Tables”.

The events_statements_current table has these columns:

TRUNCATE TABLE is permitted for the events_statements_current table. It removes the rows.