MySQL :: MySQL 8.4 参考手册 :: 35.3.2 Trace Format

MySQL 8.4 参考手册 · 中文镜像

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

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

MySQL 8.4 参考手册 / 35 Telemetry / 35.3 OpenTelemetry Trace / 35.3.2 Trace Format

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

35.3.2 跟踪格式35.3.2 Trace Format

Span 表示追踪中的一个操作。有关更多信息，请参见 OpenTelemetry Span。以下是遥测组件发出的 span 类型：A span represents an operation within a trace. For more information, see OpenTelemetry Span. The following span types are emitted by the telemetry component:

控制 SpanControl Span

在遥测配置更改时发出，通知下游系统已启用或禁用哪些信号收集。Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or disabled.

此 span 类型具有以下属性：This span type has the following attributes:

Name: ControlName: Control
trace_enabled：布尔值。trace_enabled: Boolean.
metrics_enabled: 布尔值。metrics_enabled: Boolean.
logs_enabled: 布尔值logs_enabled: Boolean
details:

会话跨度Session Span

当客户端会话结束时发出，记录从初始连接到会话关闭期间与该会话相关的数据。Issued when a client session ends, recording data relevant to that session from initial connection to close of session.

此 span 类型具有以下属性：This span type has the following attributes:

Name: SessionName: Session
mysql.processlist_id
mysql.thread_id
mysql.user
mysql.host
mysql.group

该 span 还包含使用格式 mysql.session_attr.xxx 生成的动态属性，其中 xxx 是会话连接属性名称。请参见 session_connect_attrs。This span also contains dynamic attributes generated with the format mysql.session_attr.xxx, where xxx is the session connect attribute name. See session_connect_attrs.

例如，在以下会话断开连接后：For example, after the following session disconnects:

mysql> select * from session_connect_attrs;
+----------------+-----------------+------------+------------------+
| PROCESSLIST_ID | ATTR_NAME       | ATTR_VALUE | ORDINAL_POSITION |
+----------------+-----------------+------------+------------------+
|             10 | _pid            | 14488      |                0 |
|             10 | _platform       | x86_64     |                1 |
|             10 | _os             | Linux      |                2 |
|             10 | _client_name    | libmysql   |                3 |
|             10 | os_user         | malff      |                4 |
|             10 | _client_version | 8.4.0-tr   |                5 |
|             10 | program_name    | mysql      |                6 |
+----------------+-----------------+------------+------------------+
7 rows in set (0.00 sec)

生成的会话 span 为：The session span emitted is:

Span #
    Trace ID       : 4137db42febad2d00a4123286076ba18
    Parent ID      : 
    ID             : b7ff26660b9fcb35
    Name           : session
    Kind           : Internal
    Start time     : 2023-01-11 10:58:24.79557649 +0000 UTC
    End time       : 2023-01-11 11:00:50.46695685 +0000 UTC
    Status code    : Unset
    Status message : 
Attributes:
     -> mysql.processlist_id: Int(10)
     -> mysql.thread_id: Int(50)
     -> mysql.user: Str(root)
     -> mysql.host: Str(localhost)
     -> mysql.group: Str(USR_default)
     -> mysql.session_attr._pid: Str(14488)
     -> mysql.session_attr._platform: Str(x86_64)
     -> mysql.session_attr._os: Str(Linux)
     -> mysql.session_attr._client_name: Str(libmysql)
     -> mysql.session_attr.os_user: Str(malff)
     -> mysql.session_attr._client_version: Str(8.4.0-tr)
     -> mysql.session_attr.program_name: Str(mysql)

语句 SpanStatement Span

当服务器中语句执行结束时发出，记录从执行开始到完成的所有相关语句信息。Issued when a statement execution ends in the server, recording all relevant statement information from the start of the execution to its completion.

此 span 类型具有以下属性：This span type has the following attributes:

Name: stmtName: stmt
mysql.event_name
mysql.lock_time
mysql.sql_text
mysql.digest_text
mysql.current_schema
mysql.object_type
mysql.object_schema
mysql.object_name
mysql.sql_errno
mysql.sqlstate
mysql.message_text
mysql.error_count
mysql.warning_count
mysql.rows_affected
mysql.rows_sent
mysql.rows_examined
mysql.created_tmp_disk_tables：创建的临时磁盘表mysql.created_tmp_disk_tables
mysql.created_tmp_tables：创建的临时表mysql.created_tmp_tables
mysql.select_full_join：全连接查询mysql.select_full_join
mysql.select_full_range_join：全范围连接查询mysql.select_full_range_join
mysql.select_range：范围查询mysql.select_range
mysql.select_range_check：范围查询检查mysql.select_range_check
mysql.select_scan：扫描查询mysql.select_scan
mysql.sort_merge_passes：排序归并次数mysql.sort_merge_passes
mysql.sort_range：范围排序mysql.sort_range
mysql.sort_rows：排序的行数mysql.sort_rows
mysql.sort_scan：排序扫描mysql.sort_scan
mysql.no_index_used：未使用索引mysql.no_index_used
mysql.no_good_index_used：未使用有效索引mysql.no_good_index_used
mysql.max_controlled_memory：最大受控内存mysql.max_controlled_memory
mysql.max_total_memory
mysql.cpu_time

首页上一级下一节