5.1.5.2 動的システム変数

多くのサーバーシステム変数は動的で、SET GLOBAL または SET SESSION を使用すると実行時に設定できます。また、SELECT を使用してこれらの値を取得することも可能です。セクション5.1.5「システム変数の使用」を参照してください。

次の表に、すべての動的システム変数の完全なリストを示します。最後のカラムは、それぞれの変数に対して GLOBAL または SESSION のいずれが (あるいは両方が) 適用されるかを示します。テーブルには、SET ステートメントで設定できるセッションオプションもリストしています。これらのオプションについては、セクション5.1.4「サーバーシステム変数」に説明があります。

「string」 型の変数は文字列値を取ります。「numeric」 型の変数は数値を取ります。「boolean」 型の変数は、0、1、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