Note
- For OceanBase Database V4.3.x, this parameter was introduced in OceanBase Database V4.3.1.
- For OceanBase Database V4.2.x, this parameter was introduced in OceanBase Database V4.2.3.
Description
syslog_disk_size specifies the maximum disk space for system logs. When the total size of system logs is close to the value specified by this parameter, the earliest log file is deleted, regardless of whether it is compressed.
Limitations
Query the parameter
In the
systenant or a user tenant, you can execute theSHOW PARAMETERSstatement to query the parameter or query theGV$OB_PARAMETERSview for the parameter. In thesystenant, you can also query theinformation_schema.PARAMETERSview for the parameter.Modify the parameter
You can modify the parameter only in the
systenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 0M, which specifies to delete log files to recycle disk space. |
| Value range | [0, +∞) |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
This parameter specifies the maximum disk space for all uncompressed and compressed log files in the
{install_path}/logdirectory.The relationship between the
syslog_disk_sizeparameter and the max_syslog_file_count parameter is as follows:max_syslog_file_count=0andsyslog_disk_size=0: Log files are not deleted until the disk is full.max_syslog_file_count=0andsyslog_disk_size>0: When the total size of log files is close to the value specified bysyslog_disk_size, the earliest log file is deleted to recycle disk spacemax_syslog_file_count>0andsyslog_disk_size=0: When the number of specific log files exceeds the value specified bymax_syslog_file_count, the earliest log file is deleted to recycle disk space.max_syslog_file_count>0andsyslog_disk_size>0: When the number of specific log files exceeds the value specified bymax_syslog_file_countor the total size of log files is close to the value specified bysyslog_disk_size, the earliest compressed log file is deleted.
Example
Set the maximum disk space for system logs to 50 GB.
obclient> ALTER SYSTEM SET syslog_disk_size='50GB';