content_image/810297.jpg
| events_stages_summary_by_account_by_event_name | | events_stages_summary_by_host_by_event_name | | events_stages_summary_by_user_by_event_name | | events_statements_summary_by_account_by_event_name | | events_statements_summary_by_host_by_event_name | | events_statements_summary_by_user_by_event_name | | events_transactions_summary_by_account_by_event_name | | events_transactions_summary_by_host_by_event_name | | events_transactions_summary_by_user_by_event_name | | events_waits_summary_by_account_by_event_name | | events_waits_summary_by_host_by_event_name | | events_waits_summary_by_user_by_event_name | | memory_summary_by_account_by_event_name | | memory_summary_by_host_by_event_name | | memory_summary_by_user_by_event_name | +------------------------------------------------------+ 

For details about individual connection summary tables, consult the section that describes tables for the summarized event type: 

•Wait event summaries: Section 27.12.20.1, “Wait Event Summary Tables” 

•Stage event summaries: Section 27.12.20.2, “Stage Summary Tables” 

•Statement event summaries: Section 27.12.20.3, “Statement Summary Tables” 

•Transaction event summaries: Section 27.12.20.5, “Transaction Summary Tables” 

•Memory event summaries: Section 27.12.20.10, “Memory Summary Tables” 

•Error event summaries: Section 27.12.20.11, “Error Summary Tables” 

TRUNCATE TABLE  is permitted for connection summary tables. It removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the connection table on which it depends. The following table describes the relationship between connection table truncation and implicitly truncated tables. 

<img src='content_image/810297.jpg'>

Truncating a _summary_global  summary table also implicitly truncates its corresponding connection and thread summary tables. For example, truncating events_waits_summary_global_by_event_name implicitly truncates the wait event summary tables that are aggregated by account, host, user, or thread. 

## 27.12.8.1 The accounts Table 

The accounts  table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. The table size is autosized at server 

