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.

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