Note
This parameter was introduced in OceanBase Database V2.2.50.
Description
datafile_disk_percentage specifies the percentage of the disk space occupied by data files. The disk where the data_dir directory resides is initialized by OceanBase Database to store data.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 0
NoteThe default value has been changed from |
| Value range | [0, 99]
NoteThe value range has been changed from [5, 99] to [0, 99] since OceanBase Database V4.0.0. |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No |
Considerations
If you set this parameter to
0, the system automatically calculates the percentage of the total disk space occupied by data files based on whether the logs and data share the same disk.- If the same disk is shared, the percentage of the total disk space occupied by data files is 60%.
- If the disk is not shared, the percentage of the total disk space occupied by data files is 90%.
If this parameter and the
datafile_sizeparameter are both specified, the value of thedatafile_sizeparameter prevails. For more information about thedatafile_sizeparameter, see datafile_size.
Example
obclient> ALTER SYSTEM SET datafile_disk_percentage=90;