Note
- For V4.3.x, this variable was introduced starting from V4.3.5 BP1.
- For other versions of V4.2.x, this variable was introduced starting from V4.2.5 BP1. For V4.2.1, it was introduced starting from V4.2.1 BP10.
Description
The pid_file variable specifies the pathname of the file where the server writes its process ID.
Applicability
This variable applies only to the MySQL-compatible mode of OceanBase Database.
Privilege requirement
Query variables
Users in the
systenant and all users in user tenants can use theSHOW VARIABLESstatement or theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the values of global system variables.Modify variables
The value of this variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | /run/observer.pid |
| Scope | GLOBAL |
| Modifiable | No |
Examples
Query the pathname of the file where 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)