The setup_consumers table lists
the types of consumers for which event information can be
stored:
mysql> SELECT * FROM setup_consumers;
+----------------------------------------------+---------+
| NAME | ENABLED |
+----------------------------------------------+---------+
| events_waits_current | YES |
| events_waits_history | YES |
| events_waits_history_long | YES |
| events_waits_summary_by_thread_by_event_name | YES |
| events_waits_summary_by_event_name | YES |
| events_waits_summary_by_instance | YES |
| file_summary_by_event_name | YES |
| file_summary_by_instance | YES |
+----------------------------------------------+---------+
The setup_consumers table has
these columns:
NAME
The consumer name.
ENABLED
Whether the consumer is enabled. This column can be modified. If you disable a consumer, the server does not spend time adding event information to it.
Disabling the events_waits_current consumer
disables everything else that depends on waits, such as the
events_waits_history and
events_waits_history_long tables,
and all summary tables.

User Comments
Add your own comment.