| Parameter | Description | Recommended value/range |
|---|---|---|
| server_tcp_user_timeout | The user timeout period for the TCP connection between OceanBase Database Proxy (ODP) and an OBServer. The default value is 0s. |
We recommend that you use the default value. |
| client_tcp_user_timeout | The user timeout period for the TCP connection between ODP and a client. The default value is 0s. |
We recommend that you use the default value. |
| client_max_connections | The maximum number of client connections that ODP supports. The default value is 8192. |
We recommend that you use the default value. |
| connect_observer_max_retries | The maximum number of retries for ODP to connect to the OBServer. The default value is 3. |
We recommend that you use the default value. |
| observer_query_timeout_delta | The network transmission delay added to the ob_query_timeout parameter of an OBServer, in seconds. Value range: [1, 39]. Default value: 20. |
We recommend that you use the default value. |
| sock_option_flag_out | The binary-bit parameter for the TCP connection between ODP and an OBServer. The default value of this parameter varies based on the versions of ODP: 1, which indicates that bit 0 is 1 and no_delay is enabled.3, which indicates that both bit 0 and bit 1 are 1, and no_delay and keepalive are enabled. |
3. |
| server_tcp_keepidle | The idle time before a keepalive packet is sent for the TCP connection between ODP and an OBServer, in seconds. Default value: 5. | We recommend that you use the default value. |
| server_tcp_keepintvl | The interval between two keepalive packets for the TCP connection between ODP and an OBServer, in seconds. Default value: 5. | We recommend that you use the default value. |
| server_tcp_keepcnt | The maximum number of keepalive packets to be sent for the TCP connection between ODP and an OBServer. The default value is 5. |
We recommend that you use the default value. |
| client_sock_option_flag_out | The binary-bit parameter for the TCP connection between ODP and a client. The default value of this parameter varies based on the versions of ODP: 0, which indicates that no feature is enabled.2, which indicates that bit 1 is 1 and keepalive is enabled. |
We recommend that you set the value to 3, which indicates that both bit 0 and bit 1 are 1, and no_delay and keepalive are enabled. |
| client_tcp_keepidle | The idle time before a keepalive packet is sent for the TCP connection between ODP and a client, in seconds. Default value: 5. | We recommend that you use the default value. |
| client_tcp_keepintvl | The interval between two keepalive packets for the TCP connection between ODP and a client, in seconds. Default value: 5. | We recommend that you use the default value. |
| client_tcp_keepcnt | The maximum number of keepalive packets to be sent for the TCP connection between ODP and a client. The default value is 5. |
We recommend that you use the default value. |
Network transmission parameters
share
Previous topic