Performance Schema Wait Event Tables UPDATE performance_schema.setup_consumers SET ENABLED = ’YES’ WHERE NAME LIKE ’events_waits%’; UPDATE performance_schema.setup_instruments SET ENABLED = ’NO’, TIMED = ’NO’ WHERE NAME LIKE ’wait/%’; UPDATE performance_schema.setup_consumers SET ENABLED = ’NO’ WHERE NAME LIKE ’events_waits%’; To collect only specific wait events, enable only the corresponding wait instruments. To collect wait events only for specific wait event tables, enable the wait instruments but only the wait consumers corresponding to the desired tables. For additional information about configuring event collection, see Section 27.3, “Performance Schema Startup Configuration” , and Section 27.4, “Performance Schema Runtime Configuration” . The  events_waits_current  table contains current wait events. The table stores one row per thread showing the current status of the thread’s most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows,  events_waits_current  is the most fundamental. Other tables that contain wait event rows are logically derived from the current events. For example, the events_waits_history  and  events_waits_history_long  tables are collections of the most recent wait 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 wait event tables, see Section 27.9, “Performance Schema Tables for Current and Historical Events” . For information about configuring whether to collect wait events, see Section 27.12.4, “Performance Schema Wait Event Tables” . The  events_waits_current  table has these columns: The thread associated with the event and the thread current event number when the event starts. The THREAD_ID  and  EVENT_ID  values taken together uniquely identify the row. No two rows have the same pair of values. This column is set to  NULL  when the event starts and updated to the thread current event number when the event ends. The name of the instrument that produced the event. This is a  NAME  value from the setup_instruments  table. Instrument names may have multiple parts and form a hierarchy, as discussed in Section 27.6, “Performance Schema Instrument Naming Conventions” . 4960 • EVENT_NAME • END_EVENT_ID • THREAD_ID ,  EVENT_ID 27.12.4.1 The events_waits_current Table •Disable: