21.9.1.2. The setup_consumers Table

The setup_consumers table lists the types of consumers for which event information can be stored and which are enabled:

mysql> SELECT * FROM setup_consumers;+--------------------------------+---------+| NAME                           | ENABLED |+--------------------------------+---------+| events_stages_current          | NO      || events_stages_history          | NO      || events_stages_history_long     | NO      || events_statements_current      | YES     || events_statements_history      | NO      || events_statements_history_long | NO      || events_waits_current           | NO      || events_waits_history           | NO      || events_waits_history_long      | NO      || global_instrumentation         | YES     || thread_instrumentation         | YES     |+--------------------------------+---------+

The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. For detailed information about the effect of enabling different consumers, see Section 21.2.3.2.1.4, "Pre-Filtering by Consumer".

The setup_consumers table has these columns:

Modifications to the setup_consumers table affect monitoring immediately.