MySQL :: MySQL 8.4 参考手册 :: 35.4.3 Server Metrics

8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

MySQL 8.4 参考手册 / 35 Telemetry / 35.4 OpenTelemetry Metrics / 35.4.3 Server Metrics

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

35.4.3 服务器指标35.4.3 Server Metrics

以下服务器指标是默认注册的：The following server metrics are registered by default:

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

mysql.stats 指标mysql.stats Metrics

表 35.3 mysql.stats 指标Table 35.3 mysql.stats Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`aborted_clients`	`Aborted_clients`	`ASYNC COUNTERASYNC COUNTER`	由于客户端在未正确关闭连接的情况下退出而中止的连接数The number of connections that were aborted because the client died without closing the connection properly
`aborted_connects`	`Aborted_connects`	`ASYNC COUNTERASYNC COUNTER`	连接到 MySQL 服务器失败的尝试次数The number of failed attempts to connect to the MySQL server
`acl_cache_items_count`	`Acl_cache_items_count`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	缓存的权限对象数量The number of cached privilege objects
`binlog_cache.disk_use`	`Binlog_cache_disk_use`	`ASYNC COUNTERASYNC COUNTER`	使用临时二进制日志缓存但超过 binlog_cache_size 值并使用临时文件存储事务中语句的事务数量The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction
`binlog_cache.use`	`Binlog_cache_use`	`ASYNC COUNTERASYNC COUNTER`	使用二进制日志缓存的事务数量。The number of transactions that used the binary log cache.
`binlog_stmt_cache_disk_use`	`Binlog_stmt_cache_disk_use`	`ASYNC COUNTERASYNC COUNTER`	使用二进制日志语句缓存但超过 binlog_stmt_cache_size 值并使用临时文件存储这些语句的非事务性语句数量。The number of nontransaction statements that used the binary log statement cache but that exceeded the value of binlog_stmt_cache_size and used a temporary file to store those statements.
`binlog_stmt_cache_use`	`Binlog_stmt_cache_use`	`ASYNC COUNTERASYNC COUNTER`	使用二进制日志语句缓存的非事务语句数量The number of nontransactional statements that used the binary log statement cache
`bytes_received`	`Bytes_received`	`ASYNC COUNTERASYNC COUNTER`	从所有客户端接收的字节数The number of bytes received from all clients
`bytes_sent`	`Bytes_sent`	`ASYNC COUNTERASYNC COUNTER`	发送到所有客户端的字节数The number of bytes sent to all clients
`created.tmp_disk_tables`	`Created_tmp_disk_tables`	`ASYNC COUNTERASYNC COUNTER`	服务器在执行语句时创建的内部磁盘临时表的数量The number of internal on-disk temporary tables created by the server while executing statements
`created.tmp_files`	`Created_tmp_files`	`ASYNC COUNTERASYNC COUNTER`	mysqld 创建的临时文件数量How many temporary files mysqld has created
`created.tmp_tables`	`Created_tmp_tables`	`ASYNC COUNTERASYNC COUNTER`	服务器在执行语句时创建的内部临时表的数量The number of internal temporary tables created by the server while executing statements
`error_log.buffered_bytes`	`Error_log_buffered_bytes`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前在性能模式 error_log 表中使用的字节数The number of bytes currently used in the Performance Schema error_log table
`error_log.buffered_events`	`Error_log_buffered_events`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前存在于性能模式（Performance Schema）error_log 表中的事件数量The number of events currently present in the Performance Schema error_log table
`error_log.expired_events`	`Error_log_expired_events`	`ASYNC COUNTERASYNC COUNTER`	为给新事件腾出空间而从性能模式（Performance Schema）error_log 表中丢弃的事件数量The number of events discarded from the Performance Schema error_log table to make room for new events
`flush_commands`	`Flush_commands`	`ASYNC COUNTERASYNC COUNTER`	服务器刷新表的次数The number of times the server flushes tables
`global_connection_memory`	`Global_connection_memory`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	所有用户连接到服务器所使用的内存The memory used by all user connections to the server
`locked_connects`	`Locked_connects`	`ASYNC COUNTERASYNC COUNTER`	尝试连接被锁定用户账户的次数The number of attempts to connect to locked user accounts
`max_execution_time_exceeded`	`Max_execution_time_exceeded`	`ASYNC COUNTERASYNC COUNTER`	SELECT 语句执行超时的次数The number of SELECT statements for which the execution timeout was exceeded
`max_execution_time_set`	`Max_execution_time_set`	`ASYNC COUNTERASYNC COUNTER`	设置了非零执行超时的 SELECT 语句的数量The number of SELECT statements for which a nonzero execution timeout was set
`max_execution_time_set_failed`	`Max_execution_time_set_failed`	`ASYNC COUNTERASYNC COUNTER`	尝试设置执行超时失败的 `SELECT` 语句的数量The number of `SELECT` statements for which the attempt to set an execution timeout failed
`max_used_connections`	`Max_used_connections`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	自服务器启动以来同时使用过的最大连接数The maximum number of connections that have been in use simultaneously since the server started
`ongoing_anonymous_transaction_count`	`Ongoing_anonymous_transaction_count`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	显示已标记为匿名的正在进行的事务数量Shows the number of ongoing transactions which have been marked as anonymous
`open_files`	`Open_files`	`ASYNC COUNTERASYNC COUNTER`	已打开的文件数量。此计数包括服务器打开的普通文件。The number of files that are open. This count includes regular files opened by the server.
`open_streams`	`Open_streams`	`ASYNC COUNTERASYNC COUNTER`	已打开的流的数量，主要用于日志记录The number of streams that are open, used mainly for logging
`open_table_definitions`	`Open_table_definitions`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	缓存的表定义数量The number of cached table definitions
`open_tables`	`Open_tables`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	开放的桌子数量。The number of tables that are open.
`opened_files`	`Opened_files`	`ASYNC COUNTERASYNC COUNTER`	通过 `my_open()` 打开的文件数量。The number of files that have been opened with `my_open()`.
`opened_table_definitions`	`Opened_table_definitions`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	已缓存的表定义数量。The number of table definitions that have been cached.
`opened_tables`	`Opened_tablesOpened_tables`	`ASYNC COUNTERASYNC COUNTER`	已打开的表格数量The number of tables that have been opened
`prepared_stmt_count`	`Prepared_stmt_count`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前准备语句的数量The current number of prepared statements
`queries`	`Queries`	`ASYNC COUNTERASYNC COUNTER`	服务器执行的语句数量，包括在存储程序中执行的语句。不计入 `COM_PING` 或 `COM_STATISTICS` 命令。The number of statements executed by the server, including ones executed within stored programs. It does not count `COM_PING` or `COM_STATISTICS` commands.
`questions`	`Questions`	`ASYNC COUNTERASYNC COUNTER`	服务器执行的语句数量。这仅包括客户端发送到服务器的语句，而不包括在存储程序中执行的语句。The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs.
`replica_open_temp_tables`	`Replica_open_temp_tables`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	复制 SQL 线程当前打开的临时表数量。Number of temporary tables that the replication SQL thread currently has open.
`secondary_engine_execution_count`	`Secondary_engine_execution_count`	`ASYNC COUNTERASYNC COUNTER`	被卸载到辅助引擎的查询数量The number of queries offloaded to a secondary engine
`select_full_join`	`Select_full_join`	`ASYNC COUNTERASYNC COUNTER`	由于未使用索引而执行表扫描的连接数The number of joins that perform table scans because they do not use indexes
`select_full_range_join`	`Select_full_range_join`	`ASYNC COUNTERASYNC COUNTER`	在参考表上使用范围搜索的连接数The number of joins that used a range search on a reference table
`select_range`	`Select_range`	`ASYNC COUNTERASYNC COUNTER`	在第一张表上使用范围的连接数The number of joins that used ranges on the first table
`select_range_check`	`Select_range_check`	`ASYNC COUNTERASYNC COUNTER`	没有键的连接在每行之后检查键使用情况的次数The number of joins without keys that check for key usage after each row
`select_scan`	`Select_scan`	`ASYNC COUNTERASYNC COUNTER`	执行了第一次表全表扫描的连接数The number of joins that did a full scan of the first table
`slow_launch_threads`	`Slow_launch_threads`	`ASYNC COUNTERASYNC COUNTER`	创建线程所耗时超过 slow_launch_time 秒的线程数。The number of threads that have taken more than slow_launch_time seconds to create.
`slow_queries`	`Slow_queries`	`ASYNC COUNTERASYNC COUNTER`	执行时间超过 long_query_time 秒的查询数The number of queries that have taken more than long_query_time seconds
`sort_merge_passes`	`Sort_merge_passes`	`ASYNC COUNTERASYNC COUNTER`	排序算法必须执行的合并次数The number of merge passes that the sort algorithm has had to do
`sort_range`	`Sort_range`	`ASYNC COUNTERASYNC COUNTER`	使用范围进行的排序次数The number of sorts that were done using ranges
`sort_rows`	`Sort_rows`	`ASYNC COUNTERASYNC COUNTER`	已排序行的数量。The number of sorted rows.
`sort_scan`	`Sort_scan`	`ASYNC COUNTERASYNC COUNTER`	通过扫描表格完成的排序次数。The number of sorts that were done by scanning the table.
`table_locks_immediate`	`Table_locks_immediate`	`ASYNC COUNTERASYNC COUNTER`	请求表锁时能够立即授予的次数The number of times that a request for a table lock could be granted immediately
`table_locks_waited`	`Table_locks_waited`	`ASYNC COUNTERASYNC COUNTER`	请求表锁未能立即授予并需要等待的次数。The number of times that a request for a table lock could not be granted immediately and a wait was needed.
`table_open_cache_hits`	`Table_open_cache_hits`	`ASYNC COUNTERASYNC COUNTER`	打开表缓存查找的命中次数。The number of hits for open tables cache lookups.
`table_open_cache_misses`	`Table_open_cache_misses`	`ASYNC COUNTERASYNC COUNTER`	打开表缓存查找未命中的次数。The number of misses for open tables cache lookups.
`table_open_cache_overflows`	`Table_open_cache_overflows`	`ASYNC COUNTERASYNC COUNTER`	打开表缓存溢出的次数。The number of overflows for the open tables cache.
`tc_log_page_waits`	`Tc_log_page_waits`	`ASYNC COUNTERASYNC COUNTER`	对于恢复日志的内存映射实现，每当服务器无法提交事务而必须等待日志中的空闲页时，此变量就会递增。For the memory-mapped implementation of the recovery log, this variable increments each time the server was not able to commit a transaction and had to wait for a free page in the log.
`threads_cached`	`Threads_cached`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	线程缓存中的线程数量。The number of threads in the thread cache.
`threads_connected`	`Threads_connected`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前打开连接的数量The number of currently open connections
`threads_created`	`Threads_created`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	为处理连接而创建的线程数。The number of threads created to handle connections.
`threads_running`	`Threads_running`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	未处于睡眠状态的线程数。The number of threads that are not sleeping.
`uptime`	`Uptime`	`ASYNC COUNTERASYNC COUNTER`	服务器已运行的秒数。The number of seconds that the server has been up.

