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 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.

Purpose

Parameter Name

Scope

Type

Default Value

Dynamic Change

connection-related

cubrid_port_id

client parameter

int

1523

 

db_hosts

client parameter

string

NULL

O

max_clients

server parameter

int

100

 

memory-related

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

102400

 

garbage_collection

client parameter

bool

no

O

disk-related

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

 

dont_reuse_heap_file

server parameter

bool

no

 

db_volume_size

server parameter

int

512M

 

log_volume_size

server parameter

int

512M

 

error message-related

call_stack_dump_activation_list

client/server parameter

string

NULL

 

call_stack_dump_deactivation_list

client/server parameter

string

NULL

 

call_stack_dump_on_error

client/server parameter

bool

no

O

error_log

client/server parameter

string

cub_client.err, cub_server.err

 

error_log_level

client/server parameter

string

SYNTAX

O

error_log_warning

client/server parameter

bool

no

O

error_log_size

client/server parameter

int

8000000

O

concurrency/lock-related

deadlock_detection_interval_in_secs

server parameter

int

1

O

isolation_level

client parameter

int

3

O

lock_escalation

server parameter

int

100000

 

lock_timeout_in_secs

client parameter

int

-1

O

lock_timeout_message_type

server parameter

int

0

O

logging-related

log_buffer_size

server parameter

int

2M

 

media_failure_support

server parameter

bool

yes

 

log_max_archives

server parameter

int

INT_MAX

O

force_remove_log_archives

server parameter

bool

yes

O

background_archiving

server parameter

bool

yes

O

page_flush_interval_in_msecs

server parameter

int

0

O

checkpoint_interval_in_mins

server parameter

int

720

O

checkpoint_every_npages

server parameter

int

10000

 

adaptive_flush_control

server parameter

bool

yes

O

max_flush_pages_per_second

server parameter

int

10000

O

sync_on_nflush

server parameter

int

200

O

transaction processing-related

async_commit

server parameter

bool

no

 

group_commit_interval_in_msecs

server parameter

int

0

O

statement/type-related

ansi_quotes

client parameter

bool

yes

 

block_ddl_statement

client parameter

bool

no

O

block_nowhere_statement

client parameter

bool

no

O

compat_numeric_division_scale

client/server parameter

bool

no

O

intl_mbs_support

client parameter

bool

no

 

oracle_style_empty_string

client parameter

bool

no

 

only_full_group_by

client parameter

bool

no

O

pipes_as_concat

client parameter

bool

yes

 

add_column_update_hard_default

client parameter

bool

no

O

plus_as_concat

client parameter

bool

yes

 

return_null_on_function_errors

client/server parameter

bool

no

O

no_backslash_escapes

client parameter

bool

yes

 

require_like_escape_character

client parameter

bool

no

 

alter_table_change_type_strict

client/server parameter

bool

no

O

default_week_format

client/server parameter

int

0

O

group_concat_max_len

server parameter

int

1024

O

query cache-related

max_plan_cache_entries

client/server parameter

int

1000

 

max_query_cache_entries

server parameter

int

-1

 

query_cache_mode

server parameter

int

0

 

query_cache_size_in_pages

server parameter

int

-1

 

utility-related

compactdb_page_reclaim_only

server parameter

int

0

 

csql_history_num

client parameter

int

50

O

communication_histogram

client parameter

bool

no

O

backup_volume_max_size_bytes

server parameter

int

-1

 

HA-related

ha_mode

server parameter

string

off

 

other

service

server parameter

string

 

 

server

server parameter

string

 

 

index_scan_in_oid_order

client parameter

bool

no

O

single_byte_compare

server parameter

bool

no

 

insert_execution_mode

client parameter

int

1

 

java_stored_procedure

server parameter

bool

no

 

pthread_scope_process

server parameter

bool

yes

 

auto_restart_server

server parameter

bool

yes

O

index_unfill_factor

server parameter

float

0.05

 

use_orderby_sort_limit

server parameter

bool

yes

O

session_state_timeout

server parameter

int

21600

 

multi_range_optimization_limit

server parameter

int

100

O

access_ip_control

server parameter

bool

no

 

access_ip_control_file

server parameter

string

 

 

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=foo,bar

# Common section - properties for all databases

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

[common]

# Number of data buffer pages

# data_buffer_pages (25,000 pages) * DB page size (4KB) = 100M

data_buffer_pages=25000

# Number of sort buffer pages

# sort_buffer_pages (16 pages) * DB page size (4KB) * number of threads

sort_buffer_pages=16

# Number of log buffer pages.

# log_buffer_pages (50 pages) * DB page size (4KB) = 200KB

log_buffer_pages=50

# Maximum number of locks acquired on individual instances of a

# class before the locks on the instances are escalated to a class lock

lock_escalation=100000

# Minimal amount of time to wait for a lock (seconds).

# A negative value, indicates to wait indefinitely until the lock is

# granted or until the transaction is rolled back as a result of a deadlock.

# A value of 0, indicates not to wait for a lock.

lock_timeout_in_secs=-1

# Interval between attempts at deadlock detection (seconds).

# An approximate interval to attempt to run the deadlock detector.

deadlock_detection_interval_in_secs=1

# Checkpoint when the specified time has passed (minutes).

# Checkpoint will be done also when log has grown by specified pages.

checkpoint_interval_in_mins=720

# Transaction isolation level.

# Six levels of isolation are provided, represented by:

# "TRAN_SERIALIZABLE"

# "TRAN_REP_CLASS_REP_INSTANCE"

# "TRAN_REP_CLASS_COMMIT_INSTANCE"

# "TRAN_REP_CLASS_UNCOMMIT_INSTANCE"

# "TRAN_COMMIT_CLASS_COMMIT_INSTANCE"

# "TRAN_COMMIT_CLASS_UNCOMMIT_INSTANCE"

# For other aliases, or for more information on the levels, see the

# System Parameters chapter in the Database Administration Guide.

isolation_level="TRAN_REP_CLASS_UNCOMMIT_INSTANCE"

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

cubrid_port_id=1523

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

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

max_clients=50

# Restart the server process automatically

auto_restart_server=yes

# Become a master server for replication.

replication=no

# Enable Java Stored Procedure

java_stored_procedure=no