| Parameter | Description | Suggested value/range |
|---|---|---|
| enable_index_route | Specifies whether to enable routing for the global index table based on global index keys on OceanBase Database Proxy (ODP). |
We recommend that you use the default value. |
| enable_pl_route | Specifies whether to enable PL routing on ODP. |
We recommend that you set it to False. |
| enable_reroute | Specifies whether to enable secondary routing on ODP. If secondary routing is enabled, when routing fails for the first time, the request is forwarded to the corresponding OBServer node again.Note: |
We recommend that you use the default value. |
| enable_partition_table_route | Specifies whether to enable partition table routing on ODP. |
We recommend that you use the default value. |
| server_routing_mode | The routing mode of ODP. Valid values: |
We recommend that you use the default value. |
| enable_ob_protocol_v2 | Specifies whether to enable the OceanBase 2.0 protocol (a transfer protocol developed by OceanBase based on the MySQL compression protocol) for transfer between ODP and the OBServer node. |
We recommend that you use the default value. |
| routing_cache_mem_limited | Specifies the maximum memory for the PL/SQL route cache. Value range: [1KB, 100G]. Default value: 128 M. | We recommend that you use the default value. |
| enable_bad_route_reject | Specifies whether to reject requests that cannot be routed. |
We recommend that you use the default value. |
You can view and modify the preceding parameters by executing the SHOW PROXYCONFIG LIKE and ALTER PROXYCONFIG SET statements in the sys tenant.
Examples:
obclient>ALTER PROXYCONFIG SET enable_pl_route = False;
obclient> SHOW PROXYCONFIG LIKE 'enable_pl_route';