MySQL5.6 동적 시스템 변수

5.1.5.2 동적 시스템 변수

많은 서버 시스템 변수는 동적이며 SET GLOBAL 또는 SET SESSION 을 사용하면 런타임에 설정할 수 있습니다. 또한 SELECT 를 사용하여 이러한 값을 얻을 수 있습니다. 섹션 5.1.5 "시스템 변수 사용" 을 참조하십시오.

다음 표에는 모든 동적 시스템 변수의 전체 목록을 보여줍니다. 마지막 컬럼은 각 변수에 GLOBAL 또는 SESSION 중이 (또는 모두) 적용되는지를 보여줍니다. 테이블에는 SET 문에서 설정할 수있는 세션 옵션도 나열되어 있습니다. 이 옵션은 섹션 5.1.4 "서버 시스템 변수" 에 설명이 있습니다.

"string"형의 변수는 문자열 값을 취합니다. "numeric"형의 변수는 수치를 취합니다. "boolean"형의 변수는 0, ON , OFF 로 설정할 수 있습니다. (이 명령 행 또는 옵션 파일에서 설정하는 경우는 수치를 사용합니다.) "enumeration"라고 기재되어있는 변수는 일반적으로 그 변수에 사용할 수있는 값 중 하나에 설정되지만 목적하는 열거 값에 해당하는 숫자도 설정할 수 있습니다. 열거 된 시스템 변수에 대해 먼저 열거 값은 0입니다. 이것은 ENUM 컬럼과 달리이 경우 첫 번째 열거 값은 1이됩니다.

표 5.4 동적 변수의 요약

