8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

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

35.4.2 服务器计量35.4.2 Server Meters

组,称为 Meters。The server metrics are organised in groups, called Meters.

mysql> select * from performance_schema.setup_meters;
+------------------------+-----------+---------+-------------------------------------------+
| NAME                   | FREQUENCY | ENABLED | DESCRIPTION                               |
+------------------------+-----------+---------+-------------------------------------------+
| mysql.inno             |        10 | YES     | MySql InnoDB metrics                      |
| mysql.inno.buffer_pool |        10 | YES     | MySql InnoDB buffer pool metrics          |
| mysql.inno.data        |        10 | YES     | MySql InnoDB data metrics                 |
| mysql.x                |        10 | YES     | MySql X plugin metrics                    |
| mysql.x.stmt           |        10 | YES     | MySql X plugin statement statistics       |
| mysql.stats            |        10 | YES     | MySql core metrics                        |
| mysql.stats.com        |        10 | YES     | MySql command stats                       |
| mysql.stats.connection |        10 | YES     | MySql connection stats                    |
| mysql.stats.handler    |        10 | YES     | MySql handler stats                       |
| mysql.stats.ssl        |        10 | YES     | MySql TLS related stats                   |
| mysql.myisam           |        10 | YES     | MySql MyISAM storage engine stats         |
| mysql.perf_schema      |        10 | YES     | MySql performance_schema lost instruments |
+------------------------+-----------+---------+-------------------------------------------+
        

FREQUENCY 和 ENABLED可以编辑。例如,要更新 mysql.inno 指标的频率:FREQUENCY and ENABLED can be edited. For example, to update the frequency of the mysql.inno metrics:

       mysql>update performance_schema.setup_meters set FREQUENCY='30' where name = 'mysql.inno';
      

可以创建的仪表仪器的最大数量由performance_schema_max_meter_classes 设置。The maximum number of meter instruments which can be created is set by performance_schema_max_meter_classes.

仪表还可以通过命令行、服务器启动时或从配置文件进行配置。Meters can also be configured from the commandline, on server startup, or from a configuration file.

要启用或禁用仪表,或更改仪表频率,请使用以下命令行参数语法:To enable, or disable, a meter, or alter the meter frequency, use the following commandline parameter syntax:

        --performance-schema-meter='meterName=frequency:integer,enabled:ON|OFF'
      

下面的示例启用了mysql.inno仪表,并将频率设置为 50:The following example enables the mysql.inno meter and sets the frequency to 50:

        --performance-schema-meter='mysql.inno=frequency:50,enabled:ON'