mysql.stats.com 指标mysql.stats.com Metrics

mysql.stats.com 指标对应于 Com_xxx 语句计数变量。更多信息请参见第 7.1.10 节，“服务器状态变量” 以及 Com_xxx。The mysql.stats.com metrics correspond to the Com_xxx statement counter variables. See Section 7.1.10, “Server Status Variables” and Com_xxxfor more information.

mysql.stats.com 指标的命名与这些变量相同，但省略了 Com_ 前缀。例如，select 指标对应于 Com_select 语句计数变量。The mysql.stats.com metrics are named for those variables, without the Com_ prefix. For example, the select metric corresponds to the Com_select statement counter variable.

这些指标的 OTEL 类型为 ASYNC COUNTER，记录相应命令语句被执行的次数（整数）。These metrics are of OTEL Type ASYNC COUNTER and record the number of times (INTEGER) the corresponding command statement has been executed.

mysql.stats.connection 指标mysql.stats.connection Metrics

mysql.stats.connection 指标对应于 Connections 和 Connection_XXX 状态变量。The mysql.stats.connection metrics correspond to the Connections and Connection_XXX status variables.

表 35.4 mysql.stats.connection 指标Table 35.4 mysql.stats.connection Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`total`	`Connections`	`ASYNC COUNTERASYNC COUNTER`	创建的总连接累计数。Cumulative count of total connections created.
`errors_accept`	`Connection_errors_accept`	`ASYNC COUNTERASYNC COUNTER`	在监听端口调用 `accept()` 时发生的错误数量。The number of errors that occurred during calls to `accept()` on the listening port.
`errors_internal`	`Connection_errors_internalConnection_errors_internal`	`ASYNC COUNTERASYNC COUNTER`	由于服务器内部错误，如无法启动新线程或内存不足，导致连接被拒绝的数量。The number of connections refused due to internal errors in the server, such as failure to start a new thread or an out-of-memory condition.
`errors_max_connectionserrors_max_connections`	`Connection_errors_max_connectionsConnection_errors_max_connections`	`ASYNC COUNTERASYNC COUNTER`	由于达到服务器的 max_connections 限制而被拒绝的连接数。The number of connections refused because the server max_connections limit was reached.
`errors_peer_addresserrors_peer_address`	`Connection_errors_peer_addressConnection_errors_peer_address`	`ASYNC COUNTERASYNC COUNTER`	在搜索连接客户端 IP 地址时发生的错误数量。The number of errors that occurred while searching for connecting client IP addresses.
`errors_selecterrors_select`	`Connection_errors_selectConnection_errors_select`	`ASYNC COUNTERASYNC COUNTER`	在监听端口调用 select() 或 poll() 时发生的错误数量。The number of errors that occurred during calls to select() or poll() on the listening port.
`errors_tcpwrap`	`Connection_errors_tcpwrap`	`ASYNC COUNTERASYNC COUNTER`	被 `libwrap` 库拒绝的连接次数。The number of connections refused by the `libwrap` library.

