Note
This variable is available starting with V2.2.77.
Description
tracefile_identifier specifies content to be added to logs for easier filtering of line iteration tracking logs.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) or theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the values of Session system variables.Modify variables
systenants and all user tenants can directly modify the values of Session system variables in their own tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | Empty string |
| Scope | Session |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Considerations
You can use the TRACING and STAT HINTS to instruct the executor to print the contents of each row during the execution of an operator. To make these contents easier to search and identify, you can use tracefile_identifier to specify a string, such as XXXYYYZZZ or MY_TRACE, and output it together with the row content to the log.
Examples
Specify the MY_TRACE string to output it together with the row content to the log for easier subsequent searches.
obclient> SET tracefile_identifier = 'MY_TRACE';