Note
This variable was introduced in OceanBase Database V1.4.
Description
interactive_timeout specifies the amount of time in seconds that the OBServer node waits for an idle 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 wait_timeout variable, see wait_timeout.
Examples
Set the variable at the session level
obclient> SET interactive_timeout = 28800;Set the variable at the global level
obclient> SET GLOBAL interactive_timeout = 28800;