Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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



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.

The following is the content of the cubrid.conf file.

# Copyright (C) 2008 Search Solution Corporation. All rights reserved by Search Solution.

#

# $Id$

#

# cubrid.conf#

 

# For complete information on parameters, see the CUBRID

# Database Administration Guide chapter on System Parameters

 

# Service section - a section for 'cubrid service' command

[service]

 

# The list of processes to be started automatically by 'cubrid service start' command

# Any combinations are available with server, broker and manager.

service=server,broker,manager

 

# The list of database servers in all by 'cubrid service start' command.

# This property is effective only when the above 'service' property contains 'server' keyword.

#server=server, broker, manager

 

# Common section - properties for all databases

# This section will be applied before other database specific sections.

[common]

 

# Read the manual for detailed description of system parameters

# Manual > Performance Tuning > Database Server Configuration > Default Parameters

 

# Size of data buffer are using K, M, G, T unit

data_buffer_size=512M

 

# Size of log buffer are using K, M, G, T unit

log_buffer_size=4M

 

# Size of sort buffer are using K, M, G, T unit

# The sort buffer should be allocated per thread.

# So, the max size of the sort buffer is sort_buffer_size * max_clients.

sort_buffer_size=2M

 

# The maximum number of concurrent client connections the server will accept.

# This value also means the total # of concurrent transactions.

max_clients=100

 

# TCP port id for the CUBRID programs (used by all clients).

cubrid_port_id=1523