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