mysql.perf_schema 指标mysql.perf_schema Metrics

mysql.perf_schema 对应于 Performance_schema_XXX 状态变量。参见第 29.7 节，“Performance Schema 状态监控”。The mysql.perf_schema correspond to the Performance_schema_XXX status variables. See Section 29.7, “Performance Schema Status Monitoring”.

表 35.5 mysql.perf_schema 指标Table 35.5 mysql.perf_schema Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`accounts_lost`	`Performance_schema_accounts_lost`	`ASYNC COUNTERASYNC COUNTER`	由于 accounts 表已满而无法添加行的次数。The number of times a row could not be added to the accounts table because it was full.
`cond_classes_lost`	`Performance_schema_cond_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少条件工具无法加载。How many condition instruments could not be loaded.
`cond_instances_lost`	`Performance_schema_cond_instances_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少条件工具实例无法创建。How many condition instrument instances could not be created.
`digest_lost`	`Performance_schema_digest_lost`	`ASYNC COUNTERASYNC COUNTER`	在`events_statements_summary_by_digest` 表中无法被监控的摘要实例的数量。The number of digest instances that could not be instrumented in the `events_statements_summary_by_digest` table.
`file_classes_lost`	`Performance_schema_file_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少文件工具未能加载。How many file instruments could not be loaded.
`file_handles_lost`	`Performance_schema_file_handles_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少文件工具实例未能打开。How many file instrument instances could not be opened.
`file_instances_lost`	`Performance_schema_file_instances_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少文件工具实例未能创建。How many file instrument instances could not be created.
`hosts_lost`	`Performance_schema_hosts_lost`	`ASYNC COUNTERASYNC COUNTER`	行无法添加到 hosts 表中的次数，因为表已满。The number of times a row could not be added to the hosts table because it was full.
`index_stat_lost`	`Performance_schema_index_stat_lost`	`ASYNC COUNTERASYNC COUNTER`	索引统计数据丢失的次数。The number of indexes for which statistics were lost.
`locker_lost`	`Performance_schema_locker_lost`	`ASYNC COUNTERASYNC COUNTER`	丢失或未记录的事件数量。How many events are lost or not recorded.
`memory_classes_lost`	`Performance_schema_memory_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	内存工具无法加载的次数。The number of times a memory instrument could not be loaded.
`metadata_lock_lost`	`Performance_schema_metadata_lock_lost`	`ASYNC COUNTERASYNC COUNTER`	在`metadata_locks` 表中无法检测的元数据锁数量。The number of metadata locks that could not be instrumented in the `metadata_locks` table.
`meter_lost`	`Performance_schema_meter_lost`	`ASYNC COUNTERASYNC COUNTER`	无法加载的计量器仪表数量。How many meter instruments could not be loaded.
`metric_lost`	`Performance_schema_metric_lost`	`ASYNC COUNTERASYNC COUNTER`	无法加载的度量仪表数量。How many metric instruments could not be loaded.
`mutex_classes_lost`	`Performance_schema_mutex_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	无法加载的互斥仪器数量。How many mutex instruments could not be loaded.
`mutex_instances_lost`	`Performance_schema_mutex_instances_lost`	`ASYNC COUNTERASYNC COUNTER`	无法创建的互斥仪器实例数量。How many mutex instrument instances could not be created.
`nested_statement_lost`	`Performance_schema_nested_statement_lost`	`ASYNC COUNTERASYNC COUNTER`	已丢失统计信息的存储程序语句的数量。The number of stored program statements for which statistics were lost.
`prepared_statements_lost`	`Performance_schema_prepared_statements_lost`	`ASYNC COUNTERASYNC COUNTER`	在`prepared_statements_instances`表中无法检测的预处理语句数量。The number of prepared statements that could not be instrumented in the `prepared_statements_instances` table.
`program_lost`	`Performance_schema_program_lost`	`ASYNC COUNTERASYNC COUNTER`	丢失统计信息的存储程序数量。The number of stored programs for which statistics were lost.
`rwlock_classes_lost`	`Performance_schema_rwlock_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	无法加载的 rwlock 工具数量。How many rwlock instruments could not be loaded.
`rwlock_instances_lost`	`Performance_schema_rwlock_instances_lost`	`ASYNC COUNTERASYNC COUNTER`	无法创建的 rwlock 工具实例数量。How many rwlock instrument instances could not be created.
`session_connect_attrs_longest_seen`	`Performance_schema_session_connect_attrs_longest_seen`	`ASYNC COUNTERASYNC COUNTER`	接收到的最长连接属性。Longest seen connection attribute received.
`session_connect_attrs_lost`	`Performance_schema_session_connect_attrs_lost`	`ASYNC COUNTERASYNC COUNTER`	发生连接属性截断的连接数量The number of connections for which connection attribute truncation has occurred
`socket_classes_lost`	`Performance_schema_socket_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	无法加载的套接字工具数。How many socket instruments could not be loaded.
`socket_instances_lost`	`Performance_schema_socket_instances_lost`	`ASYNC COUNTERASYNC COUNTER`	无法创建的套接字工具实例数。How many socket instrument instances could not be created.
`stage_classes_lost`	`Performance_schema_stage_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	无法加载的阶段工具数。How many stage instruments could not be loaded.
`statement_classes_lost`	`Performance_schema_statement_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少语句工具无法加载。How many statement instruments could not be loaded.
`table_handles_lost`	`Performance_schema_table_handles_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少个表的仪表实例无法打开。How many table instrument instances could not be opened.
`table_instances_lost`	`Performance_schema_table_instances_lost`	`ASYNC COUNTERASYNC COUNTER`	无法创建的表仪表实例数量。How many table instrument instances could not be created.
`table_lock_stat_lost`	`Performance_schema_table_lock_stat_lost`	`ASYNC COUNTERASYNC COUNTER`	丢失锁统计的表的数量。The number of tables for which lock statistics were lost.
`thread_classes_lost`	`Performance_schema_thread_classes_lost`	`ASYNC COUNTERASYNC COUNTER`	有多少线程工具无法加载。How many thread instruments could not be loaded.
`thread_instances_lost`	`Performance_schema_thread_instances_lost`	`ASYNC COUNTERASYNC COUNTER`	在 `threads` 表中无法被监控的线程实例数量。The number of thread instances that could not be instrumented in the `threads` table.
`users_lost`	`Performance_schema_users_lost`	`ASYNC COUNTERASYNC COUNTER`	由于`users`表已满而无法添加行的次数。The number of times a row could not be added to the `users` table because it was full.

