Documentation Home
MySQL 9.1 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


29.12.20 Performance Schema Summary Tables

Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways.

Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that summarize events in similar ways often have similar sets of summary columns and differ only in the grouping columns used to determine how events are aggregated.

Summary tables can be truncated withTRUNCATE TABLE. Generally, the effect is to reset the summary columns to 0 orNULL, not to remove rows. This enables you to clear collected values and restart aggregation. That might be useful, for example, after you have made a runtime configuration change. Exceptions to this truncation behavior are noted in individual summary table sections.

Wait Event Summaries

Table 29.5 Performance Schema Wait Event SummaryTables

Table NameDescription
events_waits_summary_by_account_by_event_nameWait events per account and event name
events_waits_summary_by_host_by_event_nameWait events per host name and event name
events_waits_summary_by_instanceWait events per instance
events_waits_summary_by_thread_by_event_nameWait events per thread and event name
events_waits_summary_by_user_by_event_nameWait events per user name and event name
events_waits_summary_global_by_event_nameWait events per event name

Stage Summaries

Table 29.6 Performance Schema Stage Event SummaryTables

Table NameDescription
events_stages_summary_by_account_by_event_nameStage events per account and event name
events_stages_summary_by_host_by_event_nameStage events per host name and event name
events_stages_summary_by_thread_by_event_nameStage waits per thread and event name
events_stages_summary_by_user_by_event_nameStage events per user name and event name
events_stages_summary_global_by_event_nameStage waits per event name

Statement Summaries

Table 29.7 Performance Schema Statement Event SummaryTables

Table NameDescription
events_statements_histogram_by_digestStatement histograms per schema and digest value
events_statements_histogram_globalStatement histogram summarized globally
events_statements_summary_by_account_by_event_nameStatement events per account and event name
events_statements_summary_by_digestStatement events per schema and digest value
events_statements_summary_by_host_by_event_nameStatement events per host name and event name
events_statements_summary_by_programStatement events per stored program
events_statements_summary_by_thread_by_event_nameStatement events per thread and event name
events_statements_summary_by_user_by_event_nameStatement events per user name and event name
events_statements_summary_global_by_event_nameStatement events per event name
prepared_statements_instancesPrepared statement instances and statistics

Transaction Summaries

Table 29.8 Performance Schema Transaction Event SummaryTables

Table NameDescription
events_transactions_summary_by_account_by_event_nameTransaction events per account and event name
events_transactions_summary_by_host_by_event_nameTransaction events per host name and event name
events_transactions_summary_by_thread_by_event_nameTransaction events per thread and event name
events_transactions_summary_by_user_by_event_nameTransaction events per user name and event name
events_transactions_summary_global_by_event_nameTransaction events per event name

Object Wait Summaries

Table 29.9 Performance Schema Object Event SummaryTables

Table NameDescription
objects_summary_global_by_typeObject summaries

File I/O Summaries

Table 29.10 Performance Schema File I/O Event SummaryTables

Table NameDescription
file_summary_by_event_nameFile events per event name
file_summary_by_instanceFile events per file instance

Table I/O and Lock Wait Summaries

Table 29.11 Performance Schema Table I/O and Lock Wait EventSummary Tables

Table NameDescription
table_io_waits_summary_by_index_usageTable I/O waits per index
table_io_waits_summary_by_tableTable I/O waits per table
table_lock_waits_summary_by_tableTable lock waits per table

Socket Summaries

Table 29.12 Performance Schema Socket Event SummaryTables

Table NameDescription
socket_summary_by_event_nameSocket waits and I/O per event name
socket_summary_by_instanceSocket waits and I/O per instance

Memory Summaries

Table 29.13 Performance Schema Memory Operation SummaryTables

Table NameDescription
memory_summary_by_account_by_event_nameMemory operations per account and event name
memory_summary_by_host_by_event_nameMemory operations per host and event name
memory_summary_by_thread_by_event_nameMemory operations per thread and event name
memory_summary_by_user_by_event_nameMemory operations per user and event name
memory_summary_global_by_event_nameMemory operations globally per event name

Error Summaries

Table 29.14 Performance Schema Error Summary Tables

Table NameDescription
events_errors_summary_by_account_by_errorErrors per account and error code
events_errors_summary_by_host_by_errorErrors per host and error code
events_errors_summary_by_thread_by_errorErrors per thread and error code
events_errors_summary_by_user_by_errorErrors per user and error code
events_errors_summary_global_by_errorErrors per error code

Status Variable Summaries

Table 29.15 Performance Schema Error Status Variable SummaryTables

Table NameDescription
status_by_accountSession status variables per account
status_by_hostSession status variables per host name
status_by_userSession status variables per user name