session_pool_reset_interval sets how often ODP sends COM_RESET_CONNECTION to pooled sessions that have not been reset. After a session is reset, ODP does not send COM_RESET_CONNECTION to it again.
Note
This parameter is introduced in ODP V4.3.5.
Changing it is not recommended; keep the default unless necessary.
Attribute |
Description |
|---|---|
| Parameter type | Time |
| Default value | 10m |
| Value range | [0s, 1d] |
| Effective only after ODP restart | No |
Examples
Set the COM_RESET_CONNECTION interval to 30 minutes:
obclient> alter proxyconfig set session_pool_reset_interval='30m';