• 흐림동두천 1.0℃
  • 흐림강릉 1.3℃
  • 서울 3.2℃
  • 대전 3.3℃
  • 대구 6.8℃
  • 울산 6.6℃
  • 광주 8.3℃
  • 부산 7.7℃
  • 흐림고창 6.7℃
  • 흐림제주 10.7℃
  • 흐림강화 2.2℃
  • 흐림보은 3.2℃
  • 흐림금산 4.4℃
  • 흐림강진군 8.7℃
  • 흐림경주시 6.7℃
  • 흐림거제 8.0℃
기상청 제공

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