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_broker.conf Configuration File and Default Parameters

Broker System Parameters

The following are Broker parameters that can be used in the cubrid_broker.conf configuration file. For description of each parameter, see Parameter Description in Parameter by Broker.

Parameter Name

Type

Default Value

MASTER_SHM_ID

int

30001

ADMIN_LOG_FILE

string

log/broker/cubrid_broker.log

SERVICE

string

ON

BROKER_PORT

int

30000 (MAX : 65535)

MIN_NUM_APPL_SERVER

int

5

MAX_NUM_APPL_SERVER

int

40

APPL_SERVER_SHM_ID

int

30000

APPL_SERVER_MAX_SIZE

int

For Windows : 40 (32 bit), 80 (64 bit)
For Linux : 0

LOG_DIR

string

log/broker/sql_log

ERROR_LOG_DIR

string

log/broker/error_log

SQL_LOG

string

ON

TIME_TO_KILL

int

120

SESSION_TIMEOUT

int

300

KEEP_CONNECTION

string

AUTO

ACCESS_LIST

string

-

ACCESS_LOG

string

ON

APPL_SERVER_PORT

int

BROKER_PORT+1

APPL_SERVER

string

CAS

LOG_BACKUP

string

OFF

SQL_LOG_MAX_SIZE

int

100000

MAX_STRING_LENGTH

int

-1

SOURCE_ENV

string

cubrid.env

STATEMENT_POOLING

string

ON

CCI_PCONNECT

string

OFF

SELECT_AUTO_COMMIT

string

OFF

LONG_QUERY_TIME

int

60

LONG_TRANSACTION_TIME

int

60

ACCESS_MODE

string

RW

Default Parameters

cubrid_broker.conf, a default broker configuration file created during the CUBRID installation, includes some default Broker 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_broker.conf file that is created by default during the installation.

[broker]

MASTER_SHM_ID           =30001

ADMIN_LOG_FILE          =log/broker/cubrid_broker.log

 

[%query_editor]

SERVICE                 =ON

BROKER_PORT             =30000

MIN_NUM_APPL_SERVER     =5

MAX_NUM_APPL_SERVER     =40

APPL_SERVER_SHM_ID      =30000

LOG_DIR                 =log/broker/sql_log

ERROR_LOG_DIR           =log/broker/error_log

SQL_LOG                 =ON

TIME_TO_KILL            =120

SESSION_TIMEOUT         =300

KEEP_CONNECTION         =AUTO

 

[%BROKER1]

SERVICE                 =ON

BROKER_PORT             =33000

MIN_NUM_APPL_SERVER     =5

MAX_NUM_APPL_SERVER     =40

APPL_SERVER_SHM_ID      =33000

LOG_DIR                 =log/broker/sql_log

ERROR_LOG_DIR           =log/broker/error_log

SQL_LOG                 =ON

TIME_TO_KILL            =120

SESSION_TIMEOUT         =300

KEEP_CONNECTION         =AUTO

Environment Variables related to the Broker Configuration File

You can specify the cubrid_broker.conf file location by using the CUBRID_BROKER_CONF_FILE variable to executing various Brokers with different configuration.