Note
This variable is available starting with OceanBase Database V2.2.77.
Description
ob_proxy_partition_hit specifies whether obproxy sends SQL statements to the OBServer nodes that host the primary partitions of the data.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | 1 |
| Value range |
|
| Scope | Session |
| Modifiable | No. You can specify this variable when you create a tenant. You cannot modify it by executing an SQL statement after the tenant is created. |
Considerations
You cannot query the value of this variable by using the SHOW VARIABLES statement or view. You can execute the SELECT statement to return the value of this variable:
obclient> SELECT @@ob_proxy_partition_hit;
The return result is as follows:
+--------------------------+
| @@ob_proxy_partition_hit |
+--------------------------+
| 1 |
+--------------------------+
1 row in set