Introduction to CUBRID Manual 
Performance Tuning 
cubrid_broker.conf Configuration File and Default Parameters 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 |
|---|---|---|---|---|
|
ACCESS_CONTROL |
bool |
no |
|
|
|
ACCESS_CONTROL_FILE |
string |
|
|
|
|
ADMIN_LOG_FILE |
string |
log/broker/cubrid_broker.log |
|
|
|
MASTER_SHM_ID |
int |
30001 |
|
|
|
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 |
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.