mysql.stats.handler 指标mysql.stats.handler Metrics

mysql.stats.handler 指标对应于 Handler_XXX 状态变量。The mysql.stats.handler metrics correspond to the Handler_XXX status variables.

表 35.6 mysql.perf_schema 指标Table 35.6 mysql.perf_schema Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`commit`	`Handler_commit`	`ASYNC COUNTERASYNC COUNTER`	内部 COMMIT 语句的数量。The number of internal COMMIT statements.
`delete`	`Handler_delete`	`ASYNC COUNTERASYNC COUNTER`	从表中删除行的次数The number of times that rows have been deleted from tables
`discover`	`Handler_discover`	`ASYNC COUNTERASYNC COUNTER`	发现表的次数。The number of times that tables have been discovered.
`external_lock`	`Handler_external_lock`	`ASYNC COUNTERASYNC COUNTER`	服务器在每次调用其 external_lock() 函数时增加此变量，该操作通常发生在访问表实例的开始和结束时。The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table instance.
`mrr_init`	`Handler_mrr_init`	`ASYNC COUNTERASYNC COUNTER`	服务器使用存储引擎自身的多范围读取实现进行表访问的次数。The number of times the server uses a storage engine's own Multi-Range Read implementation for table access.
`prepare`	`Handler_prepare`	`ASYNC COUNTERASYNC COUNTER`	用于两阶段提交操作准备阶段的计数器。A counter for the prepare phase of two-phase commit operations.
`read_first`	`Handler_read_first`	`ASYNC COUNTERASYNC COUNTER`	读取索引中第一个条目的次数。The number of times the first entry in an index was read.
`read_key`	`Handler_read_key`	`ASYNC COUNTERASYNC COUNTER`	基于键读取行的请求次数。The number of requests to read a row based on a key.
`read_last`	`Handler_read_last`	`ASYNC COUNTERASYNC COUNTER`	读取索引中最后一个键的请求次数。The number of requests to read the last key in an index.
`read_next`	`Handler_read_next`	`ASYNC COUNTERASYNC COUNTER`	按键顺序读取下一行的请求次数。The number of requests to read the next row in key order.
`read_prev`	`Handler_read_prev`	`ASYNC COUNTERASYNC COUNTER`	按键顺序读取前一行的请求次数。The number of requests to read the previous row in key order.
`read_rnd`	`Handler_read_rnd`	`ASYNC COUNTERASYNC COUNTER`	根据固定位置读取行的请求次数。The number of requests to read a row based on a fixed position.
`read_rnd_next`	`Handler_read_rnd_next`	`ASYNC COUNTERASYNC COUNTER`	读取数据文件中下一行的请求次数。The number of requests to read the next row in the data file.
`rollback`	`Handler_rollback`	`ASYNC COUNTERASYNC COUNTER`	请求存储引擎执行回滚操作的次数。The number of requests for a storage engine to perform a rollback operation.
`savepoint`	`Handler_savepoint`	`ASYNC COUNTERASYNC COUNTER`	请求存储引擎设置保存点的次数。The number of requests for a storage engine to place a savepoint.
`savepoint_rollback`	`Handler_savepoint_rollback`	`ASYNC COUNTERASYNC COUNTER`	存储引擎回滚到保存点的请求次数。The number of requests for a storage engine to roll back to a savepoint.
`updateupdate`	`Handler_update`	`ASYNC COUNTERASYNC COUNTER`	更新表中某一行的请求数量。The number of requests to update a row in a table.
`writewrite`	`Handler_write`	`ASYNC COUNTERASYNC COUNTER`	向表中插入一行的请求数量。The number of requests to insert a row in a table.

mysql.stats.myisam 指标mysql.stats.myisam Metrics

表 35.7 mysql.perf_schema 指标Table 35.7 mysql.perf_schema Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`key_blocks_not_flushed`	`Key_blocks_not_flushed`	`ASYNC COUNTERASYNC COUNTER`	在 MyISAM 键缓存中已更改但尚未刷新到磁盘的键块数量。The number of key blocks in the MyISAM key cache that have changed but have not yet been flushed to disk.
`key_blocks_unused`	`Key_blocks_unused`	`ASYNC COUNTERASYNC COUNTER`	MyISAM 键缓存中未使用的块数。The number of unused blocks in the MyISAM key cache.
`key_blocks_used`	`Key_blocks_used`	`ASYNC COUNTERASYNC COUNTER`	MyISAM 键缓存中已使用的块数。The number of used blocks in the MyISAM key cache.
`key_read_requests`	`Key_read_requests`	`ASYNC COUNTERASYNC COUNTER`	从 MyISAM 键缓存中读取键块的请求次数。The number of requests to read a key block from the MyISAM key cache.
`key_reads`	`Key_reads`	`ASYNC COUNTERASYNC COUNTER`	从磁盘读取键块到 MyISAM 键缓存的物理读取次数。The number of physical reads of a key block from disk into the MyISAM key cache.
`key_write_requests`	`Key_write_requests`	`ASYNC COUNTERASYNC COUNTER`	写入 MyISAM 键缓存的键块请求次数。The number of requests to write a key block to the MyISAM key cache.
`key_writes`	`Key_writes`	`ASYNC COUNTERASYNC COUNTER`	将 MyISAM 键缓存中的键块物理写入磁盘的次数。The number of physical writes of a key block from the MyISAM key cache to disk.

