Note
This variable was introduced in OceanBase Database V1.4.
Description
wait_timeout specifies the time in seconds that the current OBServer node waits for a non-interactive connection to become active before closing it.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 28800 |
| Value range | [1, 31536000] |
| Effective scope | |
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Considerations
When you start a session, the wait_timeout value of the session is initialized based on the global variable wait_timeout or interactive_timeout, depending on the client type. The client type is defined by the connection option CLIENT_INTERACTIVE in mysql_real_connect. For more information about the interactive_timeout variable, see interactive_timeout.
Examples
Set the variable at the session level
obclient> SET wait_timeout = 28800;Set the variable at the global level
obclient> SET GLOBAL wait_timeout = 28800;
