Note
This variable is introduced since OceanBase Database V1.4.
Description
wait_timeout specifies the time in seconds that the server waits for a non-interactive connection to become active before closing it.
Attributes
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 28800 |
| Value range | [1, 31536000] |
| Applicable scope | |
| Modifiable | Yes. It can be modified using the SET statement. |
When a session is initiated, the value of wait_timeout for the session is initialized based on the value of the global wait_timeout variable or the global interactive_timeout variable, depending on the client type. The client type is determined by the CLIENT_INTERACTIVE option in mysql_real_connect(). For more information about the interactive_timeout variable, see interactive_timeout.
Examples
Session level
obclient> SET wait_timeout = 28800;Global level
obclient> SET GLOBAL wait_timeout = 28800;