mysql.stats.ssl 指标mysql.stats.ssl Metrics

表 35.8 mysql.stats.ssl 指标Table 35.8 mysql.stats.ssl Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`client_connects`	`Ssl_client_connects`	`ASYNC COUNTERASYNC COUNTER`	尝试与启用 SSL 的复制源服务器建立 SSL 连接的次数。The number of SSL connection attempts to an SSL-enabled replication source server.
`connect_renegotiates`	`Ssl_connect_renegotiates`	`ASYNC COUNTERASYNC COUNTER`	建立与启用 SSL 的复制源服务器连接所需的协商次数。The number of negotiates needed to establish the connection to an SSL-enabled replication source server.
`finished_accepts`	`Ssl_finished_accepts`	`ASYNC COUNTERASYNC COUNTER`	与服务器成功的 SSL 连接数。The number of successful SSL connections to the server.
`finished_connects`	`Ssl_finished_connects`	`ASYNC COUNTERASYNC COUNTER`	成功连接到启用 SSL 的复制源服务器的副本连接数。The number of successful replica connections to an SSL-enabled replication source server.
`session_cache_hits`	`Ssl_session_cache_hits`	`ASYNC COUNTERASYNC COUNTER`	SSL 会话缓存命中的次数。The number of SSL session cache hits.
`session_cache_misses`	`Ssl_session_cache_misses`	`ASYNC COUNTERASYNC COUNTER`	SSL 会话缓存未命中的次数。The number of SSL session cache misses.
`session_cache_overflowssession_cache_overflows`	`Ssl_session_cache_overflowsSsl_session_cache_overflows`	`ASYNC COUNTERASYNC COUNTER`	SSL 会话缓存溢出的次数。The number of SSL session cache overflows.
`session_cache_sizesession_cache_size`	`Ssl_session_cache_sizeSsl_session_cache_size`	`ASYNC COUNTERASYNC COUNTER`	SSL 会话缓存大小。The SSL session cache size.
`session_cache_timeoutssession_cache_timeouts`	`Ssl_session_cache_timeoutsSsl_session_cache_timeouts`	`ASYNC COUNTERASYNC COUNTER`	SSL 会话缓存超时的次数。The number of SSL session cache timeouts.
`used_session_cache_entriesused_session_cache_entries`	`Ssl_used_session_cache_entriesSsl_used_session_cache_entries`	`ASYNC COUNTERASYNC COUNTER`	使用了多少 SSL 会话缓存条目。How many SSL session cache entries were used.
`accept_renegotiatesaccept_renegotiates`	`Ssl_accept_renegotiates`	`ASYNC COUNTERASYNC COUNTER`	建立连接所需的协商次数。The number of negotiates needed to establish the connection.
`acceptsaccepts`	`Ssl_accepts`	`ASYNC COUNTERASYNC COUNTER`	接受的 SSL 连接数。The number of accepted SSL connections.
`callback_cache_hitscallback_cache_hits`	`Ssl_callback_cache_hits`	`ASYNC COUNTERASYNC COUNTER`	回调缓存命中的次数。The number of callback cache hits.

mysql.inno 指标mysql.inno Metrics

表 35.9 mysql.inno 指标Table 35.9 mysql.inno Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`dblwr_pages_written`	`Innodb_dblwr_pages_written`	`ASYNC COUNTERASYNC COUNTER`	为双写操作写入的页数Number of pages that have been written for doublewrite operations
`dblwr_writes`	`Innodb_dblwr_writes`	`ASYNC COUNTERASYNC COUNTER`	已执行的双写操作次数Number of doublewrite operations that have been performed
`redo_log_logical_size`	`Innodb_redo_log_logical_size`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	包含正在使用的重做日志数据的 LSN 范围大小（以字节为单位）。LSN range size in bytes containing in-use redo log data.
`redo_log_physical_size`	`Innodb_redo_log_physical_size`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前所有磁盘上的重做日志文件占用的磁盘空间（以字节为单位），不包括备用重做日志文件Disk space in bytes currently consumed by all redo log files on disk, excluding spare redo log files
`redo_log_capacity_resized`	`Innodb_redo_log_capacity_resized`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	最后一次完成容量调整操作后，所有重做日志文件的重做日志容量（以字节为单位）Redo log capacity in bytes for all redo log files, after the last completed capacity resize operation
`log_waits`	`Innodb_log_waits`	`ASYNC COUNTERASYNC COUNTER`	由于日志缓冲区过小导致的日志等待次数Number of log waits due to small log buffer
`log_write_requests`	`Innodb_log_write_requests`	`ASYNC COUNTERASYNC COUNTER`	日志写入请求次数Number of log write requests
`log_writes`	`Innodb_log_writes`	`ASYNC COUNTERASYNC COUNTER`	对 InnoDB 重做日志文件的物理写入次数The number of physical writes to the InnoDB redo log file
`os_log_fsyncs`	`Innodb_os_log_fsyncs`	`ASYNC COUNTERASYNC COUNTER`	fsync 日志写入次数Number of fsync log writes.
`os_log_pending_fsyncs`	`Innodb_os_log_pending_fsyncs`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	挂起的 fsync 写入数量。Number of pending fsync writes.
`os_log_pending_writes`	`Innodb_os_log_pending_writes`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	挂起的日志文件写入数量。Number of pending log file writes.
`os_log_written`	`Innodb_os_log_written`	`ASYNC COUNTERASYNC COUNTER`	已写日志字节数。Bytes of log written.
`page_size`	`Innodb_page_size`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	InnoDB 页大小（字节）。InnoDB page size in bytes.
`pages_created`	`Innodb_pages_created`	`ASYNC COUNTERASYNC COUNTER`	创建的页数Number of pages created
`pages_read`	`Innodb_pages_read`	`ASYNC COUNTERASYNC COUNTER`	读取的页数Number of pages read.
`pages_written`	`Innodb_pages_written`	`ASYNC COUNTERASYNC COUNTER`	写入的页数Number of pages written.
`row_lock_current_waits`	`Innodb_row_lock_current_waits`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前正在等待的行锁数量。Number of row locks currently being waited for.
`row_lock_time`	`Innodb_row_lock_time`	`ASYNC COUNTERASYNC COUNTER`	获取行锁所花费的时间，单位为毫秒Time spent in acquiring row locks, in milliseconds
`row_lock_time_avg`	`Innodb_row_lock_time_avg`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	获取行锁的平均时间，单位为毫秒The average time to acquire a row lock, in milliseconds
`row_lock_time_max`	`Innodb_row_lock_time_max`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	获取行锁的最大时间，单位为毫秒。The maximum time to acquire a row lock, in milliseconds.
`row_lock_waits`	`Innodb_row_lock_waits`	`ASYNC COUNTERASYNC COUNTER`	行锁被等待的次数。Number of times a row lock had to be waited for.
`rows_deleted`	`Innodb_rows_deleted`	`ASYNC COUNTERASYNC COUNTER`	插入到 InnoDB 表中的行数。The number of rows inserted into InnoDB tables.
`rows_read`	`Innodb_rows_read`	`ASYNC COUNTERASYNC COUNTER`	从 InnoDB 表中读取的行数。The number of rows read from InnoDB tables
`rows_updated`	`Innodb_rows_updated`	`ASYNC COUNTERASYNC COUNTER`	在 InnoDB 表中更新的行数。The number of rows updated in InnoDB tables.
`system_rows_deleted`	`Innodb_system_rows_deleted`	`ASYNC COUNTERASYNC COUNTER`	从属于系统创建模式的 InnoDB 表中删除的行数。Number of rows deleted from InnoDB tables belonging to system-created schemas.
`system_rows_inserted`	`Innodb_system_rows_inserted`	`ASYNC COUNTERASYNC COUNTER`	插入到属于系统创建模式的 InnoDB 表中的行数Number of rows inserted into InnoDB tables belonging to system-created schemas
`system_rows_read`	`Innodb_system_rows_read`	`ASYNC COUNTERASYNC COUNTER`	从属于系统创建模式的 InnoDB 表中读取的行数。Number of rows read from InnoDB tables belonging to system-created schemas.
`system_rows_updated`	`Innodb_system_rows_updated`	`ASYNC COUNTERASYNC COUNTER`	属于系统创建模式的 InnoDB 表中更新的行数。Number of rows updated in InnoDB tables belonging to system-created schemas.
`num_open_files`	`Innodb_num_open_files`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前打开的文件数。Number of files currently open.
`truncated_status_writes`	`Innodb_truncated_status_writes`	`ASYNC COUNTERASYNC COUNTER`	`SHOW ENGINE INNODB STATUS` 语句输出被截断的次数。Number of times output from the `SHOW ENGINE INNODB STATUS` statement has been truncated.
`undo_tablespaces_total`	`Innodb_undo_tablespaces_total`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	撤销表空间的总数。Total number of undo tablespaces.
`undo_tablespaces_explicit`	`Innodb_undo_tablespaces_explicit`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	用户创建的撤销表空间数量。Number of user-created undo tablespaces.
`undo_tablespaces_active`	`Innodb_undo_tablespaces_active`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	活动撤销表空间的数量，包括隐式和显式表空间Number of active undo tablespaces, including implicit and explicit tablespaces

