## Global and Thread Instrumentation Only 

• hosts 

• accounts 

• socket_summary_by_event_name 

• file_summary_by_instance 

• file_summary_by_event_name 

• objects_summary_global_by_type 

• memory_summary_global_by_event_name 

• table_lock_waits_summary_by_table 

• table_io_waits_summary_by_index_usage 

• table_io_waits_summary_by_table 

• events_waits_summary_by_instance 

• events_waits_summary_global_by_event_name 

• events_stages_summary_global_by_event_name 

• events_statements_summary_global_by_event_name 

• events_transactions_summary_global_by_event_name 

Server configuration state: 

mysql> SELECT * FROM performance_schema.setup_consumers; +----------------------------------+---------+ | NAME | ENABLED | +----------------------------------+---------+ | global_instrumentation | YES | | thread_instrumentation | YES | | events_waits_current | NO | ... | events_stages_current | NO | ... | events_statements_current | NO | ... | events_transactions_current | NO | ... +----------------------------------+---------+ 

In this configuration, instrumentation is maintained globally and per thread. No individual events are collected in the current-events or event-history tables. 

Additional setup elements checked, relative to the preceding configuration: 

•Table setup_consumers , consumers events_ xxx _current , where xxx  is waits , stages , statements , transactions 

•Table setup_actors 

•Column threads.instrumented 

Additional output tables maintained, relative to the preceding configuration: 

