MySQL :: MySQL 8.4 参考手册 :: 29.14 Performance Schema Command Options

MySQL 8.4 参考手册 · 中文镜像

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

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

MySQL 8.4 参考手册 / 29 MySQL Performance Schema / 29.14 Performance Schema Command Options

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

29.14 性能模式命令选项29.14 Performance Schema Command Options

性能模式参数可以在服务器启动时通过命令行或选项文件来指定，以配置性能模式的仪表和消费者。在许多情况下，也可以进行运行时配置（参见第 29.4 节，“性能模式运行时配置”），但当运行时配置太晚无法影响在启动过程中已经初始化的仪表时，必须使用启动配置。Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers. Runtime configuration is also possible in many cases (see Section 29.4, “Performance Schema Runtime Configuration”), but startup configuration must be used when runtime configuration is too late to affect instruments that have already been initialized during the startup process.

Performance Schema 的消费者和工具可以在启动时使用以下语法进行配置。欲了解更多详细信息，请参阅第 29.3 节，“Performance Schema 启动配置”。Performance Schema consumers and instruments can be configured at startup using the following syntax. For additional details, see Section 29.3, “Performance Schema Startup Configuration”.

--performance-schema-consumer-consumer_name=value
配置 Performance Schema 消费者。setup_consumers 表中的消费者名称使用下划线，但对于在启动时设置的消费者，名称中的短横线和下划线是等效的。配置单个消费者的选项在本节后面详细说明。Configure a Performance Schema consumer. Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. Options for configuring individual consumers are detailed later in this section.
--performance-schema-instrument=instrument_name=value
配置 Performance Schema 仪表。名称可以作为模式给出，以配置与该模式匹配的仪表。Configure a Performance Schema instrument. The name may be given as a pattern to configure instruments that match the pattern.

以下项目用于配置单个消费者：The following items configure individual consumers:

--performance-schema-consumer-events-stages-current=value --performance-schema-consumer-events-stages-current=value
配置 events-stages-current 消费者。Configure the events-stages-current consumer.
--performance-schema-consumer-events-stages-history=value --performance-schema-consumer-events-stages-history=value
配置 events-stages-history 消费者。Configure the events-stages-history consumer.
--performance-schema-consumer-events-stages-history-long=value
配置 events-stages-history-long 消费者。Configure the events-stages-history-long consumer.
--performance-schema-consumer-events-statements-cpu=value
配置 events-statements-cpu 消费者。Configure the events-statements-cpu consumer.
--performance-schema-consumer-events-statements-current=value --performance-schema-consumer-events-statements-current=value
配置 events-statements-current 消费者。Configure the events-statements-current consumer.
--performance-schema-consumer-events-statements-history=value --performance-schema-consumer-events-statements-history=value
配置 events-statements-history 消费者。Configure the events-statements-history consumer.
--performance-schema-consumer-events-statements-history-long=value --performance-schema-consumer-events-statements-history-long=value
配置events-statements-history-long 消费者。Configure the events-statements-history-long consumer.
--performance-schema-consumer-events-transactions-current=value --performance-schema-consumer-events-transactions-current=value
配置 Performance Schema events-transactions-current 消费者。Configure the Performance Schema events-transactions-current consumer.
--performance-schema-consumer-events-transactions-history=value
配置 Performance Schema events-transactions-history 消费者。Configure the Performance Schema events-transactions-history consumer.
--performance-schema-consumer-events-transactions-history-long=value
配置 Performance Schema events-transactions-history-long 消费者。Configure the Performance Schema events-transactions-history-long consumer.
--performance-schema-consumer-events-waits-current=value --performance-schema-consumer-events-waits-current=value
配置 events-waits-current 消费者。Configure the events-waits-current consumer.
--performance-schema-consumer-events-waits-history=value --performance-schema-consumer-events-waits-history=value
配置 events-waits-history 消费者。Configure the events-waits-history consumer.
--performance-schema-consumer-events-waits-history-long=value --performance-schema-consumer-events-waits-history-long=value
配置 events-waits-history-long 消费者。Configure the events-waits-history-long consumer.
--performance-schema-consumer-global-instrumentation=value --performance-schema-consumer-global-instrumentation=value
配置 global-instrumentation 消费者。Configure the global-instrumentation consumer.
--performance-schema-consumer-statements-digest=value
配置 statements-digest 消费者。Configure the statements-digest consumer.
--performance-schema-consumer-thread-instrumentation=value
配置 thread-instrumentation 消费者。Configure the thread-instrumentation consumer.

首页上一级下一节