Overview
ob_proxy_set_trx_executed specifies whether the user sends the START TRANSACTION Syntax to the OBServer node through OBProxy.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Bool |
| Default Value | 0 |
| Value range |
|
| Effective Scope | Session |
| Modifiable | No. This variable can only be specified when creating a tenant and cannot be modified via SQL statements after the tenant is created. |
Usage instructions
You cannot query the value of this variable by using the SHOW VARIABLES statement or the information_schema.SESSION_VARIABLES view. You can query the value of this variable by using the oceanbase.DBA_OB_SYS_VARIABLES view.
Alternatively, you can use the SELECT statement to retrieve the value of this variable:
obclient> SELECT @@ob_proxy_set_trx_executed;
The return result is as follows:
+-----------------------------+
| @@ob_proxy_set_trx_executed |
+-----------------------------+
| 0 |
+-----------------------------+
1 row in set