Note
This variable is available starting with OceanBase Database V2.2.77.
Description
ob_proxy_set_trx_executed specifies whether to send the START TRANSACTION syntax to an OBServer node through an ODP. This variable is available starting with OceanBase Database V2.2.77.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | 0 |
| Value range |
|
| Scope | Session |
| Modifiable | No. You can specify this variable when you create a tenant. You cannot modify the value of this variable by using an SQL statement after the tenant is created. |
Considerations
You cannot query the value of this variable by using the SHOW VARIABLES statement or a view. You can use the SELECT statement to return 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