MySQL :: MySQL 8.4 参考手册 :: 29.12.20 Performance Schema Summary 表

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 29 MySQL Performance Schema / 29.12 Performance Schema Table Descriptions / 29.12.20 Performance Schema Summary 表

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 100%

29.12.20 Performance Schema 汇总表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.

可以使用 TRUNCATE TABLE 截断汇总表。通常，其效果是将汇总列重置为 0 或 NULL，而不是删除行。这使您能够清除收集的值并重新开始汇总。例如，在您进行运行时配置更改后，这可能会很有用。各个汇总表部分会注明这种截断行为的例外情况。Summary tables can be truncated with TRUNCATE TABLE. Generally, the effect is to reset the summary columns to 0 or NULL, 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

表 29.5 性能模式等待事件汇总表Table 29.5 Performance Schema Wait Event Summary Tables

表名Table Name	说明Description
`events_waits_summary_by_account_by_event_nameevents_waits_summary_by_account_by_event_name`	按账户和事件名称的等待事件Wait events per account and event name
`events_waits_summary_by_host_by_event_nameevents_waits_summary_by_host_by_event_name`	按主机名和事件名统计的等待事件Wait events per host name and event name
`events_waits_summary_by_instanceevents_waits_summary_by_instance`	按实例统计的等待事件Wait events per instance
`events_waits_summary_by_thread_by_event_nameevents_waits_summary_by_thread_by_event_name`	按线程和事件名统计的等待事件Wait events per thread and event name
`events_waits_summary_by_user_by_event_nameevents_waits_summary_by_user_by_event_name`	按用户名和事件名统计的等待事件Wait events per user name and event name
`events_waits_summary_global_by_event_nameevents_waits_summary_global_by_event_name`	按事件名统计的等待事件Wait events per event name

阶段汇总Stage Summaries

表 29.6 性能模式阶段事件汇总表Table 29.6 Performance Schema Stage Event Summary Tables

表名Table Name	说明Description
`events_stages_summary_by_account_by_event_nameevents_stages_summary_by_account_by_event_name`	按账户和事件名称的阶段事件Stage events per account and event name
`events_stages_summary_by_host_by_event_nameevents_stages_summary_by_host_by_event_name`	按主机名称和事件名称的阶段事件Stage events per host name and event name
`events_stages_summary_by_thread_by_event_nameevents_stages_summary_by_thread_by_event_name`	每个线程和事件名称的阶段等待Stage waits per thread and event name
`events_stages_summary_by_user_by_event_nameevents_stages_summary_by_user_by_event_name`	每个用户名和事件名称的阶段事件Stage events per user name and event name
`events_stages_summary_global_by_event_nameevents_stages_summary_global_by_event_name`	每个事件名称的阶段等待Stage waits per event name

语句汇总Statement Summaries

表 29.7 性能模式语句事件汇总表Table 29.7 Performance Schema Statement Event Summary Tables

表名Table Name	说明Description
`events_statements_histogram_by_digestevents_statements_histogram_by_digest`	每个模式和摘要值的语句直方图Statement histograms per schema and digest value
`events_statements_histogram_globalevents_statements_histogram_global`	全局汇总的语句直方图Statement histogram summarized globally
`events_statements_summary_by_account_by_event_nameevents_statements_summary_by_account_by_event_name`	每个账户和事件名称的语句事件Statement events per account and event name
`events_statements_summary_by_digestevents_statements_summary_by_digest`	每个模式和摘要值的语句事件Statement events per schema and digest value
`events_statements_summary_by_host_by_event_nameevents_statements_summary_by_host_by_event_name`	每个主机名和事件名称的语句事件Statement events per host name and event name
`events_statements_summary_by_programevents_statements_summary_by_program`	每个存储程序的语句事件Statement events per stored program
`events_statements_summary_by_thread_by_event_nameevents_statements_summary_by_thread_by_event_name`	每个线程和事件名称的语句事件Statement events per thread and event name
`events_statements_summary_by_user_by_event_nameevents_statements_summary_by_user_by_event_name`	每个用户名和事件名称的语句事件Statement events per user name and event name
`events_statements_summary_global_by_event_nameevents_statements_summary_global_by_event_name`	每个事件名称的语句事件Statement events per event name
`prepared_statements_instancesprepared_statements_instances`	预备语句实例和统计信息Prepared statement instances and statistics

事务汇总Transaction Summaries

表 29.8 性能模式事务事件汇总表Table 29.8 Performance Schema Transaction Event Summary Tables

