Note
This parameter is introduced since OceanBase Database V1.4.
Description
interactive_timeout specifies the time in seconds that the server waits for an idle 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. |
Considerations
When you start a session, the value of the wait_timeout 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 detailed information about the wait_timeout variable, see wait_timeout.
Examples
Session level
obclient> SET interactive_timeout = 28800;Global level
obclient> SET GLOBAL interactive_timeout = 28800;