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 table shows the broker parameters available in the broker configuration file (cubrid_broker.conf). For details, see Common Parameters and Parameter by Broker. You can temporarily change the parameter of which configuration values can be dynamically changed by using the broker_changer utility. To apply configuration values even after restarting all brokers with cubrid broker restart, you should change the values in the cubrid_broker.conf file.

Category

Parameter Name

Type

Default Value

Dynamic Changes

Common Parameters

ACCESS_CONTROL

bool

no

 

ACCESS_CONTROL_FILE

string

 

 

ADMIN_LOG_FILE

string

log/broker/cubrid_broker.log

 

MASTER_SHM_ID

int

30001

 

Parameter by Broker

ACCESS_LIST

string

-

 

ACCESS_LOG

string

ON

available

ACCESS_MODE

string

RW

available

APPL_SERVER

string

CAS

 

APPL_SERVER_MAX_SIZE

int

32-bit Windows: 40
64-bit Windows: 80
Linux: 0

available

APPL_SERVER_MAX_SIZE_HARD_LIMIT

int

1024

available

APPL_SERVER_PORT

int

BROKER_PORT+1

 

APPL_SERVER_SHM_ID

int

30000

 

AUTO_ADD_APPL_SERVER

string

ON

 

BROKER_PORT

int

30000 (max.: 65535)

 

CCI_DEFAULT_AUTOCOMMIT

string

ON

 

ERROR_LOG_DIR

string

log/broker/error_log

 

KEEP_CONNECTION

string

AUTO

available

LOG_BACKUP

string

OFF

available

LOG_DIR

string

log/broker/sql_log

 

LONG_QUERY_TIME

int

60

available

LONG_TRANSACTION_TIME

int

60

available

MAX_NUM_APPL_SERVER

int

40

 

MIN_NUM_APPL_SERVER

int

5

 

MAX_PREPARED_STMT_COUNT

int

2000 (min.: 1)

 

MAX_QUERY_TIMEOUT

int

0 (max.: 86400 (sec.))

available

MAX_STRING_LENGTH

int

-1

 

PREFERRED_HOSTS

string

-

 

SERVICE

string

ON

 

SESSION_TIMEOUT

int

300

 

SLOW_LOG

string

ON

available

SLOW_LOG_DIR

string

log/broker/sql_log

 

SOURCE_ENV

string

cubrid.env

 

SQL_LOG

string

ON

available

SQL_LOG_MAX_SIZE

int

100000

available

STATEMENT_POOLING

string

ON

available

TIME_TO_KILL

int

120

available

Default Parameters

The cubrid_broker.conf file, the default broker configuration file created when installing CUBRID, includes some parameters that must be modified by default. If you want to modify the values of parameters that are not included in the configuration file by default, you can add or modify one yourself.

The following is the content of the cubrid_broker.conf file provided by default.

[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

Broker Configuration File Related Environment Variables

You can specify the location of broker configuration file (cubrid_broker.conf) file by using the CUBRID_BROKER_CONF_FILE variable. The variable is used when executing several brokers with different configuration.