Note
This variable is available starting with V2.2.77.
Description
ob_proxy_partition_hit specifies whether obproxy sends the data request of an SQL statement to the OBServer node where the primary partition of the data is located.
Attributes
| Attribute | Description |
|---|---|
| Type | Bool |
| Default value | 1 |
| Value range |
|
| Scope | Session |
| Modifiable | No. This variable is supported only when you create a tenant. You cannot modify this variable by executing an SQL statement after the tenant is created. |
Usage notes
You cannot execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle-compatible mode) or the information_schema.SESSION_VARIABLES view (MySQL-compatible mode) to obtain the value of this variable. You can query the SYS.DBA_OB_SYS_VARIABLES view (Oracle-compatible mode) or the oceanbase.DBA_OB_SYS_VARIABLES view (MySQL-compatible mode) to obtain the value of this variable.
Alternatively, you can execute the SELECT statement to obtain the value of this variable:
obclient> SELECT @@ob_proxy_partition_hit;
The result set is as follows:
+--------------------------+
| @@ob_proxy_partition_hit |
+--------------------------+
| 1 |
+--------------------------+
1 row in set