Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Utility-Related Parameters

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

compactdb_page_reclaim_only

int

0

csql_history_num

int

50

1

200

backup_volume_max_size_bytes

int

-1

1024*32

compactdb_page_reclaim_only

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.

  • Step 1 : Optimizes the storage only in data units.
  • Step 2 : Optimizes the storage in table units.
  • Step 3 : Optimizes the storage in file (heap file) units.
csql_history_num

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.

backup_volume_max_size_bytes

backup_volume_max_size_bytes is a parameter that configures the maximum size of the backup volume created by the cubrid backupdb utility in byte units. If the parameter is configured to -1, which is the default value, 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.