Note
- For V4.3.x, this variable is available starting with V4.3.5 BP1.
- For V4.2.x, 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
pid_file specifies the path of the file in which the server writes its process ID.
Applicability
This variable is applicable only to OceanBase Database in MySQL-compatible mode.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the values of Global system variables.Modify variables
This variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | /run/observer.pid |
| Scope | Global |
| Modifiable | No. This variable cannot be modified by using the SET statement. |
| Read-only | Yes |
Examples
Query the path of the file in 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)