Purpose
The GV$OB_FLT_TRACE_CONFIG view displays the configurations related to full-link diagnostics.
Note
This view is introduced since OceanBase Database V4.2.1.
Columns
| Column |
Type |
Nullable? |
Description |
| TENANT_ID |
bigint(20) |
NO |
The ID of the tenant. Valid values:
1: the sys tenant.- Other values: a user tenant or meta tenant.
|
| TYPE |
varchar(16) |
NO |
The monitoring level of diagnostic information.
- Tenant level: Diagnostic information is monitored at the tenant level.
- Module/Action level: Diagnostic information is monitored at the module/action level.
- Client identifier level: Diagnostic information is monitored at the client level based on the client identifier.
|
| TENANT_NAME |
varchar(128) |
NO |
The name of the tenant. |
| MODULE_NAME |
varchar(4096) |
NO |
The name of the module. |
| ACTION_NAME |
varchar(4096) |
NO |
The name of the action. |
| CLIENT_IDENTIFIER |
varchar(65) |
NO |
The client identifier. |
| LEVEL |
bigint(20) |
NO |
The diagnostic information monitoring level for full-link diagnostics of the session. For example, the value 1 indicates that level-1 diagnostic information is monitored. |
| SAMPLE_PERCENTAGE |
bigint(20) |
NO |
The sampling rate for full-link diagnostics of the session. For example, the value 50 indicates that diagnostic information is sampled at a rate of 50%. |
| RECORD_POLICY |
varchar(32) |
NO |
The diagnostic information recording strategy for full-link diagnostics of the session. Three strategies are supported:
ALL: All sampling-enabled traces that meet specified sampling conditions are recorded in the log file immediately after each span ends.ONLY_SLOW_QUERY: Among sampling-enabled traces that meet specified sampling conditions, only traces of slow queries are recorded in the log file, and other traces are discarded. For this strategy, trace logs are recorded after a request ends and is determined as a slow query. In the proxy, the root span, namely the transaction-level span, is immediately recorded when a slow query is detected.SAMPLE_AND_SLOW_QUERY: Among sampling-enabled traces that meet specified sampling conditions, those meeting any of the following conditions are recorded in the log file:
- The hidden parameter
_print_sample_ppm is used for sampling at a rate of 0.01% and the sampling result meets specified conditions.
- The condition specified in the
ONLY_SLOW_QUERY strategy is met.
In this mode, the timing for logging varies based on the situation. Specifically, if Condition 1 is met, it is marked on the client that the trace log will be forcibly recorded and this information will be transferred to subsequent components on the link. If Condition 2 is met, the timing for logging is the same as that in the ONLY_SLOW_QUERY strategy. |
