• 구름많음동두천 17.6℃
  • 맑음강릉 20.3℃
  • 구름많음서울 18.2℃
  • 맑음대전 18.5℃
  • 맑음대구 19.0℃
  • 맑음울산 20.0℃
  • 맑음광주 18.4℃
  • 맑음부산 19.1℃
  • 맑음고창 18.4℃
  • 맑음제주 21.3℃
  • 구름많음강화 15.3℃
  • 구름조금보은 17.3℃
  • 맑음금산 18.1℃
  • 맑음강진군 18.7℃
  • 구름조금경주시 20.7℃
  • 맑음거제 19.7℃
기상청 제공

cubrid broker 설정값 모음


# cubrid broker 주요 설정값 모음

[%BROKER1]
SERVICE                 =ON
BROKER_PORT             =33000
MIN_NUM_APPL_SERVER     =10
MAX_NUM_APPL_SERVER     =100
APPL_SERVER_SHM_ID      =33000
LOG_DIR                 =log/broker/sql_log
ERROR_LOG_DIR           =log/broker/error_log
AUTO_ADD_APPL_SERVER =ON
SQL_LOG                 =NOTICE
TIME_TO_KILL            =100
SESSION_TIMEOUT         =10
KEEP_CONNECTION         =AUTO
SQL_LOG_MAX_SIZE        =50000
LONG_QUERY_TIME         =0.8
LONG_TRANSACTION_TIME   =0.8


# 브로커 제공 파라미터(기본값)

MASTER_SHM_ID

int

30001

ADMIN_LOG_FILE

string

log/broker/cubrid_broker.log

SERVICE

string

ON

BROKER_PORT

int

30000(최대값 : 65535)

MIN_NUM_APPL_SERVER

int

5

MAX_NUM_APPL_SERVER

int

40

APPL_SERVER_SHM_ID

int

30000

APPL_SERVER_MAX_SIZE

int

Windows : 40 (32 bit), 80 (64 bit)
Linux : 0

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

MAX_PREPARED_STMT_COUNT

int

2000(최소값: 1)

ACCESS_CONTROL

bool

no

ACCESS_CONTROL_FILE

string