The following are parameters related to utilities used in CUBRID. The type and value range for each parameter are as follows:
Parameter Name |
Type |
Default Value |
Min. |
Max. |
---|---|---|---|---|
backup_volume_max_size_bytes |
int |
-1 |
1024*32 |
|
communication_histogram |
bool |
no |
|
|
compactdb_page_reclaim_only |
int |
0 |
|
|
csql_history_num |
int |
50 |
1 |
200 |
backup_volume_max_size_bytes is a parameter that configures the size of the backup volume file created by the cubrid backupdb utility in byte units. If the parameter is configured to -1, which is the default value, the created backup volume is not partitioned; otherwise, the backup volume is partitioned as much as it is specified size.
there is no limit to the size of the backup volume to be created. If it is not configured, the size of the backup volume is allowed up to the size limit of the storage media.
communication_histogram is a parameter related to the cubrid statdump utility. It is related to Session Commands ;.h of the CSQL Interpreter and the default value is no. For details, see Outputting Statistics Information of Server.
compactdb_page_reclaim_only is a parameter related to the compactdb utility, which compacts the storage of already deleted objects to reuse OIDs of the already assigned storage. Storage optimization with the compactdb utility can be divided into three steps. The optimization steps can be selected through the compactdb_page_reclaim_only parameter. If the parameter is configured to 0, which is the default value, step 1, 2 and 3 are all performed, so the storage is optimized in data, table and file units. If it is configured to 1, step 1 is skipped to have the storage optimized in table and file units. If it is configured to 2, steps 1 and 2 are skipped to have the storage optimized only in file units.
csql_history_num is a parameter related to the CSQL Interpreter, and configures the number of SQL statements to be stored in the history of the CSQL Interpreter. The default value is 50.