Note
This variable is available starting with V1.4.
Description
connect_timeout specifies the connection timeout period.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to obtain the values of Global system variables.Modify variables
systenants can modify the values of Global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the values of Global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the values of Global system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 10 seconds. |
| Value range | [2, 31536000] |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the connection timeout period to 10 seconds.
obclient> SET GLOBAL connect_timeout = 10;