Note
This parameter is introduced since OceanBase Database V2.2.50.
Description
datafile_disk_percentage specifies the percentage of the disk space occupied by data files. The disk of the data_dir directory will be initialized by OceanBase Database to store data.
Attributes
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 0
NoteStarting from OceanBase Database V4.0.0, the default value is adjusted from 90 to 0. |
| Value range | [0, 99]
NoteStarting from OceanBase Database V4.0.0, the value range is adjusted from [5, 99] to [0, 99]. |
| Modifiable | Yes. It can be modified using the ALTER SYSTEM SET statement. |
| 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
Examples
obclient> ALTER SYSTEM SET datafile_disk_percentage=90;