변수 이름	변수 유형	변수 범위
`audit_log_connection_policy`	enumeration	`GLOBAL`
`audit_log_exclude_accounts`	string	`GLOBAL`
`audit_log_flush`	boolean	`GLOBAL`
`audit_log_include_accounts`	string	`GLOBAL`
`audit_log_policy`	enumeration	`GLOBAL`
`audit_log_rotate_on_size`	numeric	`GLOBAL`
`audit_log_statement_policy`	enumeration	`GLOBAL`
`auto_increment_increment`	numeric	`GLOBAL` \| `SESSION`
`auto_increment_offset`	numeric	`GLOBAL` \| `SESSION`
`autocommit`	boolean	`GLOBAL` \| `SESSION`
`automatic_sp_privileges`	boolean	`GLOBAL`
`big_tables`	boolean	`GLOBAL` \| `SESSION`
`binlog_cache_size`	numeric	`GLOBAL`
`binlog_checksum`	string	`GLOBAL`
`binlog_direct_non_transactional_updates`	boolean	`GLOBAL` \| `SESSION`
`binlog_error_action`	enumeration	`GLOBAL` \| `SESSION`
`binlog_format`	enumeration	`GLOBAL` \| `SESSION`
`binlog_max_flush_queue_time`	numeric	`GLOBAL`
`binlog_order_commits`	boolean	`GLOBAL`
`binlog_row_image=image_type`	enumeration	`GLOBAL` \| `SESSION`
`binlog_rows_query_log_events`	boolean	`GLOBAL` \| `SESSION`
`binlog_stmt_cache_size`	numeric	`GLOBAL`
`binlogging_impossible_mode`	enumeration	`GLOBAL` \| `SESSION`
`block_encryption_mode`	string	`GLOBAL` \| `SESSION`
`bulk_insert_buffer_size`	numeric	`GLOBAL` \| `SESSION`
`character_set_client`	string	`GLOBAL` \| `SESSION`
`character_set_connection`	string	`GLOBAL` \| `SESSION`
`character_set_database`	string	`GLOBAL` \| `SESSION`
`character_set_filesystem`	string	`GLOBAL` \| `SESSION`
`character_set_results`	string	`GLOBAL` \| `SESSION`
`character_set_server`	string	`GLOBAL` \| `SESSION`
`collation_connection`	string	`GLOBAL` \| `SESSION`
`collation_database`	string	`GLOBAL` \| `SESSION`
`collation_server`	string	`GLOBAL` \| `SESSION`
`completion_type`	enumeration	`GLOBAL` \| `SESSION`
`concurrent_insert`	enumeration	`GLOBAL`
`connect_timeout`	numeric	`GLOBAL`
`debug`	string	`GLOBAL` \| `SESSION`
`debug_sync`	string	`SESSION`
`default_storage_engine`	enumeration	`GLOBAL` \| `SESSION`
`default_tmp_storage_engine`	enumeration	`GLOBAL` \| `SESSION`
`default_week_format`	numeric	`GLOBAL` \| `SESSION`
`delay_key_write`	enumeration	`GLOBAL`
`delayed_insert_limit`	numeric	`GLOBAL`
`delayed_insert_timeout`	numeric	`GLOBAL`
`delayed_queue_size`	numeric	`GLOBAL`
`div_precision_increment`	numeric	`GLOBAL` \| `SESSION`
`end_markers_in_json`	boolean	`GLOBAL` \| `SESSION`
`engine_condition_pushdown`	boolean	`GLOBAL` \| `SESSION`
`eq_range_index_dive_limit`	numeric	`GLOBAL` \| `SESSION`
`event_scheduler`	enumeration	`GLOBAL`
`expire_logs_days`	numeric	`GLOBAL`
`flush`	boolean	`GLOBAL`
`flush_time`	numeric	`GLOBAL`
`foreign_key_checks`	boolean	`GLOBAL` \| `SESSION`
`ft_boolean_syntax`	string	`GLOBAL`
`general_log`	boolean	`GLOBAL`
`general_log_file`	filename	`GLOBAL`
`group_concat_max_len`	numeric	`GLOBAL` \| `SESSION`
`gtid_next`	enumeration	`SESSION`
`gtid_purged`	string	`GLOBAL`
`host_cache_size`	numeric	`GLOBAL`
`identity`	numeric	`SESSION`
`init_connect`	string	`GLOBAL`
`init_slave`	string	`GLOBAL`
`innodb_adaptive_flushing`	boolean	`GLOBAL`
`innodb_adaptive_flushing_lwm`	numeric	`GLOBAL`
`innodb_adaptive_hash_index`	boolean	`GLOBAL`
`innodb_adaptive_max_sleep_delay`	numeric	`GLOBAL`
`innodb_api_bk_commit_interval`	numeric	`GLOBAL`
`innodb_api_trx_level`	numeric	`GLOBAL`
`innodb_autoextend_increment`	numeric	`GLOBAL`
`innodb_buffer_pool_dump_at_shutdown`	boolean	`GLOBAL`
`innodb_buffer_pool_dump_now`	boolean	`GLOBAL`
`innodb_buffer_pool_filename`	filename	`GLOBAL`
`innodb_buffer_pool_load_abort`	boolean	`GLOBAL`
`innodb_buffer_pool_load_now`	boolean	`GLOBAL`
`innodb_change_buffer_max_size`	numeric	`GLOBAL`
`innodb_change_buffering`	enumeration	`GLOBAL`
`innodb_checksum_algorithm`	enumeration	`GLOBAL`
`innodb_cmp_per_index_enabled`	boolean	`GLOBAL`
`innodb_commit_concurrency`	numeric	`GLOBAL`
`innodb_compression_failure_threshold_pct`	numeric	`GLOBAL`
`innodb_compression_level`	numeric	`GLOBAL`
`innodb_compression_pad_pct_max`	numeric	`GLOBAL`
`innodb_concurrency_tickets`	numeric	`GLOBAL`
`innodb_disable_sort_file_cache`	boolean	`GLOBAL`
`innodb_fast_shutdown`	numeric	`GLOBAL`
`innodb_file_format`	string	`GLOBAL`
`innodb_file_format_max`	string	`GLOBAL`
`innodb_file_per_table`	boolean	`GLOBAL`
`innodb_flush_log_at_timeout`	numeric	`GLOBAL`
`innodb_flush_log_at_trx_commit`	enumeration	`GLOBAL`
`innodb_flush_neighbors`	enumeration	`GLOBAL`
`innodb_flushing_avg_loops`	numeric	`GLOBAL`
`innodb_ft_aux_table`	string	`GLOBAL`
`innodb_ft_enable_diag_print`	boolean	`GLOBAL`
`innodb_ft_enable_stopword`	boolean	`GLOBAL`
`innodb_ft_num_word_optimize`	numeric	`GLOBAL`
`innodb_ft_result_cache_limit`	numeric	`GLOBAL`
`innodb_ft_server_stopword_table`	string	`GLOBAL`
`innodb_ft_user_stopword_table`	string	`GLOBAL` \| `SESSION`
`innodb_io_capacity`	numeric	`GLOBAL`
`innodb_io_capacity_max`	numeric	`GLOBAL`
`innodb_large_prefix`	boolean	`GLOBAL`
`innodb_lock_wait_timeout`	numeric	`GLOBAL` \| `SESSION`
`innodb_log_compressed_pages`	boolean	`GLOBAL`
`innodb_lru_scan_depth`	numeric	`GLOBAL`
`innodb_max_dirty_pages_pct`	numeric	`GLOBAL`
`innodb_max_dirty_pages_pct_lwm`	numeric	`GLOBAL`
`innodb_max_purge_lag`	numeric	`GLOBAL`
`innodb_max_purge_lag_delay`	numeric	`GLOBAL`
`innodb_monitor_disable`	string	`GLOBAL`
`innodb_monitor_enable`	string	`GLOBAL`
`innodb_monitor_reset`	string	`GLOBAL`
`innodb_monitor_reset_all`	string	`GLOBAL`
`innodb_old_blocks_pct`	numeric	`GLOBAL`
`innodb_old_blocks_time`	numeric	`GLOBAL`
`innodb_online_alter_log_max_size`	numeric	`GLOBAL`
`innodb_optimize_fulltext_only`	boolean	`GLOBAL`
`innodb_print_all_deadlocks`	boolean	`GLOBAL`
`innodb_purge_batch_size`	numeric	`GLOBAL`
`innodb_random_read_ahead`	boolean	`GLOBAL`
`innodb_read_ahead_threshold`	numeric	`GLOBAL`
`innodb_replication_delay`	numeric	`GLOBAL`
`innodb_rollback_segments`	numeric	`GLOBAL`
`innodb_spin_wait_delay`	numeric	`GLOBAL`
`innodb_stats_auto_recalc`	boolean	`GLOBAL`
`innodb_stats_method`	enumeration	`GLOBAL`
`innodb_stats_on_metadata`	boolean	`GLOBAL`
`innodb_stats_persistent`	boolean	`GLOBAL`
`innodb_stats_persistent_sample_pages`	numeric	`GLOBAL`
`innodb_stats_sample_pages`	numeric	`GLOBAL`
`innodb_stats_transient_sample_pages`	numeric	`GLOBAL`
`innodb_status_output`	boolean	`GLOBAL`
`innodb_status_output_locks`	boolean	`GLOBAL`
`innodb_strict_mode`	boolean	`GLOBAL` \| `SESSION`
`innodb_support_xa`	boolean	`GLOBAL` \| `SESSION`
`innodb_sync_spin_loops`	numeric	`GLOBAL`
`innodb_table_locks`	boolean	`GLOBAL` \| `SESSION`
`innodb_thread_concurrency`	numeric	`GLOBAL`
`innodb_thread_sleep_delay`	numeric	`GLOBAL`
`innodb_undo_logs`	numeric	`GLOBAL`
`insert_id`	numeric	`SESSION`
`interactive_timeout`	numeric	`GLOBAL` \| `SESSION`
`join_buffer_size`	numeric	`GLOBAL` \| `SESSION`
`keep_files_on_create`	boolean	`GLOBAL` \| `SESSION`
`key_buffer_size`	numeric	`GLOBAL`
`key_cache_age_threshold`	numeric	`GLOBAL`
`key_cache_block_size`	numeric	`GLOBAL`
`key_cache_division_limit`	numeric	`GLOBAL`
`last_insert_id`	numeric	`SESSION`
`lc_messages`	string	`GLOBAL` \| `SESSION`
`lc_time_names`	string	`GLOBAL` \| `SESSION`
`local_infile`	boolean	`GLOBAL`
`lock_wait_timeout`	numeric	`GLOBAL` \| `SESSION`
`log`	filename	`GLOBAL`
`log_bin_trust_function_creators`	boolean	`GLOBAL`
`log_output`	set	`GLOBAL`
`log_queries_not_using_indexes`	boolean	`GLOBAL`
`log_slow_admin_statements`	boolean	`GLOBAL`
`log_slow_queries`	boolean	`GLOBAL`
`log_slow_slave_statements`	boolean	`GLOBAL`
`log_throttle_queries_not_using_indexes`	numeric	`GLOBAL`
`log_warnings`	numeric	`GLOBAL`
`long_query_time`	numeric	`GLOBAL` \| `SESSION`
`low_priority_updates`	boolean	`GLOBAL` \| `SESSION`
`master_info_repository`	string	`GLOBAL`
`master_verify_checksum`	boolean	`GLOBAL`
`max_allowed_packet`	numeric	`GLOBAL`
`max_binlog_cache_size`	numeric	`GLOBAL`
`max_binlog_size`	numeric	`GLOBAL`
`max_binlog_stmt_cache_size`	numeric	`GLOBAL`
`max_connect_errors`	numeric	`GLOBAL`
`max_connections`	integer	`GLOBAL`
`max_delayed_threads`	numeric	`GLOBAL` \| `SESSION`
`max_error_count`	numeric	`GLOBAL` \| `SESSION`
`max_heap_table_size`	numeric	`GLOBAL` \| `SESSION`
`max_insert_delayed_threads`	numeric	`GLOBAL` \| `SESSION`
`max_join_size`	numeric	`GLOBAL` \| `SESSION`
`max_length_for_sort_data`	numeric	`GLOBAL` \| `SESSION`
`max_prepared_stmt_count`	numeric	`GLOBAL`
`max_relay_log_size`	numeric	`GLOBAL`
`max_seeks_for_key`	numeric	`GLOBAL` \| `SESSION`
`max_sort_length`	numeric	`GLOBAL` \| `SESSION`
`max_sp_recursion_depth`	numeric	`GLOBAL` \| `SESSION`
`max_user_connections`	numeric	`GLOBAL` \| `SESSION`
`max_write_lock_count`	numeric	`GLOBAL`
`min_examined_row_limit`	numeric	`GLOBAL` \| `SESSION`
`myisam_data_pointer_size`	numeric	`GLOBAL`
`myisam_max_sort_file_size`	numeric	`GLOBAL`
`myisam_repair_threads`	numeric	`GLOBAL` \| `SESSION`
`myisam_sort_buffer_size`	numeric	`GLOBAL` \| `SESSION`
`myisam_stats_method`	enumeration	`GLOBAL` \| `SESSION`
`myisam_use_mmap`	boolean	`GLOBAL`
`ndb_autoincrement_prefetch_sz`	numeric	`GLOBAL` \| `SESSION`
`ndb_blob_read_batch_bytes`	numeric	`GLOBAL` \| `SESSION`
`ndb_blob_write_batch_bytes`	numeric	`GLOBAL` \| `SESSION`
`ndb_cache_check_time`	numeric	`GLOBAL`
`ndb_deferred_constraints`	integer	`GLOBAL` \| `SESSION`
`ndb_deferred_constraints`	integer	`GLOBAL` \| `SESSION`
`ndb_distribution`	enumeration	`GLOBAL`
`ndb_distribution={KEYHASH\|LINHASH}`	enumeration	`GLOBAL`
`ndb_eventbuffer_max_alloc`	numeric	`GLOBAL`
`ndb_extra_logging`	numeric	`GLOBAL`
`ndb_force_send`	boolean	`GLOBAL` \| `SESSION`
`ndb_index_stat_cache_entries`	numeric	`GLOBAL` \| `SESSION`
`ndb_index_stat_enable`	boolean	`GLOBAL` \| `SESSION`
`ndb_index_stat_option`	string	`GLOBAL` \| `SESSION`
`ndb_index_stat_update_freq`	numeric	`GLOBAL` \| `SESSION`
`ndb_join_pushdown`	boolean	`GLOBAL` \| `SESSION`
`ndb_log_bin`	boolean	`GLOBAL` \| `SESSION`
`ndb_log_binlog_index`	boolean	`GLOBAL`
`ndb_log_empty_epochs`	boolean	`GLOBAL`
`ndb_log_empty_epochs`	boolean	`GLOBAL`
`ndb_log_exclusive_reads`	boolean	`GLOBAL` \| `SESSION`
`ndb_log_exclusive_reads`	boolean	`GLOBAL` \| `SESSION`
`ndb_log_update_as_write`	boolean	`GLOBAL`
`ndb_log_updated_only`	boolean	`GLOBAL`
`ndb_optimization_delay`	numeric	`GLOBAL`
`ndb_recv_thread_cpu_mask`	bitmap	`GLOBAL`
`ndb_show_foreign_key_mock_tables`	boolean	`GLOBAL`
`ndb_slave_last_conflict_epoch`	enumeration	`GLOBAL`
`ndb_table_no_logging`	boolean	`SESSION`
`ndb_table_temporary`	boolean	`SESSION`
`ndb_use_exact_count`	boolean	`GLOBAL` \| `SESSION`
`ndb_use_transactions`	boolean	`GLOBAL` \| `SESSION`
`ndbinfo_max_bytes`	numeric	`GLOBAL` \| `SESSION`
`ndbinfo_max_rows`	numeric	`GLOBAL` \| `SESSION`
`ndbinfo_offline`	boolean	`GLOBAL`
`ndbinfo_show_hidden`	boolean	`GLOBAL` \| `SESSION`
`ndbinfo_table_prefix`	string	`GLOBAL` \| `SESSION`
`net_buffer_length`	numeric	`GLOBAL` \| `SESSION`
`net_read_timeout`	numeric	`GLOBAL` \| `SESSION`
`net_retry_count`	numeric	`GLOBAL` \| `SESSION`
`net_write_timeout`	numeric	`GLOBAL` \| `SESSION`
`new`	boolean	`GLOBAL` \| `SESSION`
`old_alter_table`	boolean	`GLOBAL` \| `SESSION`
`old_passwords`	enumeration	`GLOBAL` \| `SESSION`
`optimizer_join_cache_level`	numeric	`GLOBAL` \| `SESSION`
`optimizer_prune_level`	boolean	`GLOBAL` \| `SESSION`
`optimizer_search_depth`	numeric	`GLOBAL` \| `SESSION`
`optimizer_switch`	set	`GLOBAL` \| `SESSION`
`optimizer_trace`	string	`GLOBAL` \| `SESSION`
`optimizer_trace_features`	string	`GLOBAL` \| `SESSION`
`optimizer_trace_limit`	numeric	`GLOBAL` \| `SESSION`
`optimizer_trace_max_mem_size`	numeric	`GLOBAL` \| `SESSION`
`optimizer_trace_offset`	numeric	`GLOBAL` \| `SESSION`
`preload_buffer_size`	numeric	`GLOBAL` \| `SESSION`
`profiling`	boolean	`GLOBAL` \| `SESSION`
`profiling_history_size`	numeric	`GLOBAL` \| `SESSION`
`pseudo_slave_mode`	numeric	`SESSION`
`pseudo_thread_id`	numeric	`SESSION`
`query_alloc_block_size`	numeric	`GLOBAL` \| `SESSION`
`query_cache_limit`	numeric	`GLOBAL`
`query_cache_min_res_unit`	numeric	`GLOBAL`
`query_cache_size`	numeric	`GLOBAL`
`query_cache_type`	enumeration	`GLOBAL` \| `SESSION`
`query_cache_wlock_invalidate`	boolean	`GLOBAL` \| `SESSION`
`query_prealloc_size`	numeric	`GLOBAL` \| `SESSION`
`rand_seed1`	numeric	`SESSION`
`rand_seed2`	numeric	`SESSION`
`range_alloc_block_size`	numeric	`GLOBAL` \| `SESSION`
`read_buffer_size`	numeric	`GLOBAL` \| `SESSION`
`read_only`	boolean	`GLOBAL`
`read_rnd_buffer_size`	numeric	`GLOBAL` \| `SESSION`
`relay_log_info_repository`	string	`GLOBAL`
`relay_log_purge`	boolean	`GLOBAL`
`relay_log_recovery`	boolean	`GLOBAL`
`rpl_semi_sync_master_enabled`	boolean	`GLOBAL`
`rpl_semi_sync_master_timeout`	numeric	`GLOBAL`
`rpl_semi_sync_master_trace_level`	numeric	`GLOBAL`
`rpl_semi_sync_master_wait_no_slave`	boolean	`GLOBAL`
`rpl_semi_sync_slave_enabled`	boolean	`GLOBAL`
`rpl_semi_sync_slave_trace_level`	numeric	`GLOBAL`
`rpl_stop_slave_timeout`	integer	`GLOBAL`
`secure_auth`	boolean	`GLOBAL`
`server_id`	numeric	`GLOBAL`
`slave_allow_batching`	boolean	`GLOBAL`
`slave_checkpoint_group=#`	numeric	`GLOBAL`
`slave_checkpoint_period=#`	numeric	`GLOBAL`
`slave_compressed_protocol`	boolean	`GLOBAL`
`slave_exec_mode`	enumeration	`GLOBAL`
`slave_max_allowed_packet`	numeric	`GLOBAL`
`slave_net_timeout`	numeric	`GLOBAL`
`slave_parallel_workers`	numeric	`GLOBAL`
`slave_pending_jobs_size_max`	numeric	`GLOBAL`
`slave_rows_search_algorithms=list`	set	`GLOBAL`
`slave_sql_verify_checksum`	boolean	`GLOBAL`
`slave_transaction_retries`	numeric	`GLOBAL`
`slow_launch_time`	numeric	`GLOBAL`
`slow_query_log`	boolean	`GLOBAL`
`slow_query_log_file`	filename	`GLOBAL`
`sort_buffer_size`	numeric	`GLOBAL` \| `SESSION`
`sql_auto_is_null`	boolean	`GLOBAL` \| `SESSION`
`sql_big_selects`	boolean	`GLOBAL` \| `SESSION`
`sql_big_tables`	boolean	`GLOBAL` \| `SESSION`
`sql_buffer_result`	boolean	`GLOBAL` \| `SESSION`
`sql_log_bin`	boolean	`GLOBAL` \| `SESSION`
`sql_log_off`	boolean	`GLOBAL` \| `SESSION`
`sql_low_priority_updates`	boolean	`GLOBAL` \| `SESSION`
`sql_max_join_size`	numeric	`GLOBAL` \| `SESSION`
`sql_mode`	set	`GLOBAL` \| `SESSION`
`sql_notes`	boolean	`GLOBAL` \| `SESSION`
`sql_quote_show_create`	boolean	`GLOBAL` \| `SESSION`
`sql_safe_updates`	boolean	`GLOBAL` \| `SESSION`
`sql_select_limit`	numeric	`GLOBAL` \| `SESSION`
`sql_slave_skip_counter`	numeric	`GLOBAL`
`sql_warnings`	boolean	`GLOBAL` \| `SESSION`
`storage_engine`	enumeration	`GLOBAL` \| `SESSION`
`stored_program_cache`	numeric	`GLOBAL`
`sync_binlog`	numeric	`GLOBAL`
`sync_frm`	boolean	`GLOBAL`
`sync_master_info`	numeric	`GLOBAL`
`sync_relay_log`	numeric	`GLOBAL`
`sync_relay_log_info`	numeric	`GLOBAL`
`table_definition_cache`	numeric	`GLOBAL`
`table_open_cache`	numeric	`GLOBAL`
`thread_cache_size`	numeric	`GLOBAL`
`thread_pool_high_priority_connection`	numeric	`GLOBAL` \| `SESSION`
`thread_pool_max_unused_threads`	numeric	`GLOBAL`
`thread_pool_prio_kickup_timer`	numeric	`GLOBAL` \| `SESSION`
`thread_pool_stall_limit`	numeric	`GLOBAL`
`time_zone`	string	`GLOBAL` \| `SESSION`
`timed_mutexes`	boolean	`GLOBAL`
`timestamp`	numeric	`SESSION`
`tmp_table_size`	numeric	`GLOBAL` \| `SESSION`
`transaction_alloc_block_size`	numeric	`GLOBAL` \| `SESSION`
`transaction_allow_batching`	boolean	`SESSION`
`transaction_prealloc_size`	numeric	`GLOBAL` \| `SESSION`
`tx_isolation`	enumeration	`GLOBAL` \| `SESSION`
`tx_read_only`	boolean	`GLOBAL` \| `SESSION`
`unique_checks`	boolean	`GLOBAL` \| `SESSION`
`updatable_views_with_limit`	boolean	`GLOBAL` \| `SESSION`
`validate_password_length`	numeric	`GLOBAL`
`validate_password_mixed_case_count`	numeric	`GLOBAL`
`validate_password_number_count`	numeric	`GLOBAL`
`validate_password_policy`	enumeration	`GLOBAL`
`validate_password_special_char_count`	numeric	`GLOBAL`
`wait_timeout`	numeric	`GLOBAL` \| `SESSION`