mysql.inno.buffer_pool 指标mysql.inno.buffer_pool Metrics

表 35.10 mysql.inno.buffer_pool 指标Table 35.10 mysql.inno.buffer_pool Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`pages_data`	`Innodb_buffer_pool_pages_data`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	包含数据的缓冲区页。Buffer pages containing data.
`bytes_data`	`Innodb_buffer_pool_bytes_data`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	包含数据的缓冲区字节数。Buffer bytes containing data.
`pages_dirty`	`Innodb_buffer_pool_pages_dirty`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前脏的缓冲区页。Buffer pages currently dirty.
`bytes_dirty`	`Innodb_buffer_pool_bytes_dirty`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前脏的缓冲区字节数Buffer bytes currently dirty
`pages_flushed`	`Innodb_buffer_pool_pages_flushed`	`ASYNC COUNTERASYNC COUNTER`	请求从 InnoDB 缓冲池刷新页面的次数。The number of requests to flush pages from the InnoDB buffer pool.
`pages_free`	`Innodb_buffer_pool_pages_free`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前空闲的缓冲区页面。Buffer pages currently free.
`pages_misc`	`Innodb_buffer_pool_pages_misc`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	用于各种用途（如行锁或自适应哈希索引）的缓冲页。Buffer pages for misc use such as row locks or the adaptive hash index.
`pages_total`	`Innodb_buffer_pool_pages_total`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	缓冲池总大小（以页为单位）。Total buffer pool size in pages.
`read_ahead_rnd`	`Innodb_buffer_pool_read_ahead_rnd`	`ASYNC COUNTERASYNC COUNTER`	由 InnoDB 发起的“随机”预读次数。The number of 'random' read-aheads initiated by InnoDB.
`read_ahead`	`Innodb_buffer_pool_read_ahead`	`ASYNC COUNTERASYNC COUNTER`	作为预读读取的页数。Number of pages read as read ahead.
`read_ahead_evicted`	`Innodb_buffer_pool_read_ahead_evicted`	`ASYNC COUNTERASYNC COUNTER`	预读页在未被访问的情况下被驱逐。Read-ahead pages evicted without being accessed.
`read_requests`	`Innodb_buffer_pool_read_requests`	`ASYNC COUNTERASYNC COUNTER`	逻辑读请求的数量。Number of logical read requests.
`reads`	`Innodb_buffer_pool_reads`	`ASYNC COUNTERASYNC COUNTER`	直接从磁盘读取的次数。Number of reads directly from disk.
`wait_free`	`Innodb_buffer_pool_wait_free`	`ASYNC COUNTERASYNC COUNTER`	等待可用缓冲区的次数。Number of times waited for free buffer.
`write_requests`	`Innodb_buffer_pool_write_requests`	`ASYNC COUNTERASYNC COUNTER`	写请求的次数。Number of write requests.

mysql.inno.data 指标mysql.inno.data Metrics

