Overview
tracefile_identifier is used to add specific content to the log, facilitating line filtering and iterative tracing of logs.
Privilege requirements
Query variables
Both the
systenant and all user tenants can use theSHOW VARIABLESstatement and theinformation_schema.SESSION_VARIABLESview to view the values of session system variables.Modify variables
The
systenant and all user tenants can directly modify the values of session system variables for their own tenants.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Varchar |
| Default Value | Empty string |
| Effective Scope | Session |
| Modifiable | Yes, you can use theSETStatement modification. |
Usage instructions
You can use the TRACING and STAT hints to instruct the executor to print each line of content during operator execution. To make this content easier to search and identify, you can use tracefile_identifier to specify a string, such as XXXYYYZZZ or MY_TRACE, which will be output to the log together with the line content for easy searching.
Configuration example
Specify the MY_TRACE string to output it together with the line content to the log for easier search later.
obclient> SET tracefile_identifier = 'MY_TRACE';