log_dir_size_threshold specifies the maximum available space of the directory where OceanBase Database Proxy (ODP) log files are stored. Log files are cleared when the space occupied by log files exceeds min(log_dir_size_threshold, available space of the log directory × log_file_percentage).
| Attribute | Description |
|---|---|
| Parameter type | Capacity |
| Default value | 64 GB |
| Value range | [256 MB, 1 TB] |
| Effective upon ODP restart | No |
For more information about the log_file_percentage parameter, see log_file_percentage.
Examples
Assume that the available space of the log directory is 80 GB and log_file_percentage is set to 80.
Set the maximum available space for ODP log files to 50 GB.
alter proxyconfig set log_dir_size_threshold=50GB;Based on the calculation rule, the maximum space available for ODP log files is min(50 GB, 80 GB × 80%) = 50 GB.
Set the maximum available space for ODP log files to 70 GB.
alter proxyconfig set log_dir_size_threshold=70GB;Based on the calculation rule, the maximum space available for ODP log files is min(70 GB, 80 GB × 80%) = 64 GB.