表 35.11 mysql.inno.data 指标Table 35.11 mysql.inno.data Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`fsyncs`	`Innodb_data_fsyncs`	`ASYNC COUNTERASYNC COUNTER`	`fsync()` 调用的次数。Number of `fsync()` calls.
`pending_fsyncs`	`Innodb_data_pending_fsyncs`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	待处理 fsync 操作的次数。Number of pending fsync operations.
`pending_reads`	`Innodb_data_pending_reads`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前待处理的读取数量The current number of pending reads
`pending_writes`	`Innodb_data_pending_writes`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	当前待处理写入的数量。The current number of pending writes.
`readread`	`Innodb_data_read`	`ASYNC COUNTERASYNC COUNTER`	读取的数据量（以字节为单位）。Amount of data read in bytes.
`reads`	`Innodb_data_reads`	`ASYNC COUNTERASYNC COUNTER`	发起的读取次数。Number of reads initiated.
`writes`	`Innodb_data_writes`	`ASYNC COUNTERASYNC COUNTER`	发起的写入次数。Number of writes initiated.
`written`	`Innodb_data_written`	`ASYNC COUNTERASYNC COUNTER`	以字节为单位写入的数据量。Amount of data written in bytes.

mysql.x 指标mysql.x Metrics

表 35.12 mysql.x 指标Table 35.12 mysql.x Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`aborted_clients`	`Mysqlx_aborted_clients`	`ASYNC COUNTERASYNC COUNTER`	由于输入或输出错误而断开的客户端数量。The number of clients that were disconnected because of an input or output error.
`bytes_received`	`Mysqlx_bytes_received`	`ASYNC COUNTERASYNC COUNTER`	通过网络接收的字节总数，在解压缩之前测量。The total number of bytes received through the network, measured before decompression.
`bytes_received_compressed_payload`	`Mysqlx_bytes_received_compressed_payload`	`ASYNC COUNTERASYNC COUNTER`	作为压缩消息有效载荷接收的字节数，在解压缩之前测量。The number of bytes received as compressed message payloads, measured before decompression.
`bytes_received_uncompressed_frame`	`Mysqlx_bytes_received_uncompressed_frame`	`ASYNC COUNTERASYNC COUNTER`	作为压缩消息有效载荷接收的字节数，在解压缩之后测量。The number of bytes received as compressed message payloads, measured after decompression.
`bytes_sent`	`Mysqlx_bytes_sent`	`ASYNC COUNTERASYNC COUNTER`	通过网络发送的字节总数。The total number of bytes sent through the network.
`bytes_sent_compressed_payload`	`Mysqlx_bytes_sent_compressed_payload`	`ASYNC COUNTERASYNC COUNTER`	作为压缩消息负载发送的字节数，测量在压缩之后。The number of bytes sent as compressed message payloads, measured after compression.
`bytes_sent_uncompressed_frame`	`Mysqlx_bytes_sent_uncompressed_frame`	`ASYNC COUNTERASYNC COUNTER`	作为未压缩消息帧发送的字节数，测量在压缩之前。The number of bytes sent as compressed message payloads, measured before compression.
`connection_accept_errors`	`Mysqlx_connection_accept_errors`	`ASYNC COUNTERASYNC COUNTER`	导致接受错误的连接数。The number of connections which have caused accept errors.
`connection_errors`	`Mysqlx_connection_errors`	`ASYNC COUNTERASYNC COUNTER`	引起错误的连接数。The number of connections which have caused errors.
`connections_accepted`	`Mysqlx_connections_accepted`	`ASYNC COUNTERASYNC COUNTER`	已被接受的连接数。The number of connections which have been accepted.
`connections_closed`	`Mysqlx_connections_closed`	`ASYNC COUNTERASYNC COUNTER`	已关闭的连接数。The number of connections which have been closed.
`connections_rejected`	`Mysqlx_connections_rejected`	`ASYNC COUNTERASYNC COUNTER`	被拒绝的连接数量。The number of connections which have been rejected.
`crud_create_view`	`Mysqlx_crud_create_view`	`ASYNC COUNTERASYNC COUNTER`	收到的创建视图请求数量。The number of create view requests received.
`crud_delete`	`Mysqlx_crud_delete`	`ASYNC COUNTERASYNC COUNTER`	收到的删除请求数量。The number of delete requests received.
`crud_drop_view`	`Mysqlx_crud_drop_view`	`ASYNC COUNTERASYNC COUNTER`	收到的删除视图请求数量。The number of drop view requests received.
`crud_find`	`Mysqlx_crud_find`	`ASYNC COUNTERASYNC COUNTER`	收到的查找请求数量。The number of find requests received.
`crud_insert`	`Mysqlx_crud_insert`	`ASYNC COUNTERASYNC COUNTER`	收到的插入请求数量。The number of insert requests received.
`crud_modify_view`	`Mysqlx_crud_modify_view`	`ASYNC COUNTERASYNC COUNTER`	收到的修改视图请求数量。The number of modify view requests received.
`crud_update`	`Mysqlx_crud_update`	`ASYNC COUNTERASYNC COUNTER`	收到的更新请求数量。The number of update requests received.
`cursor_close`	`Mysqlx_cursor_close`	`ASYNC COUNTERASYNC COUNTER`	收到的关闭游标消息数量。The number of cursor-close messages received.
`cursor_fetch`	`Mysqlx_cursor_fetch`	`ASYNC COUNTERASYNC COUNTER`	收到的获取游标消息数量。The number of cursor-fetch messages received.
`cursor_open`	`Mysqlx_cursor_open`	`ASYNC COUNTERASYNC COUNTER`	收到的打开游标消息数量。The number of cursor-open messages received.
`errors_sent`	`Mysqlx_errors_sent`	`ASYNC COUNTERASYNC COUNTER`	发送给客户端的错误数量。The number of errors sent to clients.
`errors_unknown_message_type`	`Mysqlx_errors_unknown_message_type`	`ASYNC COUNTERASYNC COUNTER`	接收到的未知消息类型的数量。The number of unknown message types that have been received.
`expect_close`	`Mysqlx_expect_close`	`ASYNC COUNTERASYNC COUNTER`	已关闭的期望块数量。The number of expectation blocks closed.
`expect_open`	`Mysqlx_expect_open`	`ASYNC COUNTERASYNC COUNTER`	已打开的期望块数。The number of expectation blocks opened.
`init_error`	`Mysqlx_init_error`	`ASYNC COUNTERASYNC COUNTER`	初始化期间的错误数。The number of errors during initialisation.
`messages_sent`	`Mysqlx_messages_sent`	`ASYNC COUNTERASYNC COUNTER`	发送给客户端的所有类型消息的总数。The total number of messages of all types sent to clients.
`notice_global_sent`	`Mysqlx_notice_global_sent`	`ASYNC COUNTERASYNC COUNTER`	发送给客户端的全局通知数量。The number of global notifications sent to clients.
`notice_other_sent`	`Mysqlx_notice_other_sent`	`ASYNC COUNTERASYNC COUNTER`	发送回客户端的其他类型通知的数量。The number of other types of notices sent back to clients.
`notice_warning_sent`	`Mysqlx_notice_warning_sent`	`ASYNC COUNTERASYNC COUNTER`	发送回客户端的警告通知数量。The number of warning notices sent back to clients.
`notified_by_group_replication`	`Mysqlx_notified_by_group_replication`	`ASYNC COUNTERASYNC COUNTER`	发送给客户端的组复制通知数量。Number of Group Replication notifications sent to clients.
`prep_deallocate`	`Mysqlx_prep_deallocate`	`ASYNC COUNTERASYNC COUNTER`	接收到的准备语句释放消息的数量。The number of prepared-statement-deallocate messages received.
`prep_execute`	`Mysqlx_prep_execute`	`ASYNC COUNTERASYNC COUNTER`	接收到的准备语句执行消息的数量。The number of prepared-statement-execute messages received.
`prep_prepare`	`Mysqlx_prep_prepare`	`ASYNC COUNTERASYNC COUNTER`	接收到的准备语句消息的数量。The number of prepared-statement messages received.
`rows_sent`	`Mysqlx_rows_sent`	`ASYNC COUNTERASYNC COUNTER`	发送回客户端的行数。The number of rows sent back to clients.
`sessions`	`Mysqlx_sessions`	`ASYNC COUNTERASYNC COUNTER`	已打开的会话数量。The number of sessions that have been opened.
`sessions_accepted`	`Mysqlx_sessions_accepted`	`ASYNC COUNTERASYNC COUNTER`	已接受的会话尝试次数。The number of session attempts which have been accepted.
`sessions_closed`	`Mysqlx_sessions_closed`	`ASYNC COUNTERASYNC COUNTER`	已关闭的会话数量。The number of sessions that have been closed.
`sessions_fatal_error`	`Mysqlx_sessions_fatal_error`	`ASYNC COUNTERASYNC COUNTER`	已因致命错误而关闭的会话数。The number of sessions that have closed with a fatal error.
`sessions_killed`	`Mysqlx_sessions_killed`	`ASYNC COUNTERASYNC COUNTER`	已被终止的会话数。The number of sessions which have been killed.
`sessions_rejected`	`Mysqlx_sessions_rejected`	`ASYNC COUNTERASYNC COUNTER`	被拒绝的会话尝试次数。The number of session attempts which have been rejected.
`ssl_accepts`	`Mysqlx_ssl_accepts`	`ASYNC COUNTERASYNC COUNTER`	接受的 SSL 连接数。The number of accepted SSL connections.
`ssl_finished_accepts`	`Mysqlx_ssl_finished_accepts`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	与服务器成功的 SSL 连接数。The number of successful SSL connections to the server.
`worker_threads`	`Mysqlx_worker_threads`	`ASYNC GAUGE COUNTERASYNC GAUGE COUNTER`	可用的工作线程数量。The number of worker threads available.
`worker_threads_active`	`Mysqlx_worker_threads_active`	`ASYNC COUNTERASYNC COUNTER`	当前使用的工作线程数量。The number of worker threads currently used.

