MySQL :: MySQL 8.4 参考手册 :: 29.12 Performance Schema Table Descriptions

8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

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

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

29.12 Performance Schema 表描述29.12 Performance Schema Table Descriptions

performance_schema 数据库中的表可分为如下几类：Tables in the performance_schema database can be grouped as follows:

设置表。这些表用于配置和显示监控特性。Setup tables. These tables are used to configure and display monitoring characteristics.
当前事件表。events_waits_current 表包含每个线程的最新事件。其他类似的表包含事件层次结构中不同级别的当前事件：events_stages_current 用于阶段事件，events_statements_current 用于语句事件，events_transactions_current 用于事务事件。Current events tables. The events_waits_current table contains the most recent event for each thread. Other similar tables contain current events at different levels of the event hierarchy: events_stages_current for stage events, events_statements_current for statement events, and events_transactions_current for transaction events.
历史表。这些表的结构与当前事件表相同，但包含更多行。例如，对于等待事件，events_waits_history 表包含每个线程最近的 10 个事件。events_waits_history_long 包含最近的 10,000 个事件。对于阶段、语句和事务历史，也存在其他类似的表。History tables. These tables have the same structure as the current events tables, but contain more rows. For example, for wait events, events_waits_history table contains the most recent 10 events per thread. events_waits_history_long contains the most recent 10,000 events. Other similar tables exist for stage, statement, and transaction histories.
要更改历史表的大小，请在服务器启动时设置适当的系统变量。例如，要设置等待事件历史表的大小，请设置 performance_schema_events_waits_history_size 和 performance_schema_events_waits_history_long_size。To change the sizes of the history tables, set the appropriate system variables at server startup. For example, to set the sizes of the wait event history tables, set performance_schema_events_waits_history_size and performance_schema_events_waits_history_long_size.
汇总表。这些表包含按事件组聚合的信息，包括已从历史表中丢弃的事件。Summary tables. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables.
实例表。这些表记录哪些类型的对象已被检测。被检测的对象在服务器使用时会生成事件。这些表提供事件名称以及说明性注释或状态信息。Instance tables. These tables document what types of objects are instrumented. An instrumented object, when used by the server, produces an event. These tables provide event names and explanatory notes or status information.
杂项表。这些不属于其他任何表组。Miscellaneous tables. These do not fall into any of the other table groups.

首页上一级下一节