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-compatible mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to obtain the value of a Global system variable.Modify variables
systenants can directly modify the value of a Global system variable.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of a Global system variable.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the value of a Global system variable.
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;