• 구름조금동두천 7.4℃
  • 맑음강릉 9.6℃
  • 연무서울 9.2℃
  • 연무대전 10.0℃
  • 맑음대구 9.1℃
  • 맑음울산 9.5℃
  • 연무광주 9.6℃
  • 맑음부산 10.8℃
  • 맑음고창 7.1℃
  • 구름많음제주 10.7℃
  • 맑음강화 7.8℃
  • 구름많음보은 9.0℃
  • 구름조금금산 10.3℃
  • 맑음강진군 8.4℃
  • 맑음경주시 8.8℃
  • 맑음거제 10.4℃
기상청 제공

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