:meta-keywords: cubrid configure, cubrid conf, cubrid parameters, cubrid settings, cubrid.conf, cubrid default parameters :meta-description: How to configure CUBRID database behavior. Set system parameters for Connection, Memory, Disk, Concurrency/Lock, Logging, Transaction Processing, Query Execution, Utilities and High Availability. *********** ??? ?? *********** ? ???? ???? ???? ??? ??? ???? ??? ????? ?? ??? ?? ????, ?????? ?? ? ???? ??? ?? ??? ???? ?? ????? ??? ?? ????. .. FIXME: CUBRID ??? ?? ?? ??? ????? `CUBRID Manager Manual `_ ? ????. ? ??? ???? ?? ??? ??? ??. * ?????? ?? ?? * ??? ?? ?????? ?? ?? ====================== .. _scope-server-conf: ?????? ?? ??? ??? ?? ------------------------------------ CUBRID? ?????? ??, ???, CUBRID ???? ????, ? ????? ?? ?? ??? ????. ?????? ??? ??? ???? ?? ??? **cubrid.conf**\ ?? **$CUBRID/conf** ????? ????. **cubrid.conf** ? ???? ??? ????? ?????? ???? ???? ??? ??? ??? ??. ???, ?????? ?? ??? ???? ??? ?? ????. CUBRID ?????? ??? ?????/?? ??? ????. ????? ?? ?????? ???? ?? ?????? ?? ????? ????? ?????? ???? ?? ??? ????? ???. ?? ????? ?????? ?? ??? ???? ???? ???? ??? ????, ????? ????? ?? ??? ?? ?? ??? ?? ?? ? ??? ?? ??? ????. **cubrid.conf** ???? ??? ? ?? ?????? ??? ??? ????? ???? ??? ?? ????? ????, ?? ????, ?????/?? ????? ??? ? ??. ????? ????? ???? ?? ????? ?????? ???? ??????, ?? ????? ?? ????? ??? ??? ?? ??????. ?????/?? ????? ??? ?????? ????. .. note:: **cubrid.conf ??? ??? ??** **cubrid.conf** ??? **$CUBRID/conf** ????? ????, ?????? ? ??? **cubrid.conf** ?? ??? ???? ????. ?????? ?? ??? ?? ----------------------------- ?? ?? ?? ?? ^^^^^^^^^^^^^^^^^^^ **$CUBRID/conf** ????? ?? ??? ???? ?? ??( **cubrid.conf** )? ?? ???? ??? ????? ?? ? ??? ? ???, ????? ???? ??? ? ??. ?? ???? ????? ??? ? ???? ?? ??? ??? ??. * ???? ??? ?/???? ???? ???. * ???? ??? ???? ??? ??? ????? ??. * ???? ?? ???? ?? ?? ??(=)? ????, ?? ??? ? ??? ?? ??? ??? ? ??. * ???? ?? ???? ?? ??? ?? ???? ????. ??, ?? ???? ?? ??? ??? ???? ???? ????. SQL ?? ?? ^^^^^^^^^^^^^ SQL ?? ???? CSQL ?????? CUBRID ???? ?? ????? ??? ????? ?? ??? ? ??. ?, ??? ? ?? ????? ???? ???? ????. ??? ? ?? ????? :ref:`cubrid-conf`\ ? ????. :: SET SYSTEM PARAMETERS 'parameter_name=value [{; name=value}...]' *parameter_name* ? ??? ??? ??? ????? ???? ????, *value* ? ?? ????? ?? ????. ????(;)?? ???? ?? ?? ???? ?? ??? ? ??. ??? ??? ?? ??? ??? OID ??? ????, CSQL ??????? ???? ???? ???? ?? ??? 70?? ???? ????. .. code-block:: sql SET SYSTEM PARAMETERS 'index_scan_in_oid_order=1; csql_history_num=70'; *value* ? **DEFAULT** ?? ?? **call_stack_dump_activation_list** ????? ???? ?? ????? ????? ?????. .. code-block:: sql SET SYSTEM PARAMETERS 'lock_timeout=DEFAULT'; CSQL ?????? ?? ??? ?? ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ CSQL ????? ??? ?? ???(**;SEt**)? ???? ??? ????? ?? ??? ? ??. ?, ??? ? ?? ????? ???? ???? ????. ??? ? ?? ????? :ref:`cubrid-conf`\ ? ????. ??? ??? ??? ??? ???? ??? **block_ddl_statement** ????? 1? ???? ????. :: csql> ;se block_ddl_statement=1 === Set Param Input === block_ddl_statement=1 .. _cubrid-conf: cubrid.conf ?? ??? ?? ?? ???? ------------------------------------------ CUBRID? ?????? ??, ???, CUBRID ???? ????. ? ?? ??? ???? ?? ?? ?? ??? ??? ??, ?? **$CUBRID/conf** ????? ????. * ?????? ?? ?? ?? : **cubrid.conf** * ??? ?? ?? : **cubrid_broker.conf** * CUBRID ??? ?? ?? ?? : **cm.conf** **cubrid.conf** ??? CUBRID ?????? ??? ?? ??? ????? ???? ?? ??? ?????? ???? ???? ??? ??? ????. **cubrid.conf** ??? ??? ??? ??? ? ?? ??? ????? ???? ??? ??? ????. ?????? ?? ??? ???? ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ??? **cubrid.conf** ?? ??? ?? ??? ?????? ?? ??? ??????. ?? ??? "?? ??"? "????? ????"? ??? ????(CAS), CSQL, **cubrid** ????? ???? ????? ????, "?? ????"? DB ??(cub_server ????)? ???? ????? ????. ??? ??? :ref:`scope-server-conf` ? ????. **SET SYSTEM PARAMETERS** ???? CSQL ?????? ?? ??? **;set**\ ? ?? DB ?? ? ???? ??? ??? ??? ????? ??? ? ??. DB ???? ??? DBA? ?? ?? ??? ???? ???? ?? ??? ????, DBA? ?? ?? "??" ????(?? ??? "??" ??? ?? O? ????)? ?? ??? ????. ?? ??? "?? ??" ??? "??"? ????? cub_server ????? ??? ???, "?????"? ????? CAS, CSQL ?? ?????/?? ??(\-\-CS-mode)? ???? "cubrid" ????? ??? ???. "?????/??"? ????? cub_server ????? CAS, CSQL, "cubrid" ????? ?? ??? ???. ?? ??? "?? ??"? "??" ???? ??? ???? ??. "?? ??"? "??"? ????? "?? ??"? "??" ???? ??? ?? ?? ??? ??? ?? ????. * "?? ??"? "??"? ???? ? "?? ??"? "??"?? ??? ???? ?? DB ??? ????, ??? ???? ?? ?????? ??? ?? ????, DB? ????? ???? ??? ?? ????. * "?? ??"? "??"? ???? ? "?? ??"? "?????"?? "??" ????? ????, DB ?? ? ??? ?? ????. ?, ??? ??? ?? ?????? ??? ?? ????. ?? ??, **block_ddl_statement** ????? ?? **yes**\? ???? ??? ??? ?? ??????? DDL ?? ??? ? ?? ??. * "?? ??"? "??"? ???? ? "?? ??"? "?????/??"?? * "??" ????? ???? DB ?? ? ??? ?? ????. ?, ??? ??? ?? ?????? ??? ?? ????, ???? ??? ??? ???. ?? ??, **add_column_update_hard_default** ????? ?? **yes**\? ????, ??? ??? ?? ?????? NOT NULL ?????? ?? ??? ??? ?? ???(hard default)? ?? ??. * "??" ????? ???? ??? "?????" ?? "??" ?? ?? ????. ?? ??, **error_log_level** ????? "??" ?? "?????" ?? ?? ???? ?????, ? ?? "ERROR"?? "WARNING"?? ???? "??"(cub_server ????)? ?? ??? ??? "?????"(CAS ?? CSQL)?? WARNING? ????, ??? "?????"?? "ERROR"? ????. .. note:: ????? ?? ??? ????? cubrid.conf? ???? ??? ? DB ??? ??? ?? ????? ??. +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | ?? ?? | ???? ?? | ?? ?? | ?? | ?? | ??? | ?? ?? | +===============================+=====================================+=========================+=========+==========+================================+=================+ | :ref:`connection-parameters` | cubrid_port_id | ????? | | int | 1,523 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | check_peer_alive | ?????/?? | O | string | both | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | db_hosts | ????? | O | string | NULL | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | max_clients | ?? | | int | 100 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | tcp_keepalive | ?????/?? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | use_user_hosts | ?????/?? | | bool | off | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`memory-parameters` | data_buffer_size | ?? | | byte | 32,768 * | | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | index_scan_oid_buffer_size | ?? | | byte | 4 * | | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | max_agg_hash_size | ?? | | byte | 2,097,152(2M) | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | max_hash_list_scan_size | ?? | | byte | 8,388,608(8M) | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | sort_buffer_size | ?? | | byte | 128 * | | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | temp_file_memory_size_in_pages | ?? | | int | 4 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | thread_stacksize | ?? | | byte | 1,048,576 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`disk-parameters` | db_volume_size | ?? | | byte | 512M | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | dont_reuse_heap_file | ?? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | log_volume_size | ?? | | byte | 512M | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | temp_file_max_size_in_pages | ?? | | int | -1 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | temp_volume_path | ?? | | string | NULL | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | unfill_factor | ?? | | float | 0.1 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | volume_extension_path | ?? | | string | NULL | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | double_write_buffer_size | ?? | | byte | 2M | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | data_file_os_advise | ?? | | int | 0 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`error-parameters` | call_stack_dump_activation_list | ?????/?? | | string | DEFAULT | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | call_stack_dump_deactivation_list | ?????/?? | | string | NULL | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | call_stack_dump_on_error | ?????/?? | | bool | no | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | error_log | ?????/?? | | string | cub_client.err, cub_server.err | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | error_log_level | ?????/?? | | string | NOTIFICATION | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | error_log_warning | ?????/?? | | bool | no | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | error_log_size | ?????/?? | | int | 512M | DBA? ?? | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`lock-parameters` | deadlock_detection_interval_in_secs | ?? | | float | 1.0 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | isolation_level | ????? | O | int | 4 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | lock_escalation | ?? | | int | 100,000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | lock_timeout | ????? | O | msec | -1 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | rollback_on_lock_escalation | ?? | | bool | no | DBA? ?? | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`logging-parameters` | adaptive_flush_control | ?? | | bool | yes | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | background_archiving | ?? | | bool | yes | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | checkpoint_every_size | ?? | | byte | 100,000 * | | | | | | | | :ref:`log_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | checkpoint_interval | ?? | | msec | 6min | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | checkpoint_sleep_msecs | ?? | | msec | 1 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | force_remove_log_archives | ?? | | bool | yes | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | log_buffer_size | ?? | | byte | 16k * | | | | | | | | :ref:`log_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | log_max_archives | ?? | | int | INT_MAX | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | log_trace_flush_time | ?? | | msec | 0 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | max_flush_size_per_second | ?? | | byte | 10,000 * | DBA? ?? | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | remove_log_archive_interval_in_secs | ?? | | sec | 0 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | sync_on_flush_size | ?? | | byte | 200 * | DBA? ?? | | | | | | | :ref:`db_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | ddl_audit_log | ????? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | ddl_audit_log_size | ????? | | byte | 10M | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`transaction-parameters` | async_commit | ?? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | group_commit_interval_in_msecs | ?? | | msec | 0 | DBA? ?? | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`stmt-type-parameters` | add_column_update_hard_default | ?????/?? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | alter_table_change_type_strict | ?????/?? | O | bool | yes | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | allow_truncated_string | ?????/?? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | ansi_quotes | ????? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | block_ddl_statement | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | block_nowhere_statement | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | compat_numeric_division_scale | ?????/?? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | create_table_reuseoid | ????? | O | bool | yes | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | cte_max_recursions | ?????/?? | O | int | 2000 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | default_week_format | ?????/?? | O | int | 0 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | group_concat_max_len | ?? | O | byte | 1,024 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | intl_check_input_string | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | intl_collation | ????? | O | string | | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | intl_date_lang | ????? | O | string | | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | intl_number_lang | ????? | O | string | | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | json_max_array_idx | ?? | O | string | 65,536 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | no_backslash_escapes | ????? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | only_full_group_by | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | oracle_compat_number_behavior | ?? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | oracle_style_empty_string | ?????/?? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | pipes_as_concat | ????? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | plus_as_concat | ????? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | require_like_escape_character | ????? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | return_null_on_function_errors | ?????/?? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | string_max_size_bytes | ?????/?? | O | byte | 1,048,576 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | unicode_input_normalization | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | unicode_output_normalization | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | update_use_attribute_references | ????? | O | bool | no | ?? | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`thread-parameters` | thread_connection_pooling | ?? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | thread_connection_timeout_seconds | ?? | | int | 300 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | thread_worker_pooling | ?? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | thread_core_count | ?? | | int | ??? ?? ? | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | thread_worker_timeout_seconds | ?? | | int | 300 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | loaddb_worker_count | ?? | | int | 8 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`timezone-parameters` | server_timezone | ?? | | string | OS? ??? | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | timezone | ?????/?? | O | string | server_timezone? ? | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | tz_leap_second_support | ?? | | bool | no | ?? | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`plan-cache-parameters` | max_plan_cache_entries | ?????/?? | | int | 1,000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | max_plan_cache_clones | ?? | | int | 1,000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | xasl_cache_time_threshold_in_minutes| ?? | | int | 360 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | max_filter_pred_cache_entries | ?????/?? | | int | 1,000 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`query-cache-parameters` | max_query_cache_entries | ?? | | int | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | query_cache_size_in_pages | ?? | | int | 0 | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`utility-parameters` | backup_volume_max_size_bytes | ?? | | byte | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | communication_histogram | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | compactdb_page_reclaim_only | ?? | | int | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | csql_history_num | ????? | O | int | 50 | ?? | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`ha-parameters` | ha_mode | ?? | | string | off | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | :ref:`other-parameters` | access_ip_control | ?? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | access_ip_control_file | ?? | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | agg_hash_respect_order | ????? | O | bool | yes | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | auto_restart_server | ?? | O | bool | yes | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | enable_string_compression | ?????/?? | O | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | index_scan_in_oid_order | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | index_unfill_factor | ?? | | float | 0.05 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | java_stored_procedure | ?? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | java_stored_procedure_port | ?? | | int | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | java_stored_procedure_uds | ?? | | bool | yes | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | java_stored_procedure_jvm_options | ?? | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | multi_range_optimization_limit | ?? | O | int | 100 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | optimizer_enable_merge_join | ????? | O | bool | no | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | use_stat_estimation | ?? | | bool | no | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | server | ?? | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | service | ?? | | string | | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | session_state_timeout | ?? | | sec | 21,600 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | sort_limit_max_count | ????? | O | int | 1,000 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | sql_trace_slow | ?? | O | msec | -1 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | sql_trace_execution_plan | ?? | O | bool | no | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | use_orderby_sort_limit | ?? | O | bool | yes | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | vacuum_prefetch_log_mode | ?? | | int | 1 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | vacuum_prefetch_log_buffer_size | ?? | | int | 3200 * | DBA? ?? | | | | | | | :ref:`log_page_size ` | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | data_buffer_neighbor_flush_pages | ?? | | int | 8 | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | data_buffer_neighbor_flush_nondirty | ?? | | bool | no | DBA? ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | tde_keys_file_path | ?? | | string | NULL | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | tde_default_algorithm | ?? | | string | AES | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | recovery_progress_logging_interval | ?? | | int | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | supplemental_log | ?????/?? | | int | 0 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | regexp_engine | ?????/?? | | string | re2 | ?? | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | vacuum_ovfp_check_threshold | ?? | | int | 1000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | vacuum_ovfp_check_duration | ?? | | int | 45000 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | deduplicate_key_level | ?????/?? | | int | -1 | | | +-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ | | print_index_detail | ?????/?? | | bool | no | | +-------------------------------+-------------------------------------+-------------------------+---------+----------+--------------------------------+-----------------+ .. _lpg: * **log_page_size**: :ref:`?????? ??` ? **\-\-log-page-size** ???? ??? ?? ?? ??? ??. ???: 16KB. ?? ????? ?? ?? ??? ??? ????. ?? ?? checkpoint_every_size ? ?? 16KB? ??? ??? ??? ??? ?? 16KB? ?? ?? ??. .. _dpg: * **db_page_size**: :ref:`?????? ??` ? **\-\-db-page-size** ???? ??? DB ?? ??? ??. ???: 16KB. ?? ????? ?? ?? ??? ??? ????. ?? ?? data_buffer_size ? ?? 16KB? ??? ??? ??? ??? ?? 16KB? ?? ?? ??. ????? ??? ?? ^^^^^^^^^^^^^^^^^^^^^^ **cubrid.conf**\ ? ??? ????? ??? ?? ? ?? ???? ????. * CUBRID ???? ??? ? ?? : [service] ?? * ?? ??????? ???? ?? : [common] ?? * ? ??????? ????? ?? : [@<*database*>] ?? * cubrid ????? ?? ??(stand-alone, \-\-SA-mode)? ??? ?? ?? : [standalone] ?? ??? <*database*>? ????? ????? ??? ?????? ????, [common]? ??? ????? [@<*database*>]? ??? ????? ??? ?? [@<*database*>]? ??? ????? ?? ????. :: ..... [common] ..... sort_buffer_size=2M ..... [standalone] sort_buffer_size=256M ..... [standalone] ??? ??? ??? "cubrid"? ???? cubrid ?????? ?? ??? ??? ?? ????. ?? ??, ?? ?? ??? ???? \-\-CS-mode(???)?? DB? ??(cubrid database start db_name)?? "sort_buffer_size=2M"? ????. ??? DB? ???? "cubrid loaddb \-\-SA-mode"? ??? ?? "sort_buffer_size=256M"? ????. "cubrid loaddb \-\-SA-mode"? ??? ? ??? ?? ???? ?? ??(sort buffer)? ? ?? ??? ??? ????? ?? ???? ?? "loaddb" ?? ??? ??? ??. ?? ?? ???? ^^^^^^^^^^^^^^^^^^ CUBRID ?? ? ???? ?? ?????? ?? ?? ??(**cubrid.conf**)?? ?????? ?? ???? ? ??? ???? ? ?? ????? ????? ????. ???? ???? ?? ????? ???? ???? ?? ?? ?? ??/???? ???? ??. ??? **cubrid.conf** ?? ????. :: # 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=demodb,testdb # 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 > System Configuration > 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=256M # 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 *testdb* ? data_buffer_size? 128M?, max_clients? 10?? ???? ?? ?? ??? ?? ????. :: [service] service=server,broker,manager [common] data_buffer_size=512M log_buffer_size=256M sort_buffer_size=2M max_clients=100 # TCP port id for the CUBRID programs (used by all clients). cubrid_port_id=1523 [@testdb] data_buffer_size=128M max_clients=10 .. _connection-parameters: ?? ?? ???? ------------------ ??? ?????? ??? ??? ????? ? ????? ??? ?? ??? ?? ??? ??? ??. +--------------------+----------+-------------------+---------+---------+ | ???? ?? | ?? | ??? | ??? | ??? | +====================+==========+===================+=========+=========+ | cubrid_port_id | int | 1,523 | 1 | | +--------------------+----------+-------------------+---------+---------+ | check_peer_alive | string | both | | | +--------------------+----------+-------------------+---------+---------+ | db_hosts | string | NULL | | | +--------------------+----------+-------------------+---------+---------+ | max_clients | int | 100 | 10 | 4,000 | +--------------------+----------+-------------------+---------+---------+ | tcp_keepalive | bool | yes | | | +--------------------+----------+-------------------+---------+---------+ | use_user_hosts | bool | off | | | +--------------------+----------+-------------------+---------+---------+ **cubrid_port_id** **cubrid_port_id**\ ? ??? ????? ???? ??? ???? ?? ????? ???? **1,523**\ ??. CUBRID? ??? ???? ?? 1,523 ??? ???? ???, ???? ?? 1523 ??? ??? ???? ??? ????? ????? ??? ? ????, ??? ??? ??? ? ??? ?? ???? ??? ? ??. ?? ?? ?? ??? ???? ??, ???? ?? ??? ???? **cubrid_port_id** ? ???? ???? ??. .. _check_peer_alive: **check_peer_alive** **check_peer_alive**\ ? ????? ????? ?? ????? ?? ????? ?? ???? ??? ?? ??? ???? ??????. ???? **both**\ ??. ?? ????? ???? ????? ?????? ??? ?? ??(cub_cas) ????, ?? ?? ?? ????(copylogdb), ?? ?? ?? ????(applylogdb), CSQL ?????(csql) ?? ??. ?? ????? ????? ????? ??? ???? ? ????? ?? ???? ???? ? ????(?: 5? ??) ??? ?? ??? ??? ?? ???? ?? ????? ???? ??? ???. ?? ???? ???? ?? ???? ???? ???? ??? ??? ?? ????. ?? ?? ? ?? ??? ??? ??. * **both**: ?? ????? ????? ????? ECHO(7) ??? ????? ???? ????? ????? ?? ????? ????, ????? ????? ?? ????? ECHO(7) ??? ????? ???? ?? ????? ?? ????? ????(???). * **server_only**: ?? ????? ????? ????? ?? ????? ????. * **client_only**: ????? ????? ?? ????? ?? ????? ????. * **none**: ????? ????? ?? ???? ? ? ???? ?? ????? ???? ???. ??, ECHO(7) ??? ???(firewall) ???? ????? ?? ???? ?? ????? ????? ?? ??? ??? ??? ? ??? ????? ??? ??? ??? ? ????, none?? ???? ? ??? ???? ??. **db_hosts** **db_hosts**\ ? ??????? ??? ? ?? ?????? ?? ???? ?? ? ?? ??? ???? ?? ??????. ?? ??? ??? ? ? ??? ?? ??? ??? ????, ? ???? ?? ??? ?? ?? ??(:) ??? ???? ????. ? ?, ????? ???? ?? ??? ??? ????. ??? **db_hosts** ????? ???? ???? ??? **host1**, **host2**, **host3** ? ???? ??? ????. :: db_hosts="hosts1:hosts2:hosts3" ??, ?????? ?? ??? ??? ?????? ?? ?? ??(**databases.txt**)? ???? ??? ?? ???? 1???? ??? ????. ??? ???? ?????? ?? ??(**cubrid.conf**)? **db_hosts** ????? ???? ???? 2???? ??? ?? ??? ? ? ?? ?? ???? ??? ????. .. _max_clients: **max_clients** **max_clients**\ ? ?????? ??? ?? ??? ???? ?????(????? ??? ?? ??(CAS))? ?? ??? ???? ?? ??????. ?, **max_clients** ????? ?????? ?? ???? ?? ? ??? ??? ? ?? ?????? ?? ??? ????. ? ????? ???? **100**\ ??. CUBRID ???? ?? ??? ?? ????? ???? ?? ??? ???? **max_clients** ????(**cubrid.conf**) ? :ref:`MAX_NUM_APPL_SERVER ` ????(**cubrid_broker.conf**)? ??? ??? ???? ??. ?, **max_clients** ????? ?? ?????? ??? ???? ?? ?? ??? ????, **MAX_NUM_APPL_SERVER** ????? ?? ?? ???? ???? ?? ?? ??? ????. ?? ??, **cubrid_broker.conf** ???? [%query_editor]? **MAX_NUM_APPL_SERVER** ?? 50?? [%BROKER1]? **MAX_NUM_APPL_SERVER** ?? 50? ??? ?? 2?? ??? ?????? ??? ???? ??, ?????? ??? ???? ?? ?? ??? **max_clients** ? ?? ??? ?? ??? ? ??. * (? ??? ?? ? ?? 100?) * (??? ?? 2?) + (CSQL ?????? ?????? ?? ??, HA ?? ?? ????? ?? CUBRID ?? ????? ?????? ?? ?? ?? ?? ??? 10?) = 210 ??, HA ????? failover ??? ?? ?? ??? ?? ??? ??? ?????? ??? ??? ? ????, ?? ??????? ???? ?? ??? ??? **MAX_NUM_APPL_SERVER** ?? ?? ? ?? ?? ???? ??. ?????? ?????? ?? ??? ?? ?? **max_clients**\ ? ??? ?? ????? ??? ???? ????? ????. .. note:: Linux ????? max_clients ????? "ulimit -n" ??? ??? ???, "ulimit -n" ??? ???? ??? ??? ? ?? file descriptor? ?? ??? ????. file descriptor? ?? ? ??? ???? ??? ?????, "ulimit -n"? ??? max_clients? ???? ?? ???? ??. **tcp_keepalive** **tcp_keepalive**\ ? TCP ???? ????? SO_KEEPALIVE ??? ???? ??? ???? ?????, ???? **yes*\ ??. ? ?? **no**\ ?? ??? ??? ???? ?? ? ???? ???? ?? ???? ??? ?? ???? ??? ???? ?? ? DB ?? ? ??? ???? ??? ??? ? ??. **use_user_hosts** **use_user_hosts** ??? ????? CUBRID ????? ??? **????**, **IP ??** ?? ??? ?? ??? ??? ???? ?? ????. ???? **OFF** ??. * **???** ?? ???? ???, IP ?? ?? ????? (Linux? ?? **glibc**) * **CUBRID** ?? ???? **???/IP ?? ?? ?????** use_user_hosts=off (???) * ??? ?????? ???? IP ??, ????? ????. * ????? /etc/hosts ?? ??, DNS Query ?? ????. use_user_hosts=on * CUBRID ??? ?? ?????? ???? IP ??/????? ????. * **$CUBRID/conf/cubrid_hosts.conf** ??? ????, ????? IP ??? ???? * ???? /etc/hosts, /etc/nsswitch.conf ??? ?? ?? ?? ?? ?? ?? ????. .. warning:: **use_user_hosts** ????? ??? ?? ? ???? ????? ???? ???? ?? ? ????, ??? CUBRID ???? ??? ???? ???? ??. * **$CUBRID/conf/cubrid_hosts.conf** ??? ??? **/etc/hosts** ? ???? ??? ?? ? ?? ??? ??. * **IPv4** ?? ?? ???? (**IPv6** ? ???? ???). * **alias** ? ???? ???. :: 172.31.0.1 host1 alias1 alias2 * ?? ip ??? ?? ? ?? ?? ? ? ?? ?? {ip, hostname} ??? ????, ???? ????. :: 172.31.0.1 host1 172.31.0.1 alias1 172.31.0.1 alias2 * ? ? ??? IP? ??? ????? ??? ?? ? ? ?? ?? IP? ????. :: 172.31.0.1 host1 178.31.0.2 host1 * ??? $CUBRID/conf/cubrid_hosts.conf? ????. :: # # hosts file for CUBRID user specific host service # 127.0.0.1 localhost 172.31.0.1 node1 192.168.0.31 node4.kr # Seoul 192.168.2.31 node5.gov.or.kr # Daejeon .. warning:: $CUBRID/conf/cubrid_hosts.conf? ??? ?? CUBRID ????? ???? ? ???? ??, **? ?? ? ??? ??? ????.** ??, **localhost** ? **'hostname'** (Linux ??? ? hostname? ?? ???? ????)? ??? cubrid_hosts.conf? ???? ??. .. warning:: $CUBRID/conf/cubrid_hosts.conf ???? ??? ??? ??? ?? ??? ??? (Linux ???? ?? ??). * ??? ????? ?? ???, ??(0 ~ 9), ???('-'), ? (".") ??? ??? ? ??. * ??? ??? ? ??? ?????? ??. * ??? ??? ??? ??? ???? ????? ??. * FQDN (Fully Qualified Domain Name) ??? ????? ?? ???? (?: www.cubrid.com). ??? ?? ??? ??? ????. :: cubrid-dev1 CUB2.dev .. _memory-parameters: ??? ?? ???? -------------------- ??? ?????? ?? ?? ??????? ???? ???? ??? ????? ? ????? ??? ?? ??? ?? ??? ??? ??. +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | ???? ?? | ?? | ??? | ??? | ??? | +================================+========+===========================+===========================+===========================+ | data_buffer_size | byte | 32,768 * | 1,024 * | 2G(32??), | | | | :ref:`db_page_size ` | :ref:`db_page_size ` | INT_MAX * | | | | | | :ref:`db_page_size ` | | | | | | (64??) | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | index_scan_oid_buffer_size | byte | 4 * | 0.05 * | 16 * | | | | :ref:`db_page_size ` | :ref:`db_page_size ` | :ref:`db_page_size ` | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | max_agg_hash_size | byte | 2,097,152(2M) | 32,768(32K) | 134,217,728(128MB) | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | max_hash_list_scan_size | byte | 8,388,608(8M) | 0 | 128MB | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | sort_buffer_size | byte | 128 * | 1 * | 2G(32??), | | | | :ref:`db_page_size ` | :ref:`db_page_size ` | INT_MAX * | | | | | | :ref:`db_page_size ` | | | | | | (64??) | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | temp_file_memory_size_in_pages | int | 4 | 0 | 20 | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ | thread_stacksize | byte | 1,048,576 | 65,536 | | +--------------------------------+--------+---------------------------+---------------------------+---------------------------+ **data_buffer_size** **data_buffer_size**\ ? ?????? ??? ??? ?? ???? ??? ??? ??? ???? ?? ??????. ? ?? B, K, M, G, T? ??? ?? ? ???, ?? Bytes, Kilobytes, Megabytes, Gigabytes, Terabytes? ????. ??? ???? ??? ??? ????. ???? 32,768 * :ref:`db_page_size ` (db_page_size? 16K? ? **512M**) ??, ???? 1,024 * :ref:`db_page_size ` (db_page_size? 16K? ? **16M**)??. CUBRID 64?? ????? ???? INT_MAX * :ref:`db_page_size `\ ??. CUBRID 32?? ????? ???? **2G**\ ?? ????. **data_buffer_size** ????? ?? ??? ??? ???? ??? ???? ????? ??? I/O ??? ?? ? ??? ??? ??. ??, ? ????? ?? ?? ?? ???? ???? ??? ???? ????? ????? ?? ?? ?? ???(swapping)?? ??? ??? ? ??. **data_buffer_size** ????? ??? ??? ??? ??? ???? 2/3 ??? ??? ??? ?? ????. * ??? ??? ?? = ??? ?? ??(**data_buffer_size**) **index_scan_oid_buffer_size** **index_scan_oid_buffer_size**\ ? ??? ??? ??? ? OID ???? ?? ??? ?? ??? ??? ???? ?? ??????. K ??? ??? ? ???, KB(kilobytes)? ????. ??? ???? ??? ??? ????. ???? 4 * :ref:`db_page_size ` (db_page_size? 16K? ? **64K**)??. ???? 0.05 * :ref:`db_page_size ` (db_page_size? 16K? ? ? **1K**)??, ???? 16 * :ref:`db_page_size ` (db_page_size? 16K? ? **256K**)??. **index_scan_oid_buffer_size** ???? ?? ?????? ?? ? ??? ?? ???? ??? ???? OID ??? ??? ????, ??? OID??? ??? ??? ??? ?? ??? ???? ??? ???. ?? ???? **index_scan_oid_buffer_size** ???? ?? ??? ? ??. .. _max_agg_hash_size: **max_agg_hash_size** **max_agg_hash_size**\ ? ??? ???? ???? ?? ??? ???? ?? ??? ???? ? ?? ??? ??? ???? ??????. ???? **2,097,152**\ (2M), ???? 32,768(32K), ??? ???? 134,217,728(128MB)??. :ref:`NO_HASH_AGGREGATE ` ??? ????, ?? ?? ? ?? ??? ???? ?? ???. :ref:`agg_hash_respect_order `\ ? ????. .. _max_hash_list_scan_size: **max_hash_list_scan_size** **max_hash_list_scan_size**\ ? ???? ???? ???? ?? ???? ???? ?? ??? ???? ? ?? ??? ??? ???? ??????. ???? **8,388,608**\ (8M), ???? 0, ??? ???? 134,217,728(128MB)??. **max_hash_list_scan_size**\? 0?? ?????, :ref:`NO_HASH_LIST_SCAN ` ??? ????, ?? ?? ? ?? ??? ???? ?? ???. **sort_buffer_size** **sort_buffer_size**\ ? ??? ???? ???? ???? ??? ??? ???? ?? ??????. ??? ? ?????? ?? ???? ??? ?? ??? ????, ??? ??? ??? ????? ?? ???? ????. ??? ???? ???? SELECT ?? ?? ?? ??? ??? ?? ??? ????. ? ?? B, K, M, G, T? ??? ?? ? ???, ?? Bytes, Kilobytes, Megabytes, Gigabytes, Terabytes? ????. ??? ???? ??? ??? ????. ???? 128 * :ref:`db_page_size ` (db_page_size? 16K? ? **2M**)??, ???? 1 * :ref:`db_page_size ` (db_page_size? 16K? ? **16K**)??. **temp_file_memory_size_in_pages** **temp_file_memory_size_in_pages**\ ? ??? ?? ?? ??? ???? ?? ??? ??? ???? ?? ????? ???? **4**\ ??, ???? 20?? ????. * ??? ??? ?? = ?? ??? ?? ??? ?(**temp_file_memory_size_in_pages**) \* ?????? ??? ??(page size) * ?? ??? ?? ??? ? = **temp_file_memory_size_in_pages** ???? ??? * ?????? ??? ?? = ?????? ?? ? **cubrid createdb** ????? **-s** ??? ?? ??? ??? ?? ? ?? ??? ???? ??? ??? ??. * ?? ?? ?? ??(**temp_file_memory_size_in_pages** ??? ????? ?? ??? ???) * ??? ??? ??? ?? ??? ?? * ??? ?? ??? ?? ??? ???? ??? ?? ??? ?? ?? ?? -> ??? ?? -> ??? ??? ??? ?? ??? ????. **thread_stacksize** **thread_stacksize**\ ? ???? ?? ??? ???? ?? ????? ???? **1048576** ?????. **thread_stacksize** ????? ???? ????? ???? ?? ??? ??? ? ??. .. _disk-parameters: ??? ?? ???? -------------------- ??? ?????? ?? ?? ? ?? ??? ?? ??? ?? ????? ? ????? ??? ?? ??? ?? ??? ??? ??. +--------------------------------------+--------+---------+---------+---------+ | ???? ?? | ?? | ??? | ??? | ??? | +======================================+========+=========+=========+=========+ | db_volume_size | byte | 512M | 0 | 20G | +--------------------------------------+--------+---------+---------+---------+ | dont_reuse_heap_file | bool | no | | | +--------------------------------------+--------+---------+---------+---------+ | log_volume_size | byte | 512M | 20M | 4G | +--------------------------------------+--------+---------+---------+---------+ | temp_file_max_size_in_pages | int | -1 | | | +--------------------------------------+--------+---------+---------+---------+ | temp_volume_path | string | NULL | | | +--------------------------------------+--------+---------+---------+---------+ | unfill_factor | float | 0.1 | 0.0 | 0.3 | +--------------------------------------+--------+---------+---------+---------+ | volume_extension_path | string | NULL | | | +--------------------------------------+--------+---------+---------+---------+ | double_write_buffer_size | byte | 2M | 0 | 32M | +--------------------------------------+--------+---------+---------+---------+ | data_file_os_advise | int | 0 | 0 | 6 | +--------------------------------------+--------+---------+---------+---------+ **db_volume_size** **db_volume_size**\ ? ??? ?? ?? ???? ??????. ? ?? B, K, M, G, T? ??? ?? ? ???, ?? Bytes, Kilobytes, Megabytes, Gigabytes, Terabytes? ????. ??? ???? ??? ??? ????. ???? **512M**\ ??. * **cubrid createdb**\? **cubrid addvoldb** ?????? **\-\-db-volume-size** ??? ???? ? ???? ?????? ??? ?? ?? * ?????? ?? ??? ?? ???? ???? ???? ??? ?? ?? (?? ?? ??? ????? ????? ???? db_volume_size? ??? ?? ?? ?? ???? ???) .. note:: ?? ?? ??? ?? 64? ??? ??? ??? ????. ?? ??? ???? ??? ?? ?????, 64? ?? ??? ??? ?? 4k, 8k ?? 16k ??? ?? 16M, 32M ?? 64M??. **dont_reuse_heap_file** **dont_reuse_heap_file** ? ??? ??(**DROP TABLE**)? ?? ??? ? ??? ??? ??? ??(**CREATE TABLE**) ? ????? ??? ???? ?????, no? ???? ??? ? ??? ?????, yes? ???? ??? ? ??? ????? ???. ???? **no** ??. **log_volume_size** **log_volume_size**\? **cubrid createdb** ?????? **\-\-log-volume-size** ??? ????? ? ?? ?? ??? ?? ??? ???? ??????. ? ?? B, K, M, G, T? ??? ?? ? ???, ?? Bytes, Kilobytes, Megabytes, Gigabytes, Terabytes? ????. ??? ???? ??? ??? ????. ???? **512M** ??. **temp_file_max_size_in_pages** **temp_file_max_size_in_pages** ? ??? ??? ??? ? ?? ?? ??? ?? ???? ??????. ???? **-1** ?? ??? ??? ??? ??? ??? ??? ? ??? ???. ??? ?? ???? ?? ??? ??? ? ??? ??? ?? ???? ??? ???? ?? ? ??? ??? ? ??. ? ????? **0**\?? ???? ??? ??? ???? ???? ??? ???? **cubrid addvoldb** ????? ??? ??? ???? ???? ?? ??? ??? ??? ???? ??. ??? ??? ??? ????? ??. :ref:`temporary-volumes` **temp_volume_path** **temp_volume_path**\ ? ??? ????? ?? ??? ??? ???? ???? ??? ?? ??(temporary temp volume)? ????? ???? ????? ???? ?????? ?? ?? ??? ?? ????. **unfill_factor** **unfill_factor**\ ? ??? ??? ???? ?(heap) ???? ???? ??? ??? ??? ???? ?? ????? ???? **0.1**\ ? 10%? ?? ??? ????. ?????, ???? ???? ???? ???? ?????, ???? ?? ???? ? ???? ???? ?? ???? ?? ??? ???? ??? ???? ?? ???? ?????? ??? ??? ??? ? ??. ?? ???? ??? **unfill_factor** ????? ?? ? ??? ?? ??? ??? ? ??, ???? 0.3(30%)?? ????. ??, ??? ??? ?? ???? ?? ????????? ? ????? 0.0?? ???? ??? ??? ?? ? ??? ??? ???? ?? ? ??, **unfill_factor** ????? ?? ???? ????? ?? ???? ???? ???(**0.1**)? ????. **volume_extension_path** **volume_extension_path**\ ? **cubrid addvoldb** ????? ?? ??? ??? ? ?? ??? ??? ???? **-F** ??? ???? ?? ??? ??? ??? ???? ??????. ???? ?????? ?? ?? ??? ?? ????. **double_write_buffer_size** **double_write_buffer_size**\ ? ?? ?? ?? (Double Write Buffer, DWB)? ???? ??? ??? ??? ? ?? ??????. ? ??? 0?? ?????? Partial I/O? ???? ?? DWB? ???? ?? ? ??. ????? DWB? ????? ???, ???? **2M** ??. **data_file_os_advise** **data_file_os_advise**\ ? I/O ??? ????? ?? ???? ??? ?? ??????. ???? ???? *posix_fadvise()* ???? ????. (???? ?? ??? ??? `?? `_ ? ????.) +-----------------------------------+-------------------------------------------+ | ???? ? | posix_fadvise ??? | +===================================+===========================================+ | 0 | 0 | +-----------------------------------+-------------------------------------------+ | 1 | POSIX_FADV_NORMAL | +-----------------------------------+-------------------------------------------+ | 2 | POSIX_FADV_SEQUENTIAL | +-----------------------------------+-------------------------------------------+ | 3 | POSIX_FADV_RANDOM | +-----------------------------------+-------------------------------------------+ | 4 | POSIX_FADV_NOREUSE | +-----------------------------------+-------------------------------------------+ | 5 | POSIX_FADV_WILLNEED | +-----------------------------------+-------------------------------------------+ | 6 | POSIX_FADV_DONTNEED | +-----------------------------------+-------------------------------------------+ .. warning:: posix_fadvise ???? ??? ??? ??? ??? ???? ??. ???? ??? ?? ??? ?? ?? ??? ?? ??? ?? ??? ???? ?? ??. ???? ?????? ??? ?? ???? ?? ?? ??. .. _error-parameters: ?? ??? ?? ???? ------------------------- ??? CUBRID? ?? ???? ?? ???? ??? ?? ????? ? ????? ??? ?? ??? ?? ??? ??? ??. +-----------------------------------+--------+--------------------------------+ | ???? ?? | ?? | ??? | +===================================+========+================================+ | call_stack_dump_activation_list | string | DEFAULT | +-----------------------------------+--------+--------------------------------+ | call_stack_dump_deactivation_list | string | NULL | +-----------------------------------+--------+--------------------------------+ | call_stack_dump_on_error | bool | no | +-----------------------------------+--------+--------------------------------+ | error_log | string | cub_client.err, cub_server.err | +-----------------------------------+--------+--------------------------------+ | error_log_level | string | NOTIFICATION | +-----------------------------------+--------+--------------------------------+ | error_log_warning | bool | no | +-----------------------------------+--------+--------------------------------+ | error_log_size | int | 512M | +-----------------------------------+--------+--------------------------------+ **call_stack_dump_activation_list** **call_stack_dump_activation_list**\ ? ?? ??? ?? ?-??? ?? ?? ?? ??($CUBRID/log/server ????? ??)? ???? ??? ??? ????, ????? ?-??? ??? ?? ?? ??? ???? ?? ??????. ???, **call_stack_dump_activation_list** ????? **call_stack_dump_on_error** ? ?? **no** ? ???? ??? ??. ?? ???? ?? ?? ???? "DEFAULT" ?????, ?? ???? ????. "DEFAULT" ???? ?? ?? ??? ?? ??? ? ??. +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | ?? ?? | ?? ??? | +===========+===============================================================================================================================================+ | -2 | Internal system failure: no more specific information is available. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -7 | Trying to format disk volume xxx with an incorrect value xxx for number of pages. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -13 | An I/O error occurred while reading page xxx of volume xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -14 | An I/O error occurred while writing page xxx of volume xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -17 | Internal error: fetching deallocated pageid xxx of volume xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -19 | Internal error: pageptr = xxx of page xxx of volume xxx is not fixed. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -21 | Internal error: unknown sector xxx of volume xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -22 | Internal error: unknown page xxx of volume xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -45 | Slot xxx on page xxx of volume xxx is allocated to an anchored record. A new record cannot be inserted here. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -46 | Internal error: slot xxx on page xxx of volume xxx is not allocated. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -48 | Accessing deleted object xxx|xxx|xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -50 | Internal error: relocation record of object xxx|xxx|xxx may be corrupted. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -51 | Internal error: object xxx|xxx|xxx may be corrupted. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -52 | Internal error: object overflow address xxx|xxx|xxx may be corrupted. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -76 | Your transaction (index xxx, xxx@xxx|xxx) timed out waiting on xxx on page xxx|xxx. You are waiting for user(s) xxx to release the page lock. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -78 | Internal error: an I/O error occurred while reading logical log page xxx (physical page xxx) of xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -79 | Internal error: an I/O error occurred while writing logical log page xxx (physical page xxx) of xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -81 | Internal error: logical log page xxx may be corrupted. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -90 | Redo logging is always a page level logging operation. A data page pointer must be given as part of the address. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -96 | Media recovery may be needed on volume xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -97 | Internal error: unable to find log page xxx in log archives. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -313 | Object buffer underflow while reading. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -314 | Object buffer overflow while writing. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -407 | Unknown key xxx referenced in B+tree index {vfid: (xxx, xxx), rt_pgid: xxx, key_type: xxx}. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -414 | Unknown class identifier: xxx|xxx|xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -415 | Invalid class identifier: xxx|xxx|xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -416 | Unknown representation identifier: xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -417 | Invalid representation identifier: xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -583 | Trying to allocate an invalid number (xxx) of pages. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -603 | Internal Error: Sector/page table of file VFID xxx|xxx seems corrupted. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -836 | LATCH ON PAGE(xxx|xxx) TIMEDOUT | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -859 | LATCH ON PAGE(xxx|xxx) ABORTED | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -890 | Partition failed. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -891 | Appropriate partition does not exist. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -976 | Internal error: Table size overflow (allocated size: xxx, accessed size: xxx) at file table page xxx|xxx(volume xxx) | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -1040 | HA generic: xxx. | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | -1075 | Descending index scan aborted because of lower priority on B+tree with index identifier: (vfid = (xxx, xxx), rt_pgid: xxx). | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------+ ??? -115, -116?? ?? ??? ???? ?-?? ??? ????? ????? ??? ????. :: call_stack_dump_on_error= no call_stack_dump_activation_list=-115,-116 ??? -115, -116?? ?? ??? "DEFAULT" ?? ??? ?? ?-?? ??? ????? ????? ??? ????. :: call_stack_dump_on_error= no call_stack_dump_activation_list=-115,-116, DEFAULT **call_stack_dump_deactivation_list** **call_stack_dump_deactivation_list**\ ? ?? ??? ?? ?-?? ??? ??? ????, ????? ?-??? ???? ?? ?? ?? ??? ???? ?? ??????. ???, **call_stack_dump_deactivation_list** ????? **call_stack_dump_on_error** ? ?? **yes** ? ???? ??? ??. ??? -115, -116?? ?? ??? ??? ??? ??? ??? ?-?? ??? ???? ?? ????? ??? ????. :: call_stack_dump_on_error= yes call_stack_dump_deactivation_list=-115,-116 **call_stack_dump_on_error** **call_stack_dump_on_error** ? ?????? ???? ??? ???? ? ?-??? ???? ???? ?? ??????. "no" ? ???? ?? ??? ??? ?-??? ???? ??, "yes" ? ???? ?? ??? ??? ???? ????. ???? **no** ??. **error_log** **error_log** ? ?????? ??? ??? ???? ??, ?? ??? ???? ?? ??? ???? ?? ??/????? ??????. ?? ??? ???? ???? ?? ??? *__