tracefile_identifier

Description

tracefile_identifier is used to add specified content to logs for easier filtering of line iteration tracking logs.

Privilege requirements

• Query variables

  sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode) to view the values of Session system variables.

• Modify variables

  sys tenants and all user tenants can directly modify the values of Session system variables for their own tenants.

Attributes

Usage

Using the TRACING and STAT HINTs instructs the executor to print the content of each row during operator execution. To make these contents easier to search, you can use tracefile_identifier to specify a string, such as XXXYYYZZZ or MY_TRACE, and output it along with the row content to the log.

Examples

Specify the MY_TRACE string to output it along with the row content to the log for easier subsequent search.

obclient> SET tracefile_identifier = 'MY_TRACE';