35.2.2 TRACE Format

A span represents an operation within a trace. For more information, see OpenTelemetry Span. The following span types are emitted by the telemetry component:

• Control Span

• Session Span

• Statement Span

Control Span

Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or disabled.

This span type has the following attributes:

• Name: Control

• trace_enabled: Boolean.

• metrics_enabled: Boolean.

• 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.

This span type has the following attributes:

• Name: Session

• mysql.processlist_id

• mysql.thread_id

• mysql.user

• mysql.host

• mysql.group

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.0.34-tr  |                5 |
|             10 | program_name    | mysql      |                6 |
+----------------+-----------------+------------+------------------+
7 rows in set (0.00 sec)

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.0.34-tr)
     -> mysql.session_attr.program_name: Str(mysql)

Statement Span

Issued when a statement execution ends in the server, recording all relevant statement information from the start of the execution to its completion.

This span type has the following attributes:

• Name: 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_tables

• mysql.select_full_join

• mysql.select_full_range_join

• mysql.select_range

• mysql.select_range_check

• mysql.select_scan

• mysql.sort_merge_passes

• mysql.sort_range

• mysql.sort_rows

• mysql.sort_scan

• mysql.no_index_used

• mysql.no_good_index_used

• mysql.max_controlled_memory

• mysql.max_total_memory

• mysql.cpu_time