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.

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

backup_volume_max_size_bytes is a parameter used to configure the size of the backup volume file created by the cubrid backupdb utility in byte unit. 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.

communication_histogram

communication_histogram is a parameter used to configure 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

compactdb_page_reclaim_only is a parameter used to configure 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 unit.
  • Step 2: Optimizes the storage in table unit.
  • Step 3: Optimizes the storage in file (heap file) unit.
csql_history_num

csql_history_num is a parameter used to configure the CSQL Interpreter and the number of SQL statements to be stored in the history of the CSQL Interpreter. The default value is 50.