MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
The following table lists each Performance Schema table and provides a short description of each one.
Table 22.1 Performance Schema Tables
Table Name | Description |
---|---|
accounts |
Connection statistics per client account |
cond_instances |
synchronization object instances |
events_stages_current |
Current stage events |
events_stages_history |
Most recent stage events per thread |
events_stages_history_long |
Most recent stage events overall |
events_stages_summary_by_account_by_event_name |
Stage events per account and event name |
events_stages_summary_by_host_by_event_name |
Stage events per host name and event name |
events_stages_summary_by_thread_by_event_name |
Stage waits per thread and event name |
events_stages_summary_by_user_by_event_name |
Stage events per user name and event name |
events_stages_summary_global_by_event_name |
Stage waits per event name |
events_statements_current |
Current statement events |
events_statements_history |
Most recent statement events per thread |
events_statements_history_long |
Most recent statement events overall |
events_statements_summary_by_account_by_event_name |
Statement events per account and event name |
events_statements_summary_by_digest |
Statement events per schema and digest value |
events_statements_summary_by_host_by_event_name |
Statement events per host name and event name |
events_statements_summary_by_thread_by_event_name |
Statement events per thread and event name |
events_statements_summary_by_user_by_event_name |
Statement events per user name and event name |
events_statements_summary_global_by_event_name |
Statement events per event name |
events_waits_current |
Current wait events |
events_waits_history |
Most recent wait events per thread |
events_waits_history_long |
Most recent wait events overall |
events_waits_summary_by_account_by_event_name |
Wait events per account and event name |
events_waits_summary_by_host_by_event_name |
Wait events per host name and event name |
events_waits_summary_by_instance |
Wait events per instance |
events_waits_summary_by_thread_by_event_name |
Wait events per thread and event name |
events_waits_summary_by_user_by_event_name |
Wait events per user name and event name |
events_waits_summary_global_by_event_name |
Wait events per event name |
file_instances |
File instances |
file_summary_by_event_name |
File events per event name |
file_summary_by_instance |
File events per file instance |
host_cache |
Information from the internal host cache |
hosts |
Connection statistics per client host name |
mutex_instances |
Mutex synchronization object instances |
objects_summary_global_by_type |
Object summaries |
performance_timers |
Which event timers are available |
rwlock_instances |
Lock synchronization object instances |
session_account_connect_attrs |
Connection attributes per for the current session |
session_connect_attrs |
Connection attributes for all sessions |
setup_actors |
How to initialize monitoring for new foreground threads |
setup_consumers |
Consumers for which event information can be stored |
setup_instruments |
Classes of instrumented objects for which events can be collected |
setup_objects |
Which objects should be monitored |
setup_timers |
Current event timer |
socket_instances |
Active connection instances |
socket_summary_by_event_name |
Socket waits and I/O per event name |
socket_summary_by_instance |
Socket waits and I/O per instance |
table_io_waits_summary_by_index_usage |
Table I/O waits per index |
table_io_waits_summary_by_table |
Table I/O waits per table |
table_lock_waits_summary_by_table |
Table lock waits per table |
threads |
Information about server threads |
users |
Connection statistics per client user name |