Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 | 

The cubrid_broker.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 the Database Server Configuration.

Parameter Name

Scope

Type

Default Value

cubrid_port_id

client parameter

int

1523

communication_histogram client parameter bool no

db_hosts

client parameter

string

NULL

max_clients

server parameter

int

50

block_ddl_statement

client parameter

bool

no

block_nowhere_statement

client parameter

bool

no

intl_mbs_support

client parameter

bool

no

oracle_style_empty_string

client parameter

bool

no

data_buffer_pages

server parameter

int

25000

dont_reuse_heap_file

server parameter

bool

no

index_scan_oid_buffer_pages

server parameter

int

4

sort_buffer_pages

server parameter

int

16

temp_file_memory_size_in_pages

server parameter

int

4

thread_stack_size

server parameter

int

102400

garbage_collection

client 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

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

error_log

client/server parameter

string

cub_client.err, cub_server.err

auto_restart_server

server parameter

bool

yes

deadlock_detection_interval_in_secs

server parameter

int

1

file_lock

server parameter

bool

yes

isolation_level

server parameter

int

3

lock_escalation

server parameter

int

100000

lock_timeout_in_secs

server parameter

int

-1

lock_timeout_message_type

server parameter

int

0

background_archiving server parameter bool yes
log_max_archives server parameter int INT_MAX
log_flush_interval_in_msecs server parameter int 1000

pthread_scope_process

server parameter

bool

yes

backup_volume_max_size_bytes

server parameter

int

-1

checkpoint_interval_in_mins

server parameter

int

720

log_buffer_pages

server parameter

int

50

media_failure_support

server parameter

bool

yes

insert_execution_mode

client parameter

int

1

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

replication

server parameter

bool

no

index_scan_in_oid_order

client parameter

bool

no

single_byte_compare

server parameter

bool

no

compactdb_page_reclaim_only

server parameter

int

0

compat_numeric_division_scale

client/server parameter

bool

no

csql_history_num

client parameter

int

50

java_stored_procedure

server parameter

bool

no

async_commit

server parameter

bool

no

group_commit_interval_in_msecs

server parameter

int

0

index_unfill_factor

server parameter

float

0.20

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