表名Table Name	说明Description
`events_transactions_summary_by_account_by_event_nameevents_transactions_summary_by_account_by_event_name`	按账号和事件名称的事务事件Transaction events per account and event name
`events_transactions_summary_by_host_by_event_nameevents_transactions_summary_by_host_by_event_name`	按主机名和事件名的事务事件Transaction events per host name and event name
`events_transactions_summary_by_thread_by_event_nameevents_transactions_summary_by_thread_by_event_name`	按线程和事件名的事务事件Transaction events per thread and event name
`events_transactions_summary_by_user_by_event_nameevents_transactions_summary_by_user_by_event_name`	按用户名和事件名的事务事件Transaction events per user name and event name
`events_transactions_summary_global_by_event_nameevents_transactions_summary_global_by_event_name`	按事件名的事务事件Transaction events per event name

对象等待汇总Object Wait Summaries

表 29.9 性能模式对象事件摘要表Table 29.9 Performance Schema Object Event Summary Tables

表名Table Name	说明Description
`objects_summary_global_by_typeobjects_summary_global_by_type`	对象摘要Object summaries

文件 I/O 摘要File I/O Summaries

表 29.10 性能模式文件 I/O 事件摘要表Table 29.10 Performance Schema File I/O Event Summary Tables

表名Table Name	说明Description
`file_summary_by_event_namefile_summary_by_event_name`	按事件名统计的文件事件File events per event name
`file_summary_by_instancefile_summary_by_instance`	按文件实例统计的文件事件File events per file instance

表 I/O 和锁等待摘要Table I/O and Lock Wait Summaries

表 29.11 性能模式表 I/O 和锁等待事件摘要表Table 29.11 Performance Schema Table I/O and Lock Wait Event Summary Tables

表名Table Name	说明Description
`table_io_waits_summary_by_index_usagetable_io_waits_summary_by_index_usage`	按索引的表 I/O 等待Table I/O waits per index
`table_io_waits_summary_by_tabletable_io_waits_summary_by_table`	按表的表 I/O 等待Table I/O waits per table
`table_lock_waits_summary_by_tabletable_lock_waits_summary_by_table`	按表的表锁等待Table lock waits per table

套接字摘要Socket Summaries

表 29.12 性能模式套接字事件摘要表Table 29.12 Performance Schema Socket Event Summary Tables

表名Table Name	说明Description
`socket_summary_by_event_namesocket_summary_by_event_name`	每个事件名称的套接字等待和 I/OSocket waits and I/O per event name
`socket_summary_by_instancesocket_summary_by_instance`	每个实例的套接字等待和 I/OSocket waits and I/O per instance

内存摘要Memory Summaries

表 29.13 性能模式内存操作摘要表Table 29.13 Performance Schema Memory Operation Summary Tables

表名Table Name	说明Description
`memory_summary_by_account_by_event_namememory_summary_by_account_by_event_name`	按账户和事件名称的内存操作Memory operations per account and event name
`memory_summary_by_host_by_event_namememory_summary_by_host_by_event_name`	按主机和事件名称的内存操作Memory operations per host and event name
`memory_summary_by_thread_by_event_namememory_summary_by_thread_by_event_name`	按线程和事件名称的内存操作Memory operations per thread and event name
`memory_summary_by_user_by_event_namememory_summary_by_user_by_event_name`	每个用户和事件名称的内存操作Memory operations per user and event name
`memory_summary_global_by_event_namememory_summary_global_by_event_name`	按事件名称统计的全局内存操作Memory operations globally per event name

错误摘要Error Summaries

表 29.14 性能模式错误摘要表Table 29.14 Performance Schema Error Summary Tables

表名Table Name	说明Description
`events_errors_summary_by_account_by_errorevents_errors_summary_by_account_by_error`	每个账户和错误代码的错误Errors per account and error code
`events_errors_summary_by_host_by_errorevents_errors_summary_by_host_by_error`	每个主机和错误代码的错误Errors per host and error code
`events_errors_summary_by_thread_by_errorevents_errors_summary_by_thread_by_error`	每个线程和错误代码的错误Errors per thread and error code
`events_errors_summary_by_user_by_errorevents_errors_summary_by_user_by_error`	每个用户和错误代码的错误Errors per user and error code
`events_errors_summary_global_by_errorevents_errors_summary_global_by_error`	每个错误代码的错误Errors per error code

状态变量摘要Status Variable Summaries

表 29.15 性能模式错误状态变量摘要表Table 29.15 Performance Schema Error Status Variable Summary Tables

表名Table Name	说明Description
`status_by_accountstatus_by_account`	每个账户的会话状态变量Session status variables per account
`status_by_hoststatus_by_host`	每个主机名的会话状态变量Session status variables per host name
`status_by_userstatus_by_user`	每个用户名的会话状态变量Session status variables per user name

首页上一级下一节