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 | 



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

Type

Parameter Name

Type

Default Value

Common

ACCESS_CONTROL

bool

no

ACCESS_CONTROL_FILE

string

 

ADMIN_LOG_FILE

string

log/broker/cubrid_broker.log

MASTER_SHM_ID

int

30001

Broker

ACCESS_LIST

string

-

ACCESS_LOG

string

ON

ACCESS_MODE

string

RW

APPL_SERVER

string

CAS

APPL_SERVER_MAX_SIZE

int

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

APPL_SERVER_MAX_SIZE_HARD_LIMIT

int

1024

APPL_SERVER_PORT

int

BROKER_PORT+1

APPL_SERVER_SHM_ID

int

30000

BROKER_PORT

int

30000 (max. : 65535)

CCI_DEFAULT_AUTOCOMMIT

string

ON

CCI_PCONNECT

string

OFF

ERROR_LOG_DIR

string

log/broker/error_log

KEEP_CONNECTION

string

AUTO

LOG_BACKUP

string

OFF

LOG_DIR

string

log/broker/sql_log

LONG_QUERY_TIME

int

60

LONG_TRANSACTION_TIME

int

40

MAX_NUM_APPL_SERVER

int

40

MAX_PREPARED_STMT_COUNT

int

2000 (min. : 1)

MAX_QUERY_TIMEOUT

int

0 (max. : 86400 (seconds))

MAX_STRING_LENGTH

int

-1

MIN_NUM_APPL_SERVER

int

5

PREFERRED_HOSTS

string

-

SELECT_AUTO_COMMIT

string

OFF

SERVICE

string

ON

SESSION_TIMEOUT

int

300

SLOW_LOG

string

ON

SLOW_LOG_DIR

string

log/broker/sql_log

SOURCE_ENV

string

cubrid.env

SQL_LOG

string

ON

SQL_LOG_MAX_SIZE

int

100000

STATEMENT_POOLING

string

ON

TIME_TO_KILL

int

120

Default Parameters

The cubrid_broker.conf file, a default Broker configuration file created during CUBRID installation, 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.