mysql.x.stmt 指标mysql.x.stmt Metrics

表 35.13 mysql.x.stmt 指标Table 35.13 mysql.x.stmt Metrics

名称Name	源变量Source Variable	OTEL 类型OTEL Type	说明Description
`create_collection`	`Mysqlx_stmt_create_collection`	`ASYNC COUNTERASYNC COUNTER`	接收到的创建集合语句的数量。The number of create collection statements received.
`create_collection_index`	`Mysqlx_stmt_create_collection_index`	`ASYNC COUNTERASYNC COUNTER`	接收到的创建集合索引语句的数量。The number of create collection index statements received.
`disable_notices`	`Mysqlx_stmt_disable_notices`	`ASYNC COUNTERASYNC COUNTER`	收到的禁用通知语句的数量。The number of disable notice statements received.
`drop_collection`	`Mysqlx_stmt_drop_collection`	`ASYNC COUNTERASYNC COUNTER`	收到的删除集合语句的数量。The number of drop collection statements received.
`drop_collection_index`	`Mysqlx_stmt_drop_collection_index`	`ASYNC COUNTERASYNC COUNTER`	收到的删除集合索引语句的数量。The number of drop collection index statements received.
`enable_notices`	`Mysqlx_stmt_enable_notices`	`ASYNC COUNTERASYNC COUNTER`	收到的启用通知语句的数量。The number of enable notice statements received.
`ensure_collection`	`Mysqlx_stmt_ensure_collection`	`ASYNC COUNTERASYNC COUNTER`	收到的确保集合语句的数量。The number of ensure collection statements received.
`execute_mysqlx`	`Mysqlx_stmt_execute_mysqlx`	`ASYNC COUNTERASYNC COUNTER`	收到的命名空间设置为 mysqlx 的 StmtExecute 消息数量。The number of StmtExecute messages received with namespace set to mysqlx.
`execute_sql`	`Mysqlx_stmt_execute_sql`	`ASYNC COUNTERASYNC COUNTER`	收到的 SQL 命名空间的 StmtExecute 请求数量。The number of StmtExecute requests received for the SQL namespace.
`get_collection_options`	`Mysqlx_stmt_get_collection_options`	`ASYNC COUNTERASYNC COUNTER`	收到的获取集合对象语句的数量。The number of get collection object statements received.
`kill_client`	`Mysqlx_stmt_kill_client`	`ASYNC COUNTERASYNC COUNTER`	收到的终止客户端语句的数量。The number of kill client statements received.
`list_clients`	`Mysqlx_stmt_list_clients`	`ASYNC COUNTERASYNC COUNTER`	收到的列出客户端语句的数量。The number of list client statements received.
`list_notices`	`Mysqlx_stmt_list_notices`	`ASYNC COUNTERASYNC COUNTER`	收到的列表通知语句的数量。The number of list notice statements received.
`list_objects`	`Mysqlx_stmt_list_objects`	`ASYNC COUNTERASYNC COUNTER`	收到的列出对象语句的数量。The number of list object statements received.
`modify_collection_options`	`Mysqlx_stmt_modify_collection_options`	`ASYNC COUNTERASYNC COUNTER`	收到的修改集合选项语句的数量。The number of modify collection options statements received.
`ping`	`Mysqlx_stmt_ping`	`ASYNC COUNTERASYNC COUNTER`	收到的 ping 语句的数量。The number of ping statements received.

首页上一级下一节