Note
- For V4.3.x, this variable is available starting with V4.3.5 BP1.
- For V4.2.x other versions, this variable is available starting with V4.2.5 BP1. For V4.2.1, this variable is available starting with V4.2.1 BP10.
Description
socket specifies the name of the Socket file used to connect to the local client.
Applicability
This variable is applicable only to OceanBase Database in MySQL mode.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a Global system variable.Modify variables
This variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | /run/sql.sock |
| Scope | Global |
| Modifiable | No. It is read-only. |
| Read-only | Yes |
Examples
Query the name of the socket file used to connect to the local client.
obclient> SHOW VARIABLES LIKE 'socket';
The query result is as follows:
+---------------+------------------------------------+
| Variable_name | Value |
+---------------+------------------------------------+
| socket | /home/admin/oceanbase/run/sql.sock |
+---------------+------------------------------------+
1 row in set (0.003 sec)