CUBRID consists of the Database Server, the Broker and the CUBRID Manager. The name of the configuration file for each component is as follows. These files are all located in the $CUBRID/conf directory.
cubrid.conf is a configuration file that sets system parameters for the CUBRID Database Server and determines overall performance and operation of the database system. In the cubrid.conf file, some important parameters needed for system installation are provided, having their default values.
The following are Database Server system parameters that can be used in the cubrid.conf configuration file. For the scope of client and server parameters, see Scope of Database Server Configuration.
You can change the parameters that are capable of dynamically changing the setting value through the SET SYSTEM PARAMETERS statement or a session command of the CSQL Interpreter, ;set dynamically. If you are a DBA, you can change parameters regardless of the applied classification. However, if you are not a DBA, you can only change client parameters.
Purpose |
Parameter Name |
Scope |
Type |
Default Value |
Dynamic Changes |
---|---|---|---|---|---|
connection-related |
cubrid_port_id |
client parameter |
int |
1523 |
|
db_hosts |
client parameter |
string |
NULL |
available |
|
max_clients |
server parameter |
int |
100 |
|
|
memory-related |
data_buffer_size |
server parameter |
int |
512M |
|
index_scan_oid_buffer_size |
server parameter |
int |
64K |
|
|
sort_buffer_size |
server parameter |
int |
2M |
|
|
temp_file_memory_size_in_pages |
server parameter |
int |
4 |
|
|
thread_stack_size |
server parameter |
int |
1048576 |
|
|
disk-related |
db_volume_size |
server parameter |
int |
512M |
|
dont_reuse_heap_file |
server parameter |
bool |
no |
|
|
temp_file_max_size_in_pages |
server parameter |
int |
-1 |
|
|
temp_volume_path |
server parameter |
string |
NULL |
|
|
unfill_factor |
server parameter |
float |
0.1 |
|
|
volume_extension_path |
server parameter |
string |
NULL |
|
|
log_volume_size |
server parameter |
int |
512M |
|
|
error message-related |
call_stack_dump_activation_list |
client/server parameter |
string |
NULL |
available |
call_stack_dump_deactivation_list |
client/server parameter |
string |
NULL |
available |
|
call_stack_dump_on_error |
client/server parameter |
bool |
no |
available |
|
error_log |
client/server parameter |
string |
cub_client.err, cub_server.err |
|
|
error_log_level |
client/server parameter |
string |
SYNTAX |
available |
|
error_log_warning |
client/server parameter |
bool |
no |
available |
|
error_log_size |
client/server parameter |
int |
8000000 |
available |
|
concurrency/lock-related |
deadlock_detection_interval_in_secs |
server parameter |
float |
1.0 |
available |
isolation_level |
client parameter |
int |
3 |
available |
|
lock_escalation |
server parameter |
int |
100000 |
|
|
lock_timeout_in_secs |
client parameter |
int |
-1 |
available |
|
lock_timeout_message_type |
server parameter |
int |
0 |
available |
|
logging-related |
adaptive_flush_control |
server parameter |
bool |
yes |
available |
background_archiving |
server parameter |
bool |
yes |
available |
|
checkpoint_every_npages |
server parameter |
int |
10000 |
|
|
checkpoint_interval_in_mins |
server parameter |
int |
720 |
available |
|
force_remove_log_archives |
server parameter |
bool |
yes |
available |
|
log_buffer_size |
server parameter |
int |
2M |
|
|
log_max_archives |
server parameter |
int |
INT_MAX |
available |
|
max_flush_pages_per_second |
server parameter |
int |
10000 |
available |
|
media_failure_support |
server parameter |
bool |
yes |
|
|
page_flush_interval_in_msecs |
server parameter |
int |
0 |
available |
|
sync_on_nflush |
server parameter |
int |
200 |
available |
|
transaction processing-related |
async_commit |
server parameter |
bool |
no |
|
group_commit_interval_in_msecs |
server parameter |
int |
0 |
available |
|
statement/type-related |
add_column_update_hard_default |
client parameter |
bool |
no |
available |
alter_table_change_type_strict |
client/server parameter |
bool |
no |
available |
|
ansi_quotes |
client parameter |
bool |
yes |
|
|
block_ddl_statement |
client parameter |
bool |
no |
available |
|
block_nowhere_statement |
client parameter |
bool |
no |
available |
|
compat_numeric_division_scale |
client/server parameter |
bool |
no |
available |
|
default_week_format |
서버/client parameter |
int |
0 |
available |
|
group_concat_max_len |
server parameter |
int |
1024 |
available |
|
intl_mbs_support |
client parameter |
bool |
no |
|
|
no_backslash_escapes |
client parameter |
bool |
yes |
|
|
only_full_group_by |
client parameter |
bool |
no |
available |
|
oracle_style_empty_string |
client parameter |
bool |
no |
|
|
pipes_as_concat |
client parameter |
bool |
yes |
|
|
plus_as_concat |
client parameter |
bool |
yes |
|
|
require_like_escape_character |
client parameter |
bool |
no |
|
|
return_null_on_function_errors |
client/server parameter |
bool |
no |
available |
|
query cache-related |
max_plan_cache_entries |
client/server parameter |
int |
1000 |
|
max_query_cache_entries |
server parameter |
int |
-1 |
|
|
query_cache_mode |
server parameter |
int |
0 |
|
|
query_cache_size_in_pages |
server parameter |
int |
-1 |
|
|
utility-related |
backup_volume_max_size_bytes |
server parameter |
int |
-1 |
|
communication_histogram |
client parameter |
bool |
no |
available |
|
compactdb_page_reclaim_only |
server parameter |
int |
0 |
|
|
csql_history_num |
client parameter |
int |
50 |
available |
|
HA-related |
ha_mode |
server parameter |
string |
off |
|
others |
access_ip_control |
server parameter |
bool |
no |
|
access_ip_control_file |
server parameter |
string |
|
|
|
auto_restart_server |
server parameter |
bool |
yes |
available |
|
index_scan_in_oid_order |
client parameter |
bool |
no |
available |
|
index_unfill_factor |
server parameter |
float |
0.05 |
|
|
insert_execution_mode |
client parameter |
int |
1 |
|
|
java_stored_procedure |
server parameter |
bool |
no |
|
|
multi_range_optimization_limit |
server parameter |
int |
100 |
available |
|
pthread_scope_process |
server parameter |
bool |
yes |
|
|
server |
server parameter |
string |
|
|
|
service |
server parameter |
string |
|
|
|
session_state_timeout |
server parameter |
int |
21600 |
|
|
single_byte_compare |
server parameter |
bool |
no |
|
|
use_orderby_sort_limit |
server parameter |
bool |
yes |
available |
Parameters specified in cubrid.conf have the following three sections:
Where <database> is the name of the database to which each parameter applies. If a parameter configured in [common] is the same as the one configured in [@<database>], the one configured in [@<database>] is applied.
cubrid.conf, a default database configuration file created during the CUBRID installation, includes some default Database Server 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.conf file.
# Copyright (C) 2008 Search Solution Corporation. All rights reserved by Search Solution.
#
# $Id$
#
# cubrid.conf#
# For complete information on parameters, see the CUBRID
# Database Administration Guide chapter on System Parameters
# Service section - a section for 'cubrid service' command
[service]
# The list of processes to be started automatically by 'cubrid service start' command
# Any combinations are available with server, broker and manager.
service=server,broker,manager
# The list of database servers in all by 'cubrid service start' command.
# This property is effective only when the above 'service' property contains 'server' keyword.
#server=server, broker, manager
# Common section - properties for all databases
# This section will be applied before other database specific sections.
[common]
# Read the manual for detailed description of system parameters
# Manual > Performance Tuning > Database Server Configuration > Default Parameters
# Size of data buffer are using K, M, G, T unit
data_buffer_size=512M
# Size of log buffer are using K, M, G, T unit
log_buffer_size=4M
# Size of sort buffer are using K, M, G, T unit
# The sort buffer should be allocated per thread.
# So, the max size of the sort buffer is sort_buffer_size * max_clients.
sort_buffer_size=2M
# The maximum number of concurrent client connections the server will accept.
# This value also means the total # of concurrent transactions.
max_clients=100
# TCP port id for the CUBRID programs (used by all clients).
cubrid_port_id=1523