Note
This variable is available starting with V4.2.5 BP1.
Description
pid_file specifies the path of the file to which the server writes its process ID.
Applicability
This variable is applicable only to OceanBase Database in MySQL mode.
Privilege requirements
Query variables
systenants 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
You cannot modify this variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | /run/observer.pid |
| Scope | Global |
| Modifiable | No. This variable is read-only. |
Examples
Query the path of the file to which the server writes its process ID.
obclient> SHOW VARIABLES LIKE 'pid_file';
The query result is as follows:
+---------------+----------------------------------------+
| Variable_name | Value |
+---------------+----------------------------------------+
| pid_file | /home/admin/oceanbase/run/observer.pid |
+---------------+----------------------------------------+
1 row in set (0.004 sec)