Movatterモバイル変換

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

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

The consumer settings in thesetup_consumers table form a hierarchy from higher levels to lower. For detailed information about the effect of enabling different consumers, seeSection 29.4.7, “Pre-Filtering by Consumer”.

Modifications to thesetup_consumers table affect monitoring immediately.

Thesetup_consumers table has these columns:

Thesetup_consumers table has these indexes:

TRUNCATE TABLE is not permitted for thesetup_consumers table.