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 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.
MAX_PREPARED_STMT_COUNT
int
2000 (min. : 1)
ACCESS_CONTROL
bool
no
ACCESS_CONTROL_FILE
string
|
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) |
|
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 |
|
CCI_DEFAULT_AUTOCOMMIT |
string |
OFF |
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.