cubrid.conf Configuration File and Default Parameters

CUBRID consists of the Database Server, the Broker and the CUBRID Manager. The name of the configuration file for each component is as follows. These files are all located in the $CUBRID/conf directory.

Database Server configuration file : cubrid.conf

Broker configuration file : cubrid_broker.conf

CUBRID Manager server configuration file : cm.conf

cubrid.conf is a configuration file that sets system parameters for the CUBRID Database Server and determines overall performance and operation of the database system. In the cubrid.conf file, some important parameters needed for system installation are provided, having their default values.

Database Server System Parameters

The following are Database Server system parameters that can be used in the cubrid.conf configuration file. For the scope of client and server parameters, see Scope of Database Server Configuration.

You can change the parameters that are capable of dynamically changing the setting value through the SET SYSTEM PARAMETERS statement or a session command of the CSQL Interpreter, ;set dynamically. If you are a DBA, you can change parameters regardless of the applied classification. However, if you are not a DBA, you can only change client parameters.

Category

Parameter Name

Applied

Type

Default Value

Dynamicity

Connection

cubrid_port_id

client parameter

int

1523

db_hosts

client parameter

string

NULL

available

max_clients

server parameter

int

100

Memory

data_buffer_size

server parameter

int

512M

index_scan_oid_buffer_size

server parameter

int

64K

sort_buffer_size

server parameter

int

2M

temp_file_memory_size_in_pages

server parameter

int

4

thread_stack_size

server parameter

int

1048576

Disk

db_volume_size

server parameter

int

512M

dont_reuse_heap_file

server parameter

bool

no

temp_file_max_size_in_pages

server parameter

int

-1

temp_volume_path

server parameter

string

NULL

unfill_factor

server parameter

float

0.1

volume_extension_path

server parameter

string

NULL

log_volume_size

server parameter

int

512M

Error message

call_stack_dump_activation_list

client/server parameter

string

NULL

available

call_stack_dump_deactivation_list

client/server parameter

string

NULL

available

call_stack_dump_on_error

client/server parameter

bool

no

available

error_log

client/server parameter

string

cub_client.err, cub_server.err

error_log_level

client/server parameter

string

SYNTAX

available

error_log_warning

client/server parameter

bool

no

available

error_log_size

client/server parameter

int

8000000

available

Concurrency/Lock

deadlock_detection_interval_in_secs

server parameter

float

1.0

available

isolation_level

client parameter

int

3

available

lock_escalation

server parameter

int

100000

lock_timeout_in_secs

client parameter

int

-1

available

lock_timeout_message_type

server parameter

int

0

available

Logging

adaptive_flush_control

server parameter

bool

yes

available

background_archiving

server parameter

bool

yes

available

checkpoint_every_npages

server parameter

int

10000

checkpoint_interval_in_mins

server parameter

int

720

available

force_remove_log_archives

server parameter

bool

yes

available

log_buffer_size

server parameter

int

2M

log_max_archives

server parameter

int

INT_MAX

available

max_flush_pages_per_second

server parameter

int

10000

available

page_flush_interval_in_msecs

server parameter

int

0

available

sync_on_nflush

server parameter

int

200

available

Transaction handling

async_commit

server parameter

bool

no

group_commit_interval_in_msecs

server parameter

int

0

available

Syntax/Type

add_column_update_hard_default

client parameter

bool

no

available

alter_table_change_type_strict

client/server parameter

bool

no

available

ansi_quotes

client parameter

bool

yes

block_ddl_statement

client parameter

bool

no

available

block_nowhere_statement

client parameter

bool

no

available

compat_numeric_division_scale

client/server parameter

bool

no

available

default_week_format

client/server parameter

int

0

available

group_concat_max_len

server parameter

int

1024

available

intl_mbs_support

client parameter

bool

no

no_backslash_escapes

client parameter

bool

yes

only_full_group_by

client parameter

bool

no

available

oracle_style_empty_string

client parameter

bool

no

pipes_as_concat

client parameter

bool

yes

plus_as_concat

client parameter

bool

yes

require_like_escape_character

client parameter

bool

no

return_null_on_function_errors

client/server parameter

bool

no

available

Query cache

max_plan_cache_entries

client/server parameter

int

1000

Utility

backup_volume_max_size_bytes

server parameter

int

-1

communication_histogram

client parameter

bool

no

available

compactdb_page_reclaim_only

server parameter

int

0

csql_history_num

client parameter

int

50

available

HA

ha_mode

server parameter

string

off

Others

access_ip_control

server parameter

bool

no

access_ip_control_file

server parameter

string

auto_restart_server

server parameter

bool

yes

available

index_scan_in_oid_order

client parameter

bool

no

available

index_unfill_factor

server parameter

float

0.05

insert_execution_mode

client parameter

int

1

java_stored_procedure

server parameter

bool

no

multi_range_optimization_limit

server parameter

int

100

available

pthread_scope_process

server parameter

bool

yes

server

server parameter

string

service

server parameter

string

session_state_timeout

server parameter

int

21600

single_byte_compare

server parameter

bool

no

use_orderby_sort_limit

server parameter

bool

yes

available

Section by Parameter

Parameters specified in cubrid.conf have the following three sections:

Used when the CUBRID service starts : [service] section

Applied commonly to all databases : [common] section

Applied individually to each database : [@<database>] section

Where <database> is the name of the database to which each parameter applies. If a parameter configured in [common] is the same as the one configured in [@<database>], the one configured in [@<database>] is applied.

Default Parameters

cubrid.conf, a default database configuration file created during the CUBRID installation, includes some default Database Server parameters that must be changed. You can change the value of a parameter that is not included as a default parameter by manually adding or editing one.