mysql 5.6参数列表

Table 5.3 System Variable Summary

NameCmd-LineOption FileSystem VarVar ScopeDynamicaudit_log_buffer_sizeYesYesYesGlobalNoaudit_log_connection_policyYesYesYesGlobalYesaudit_log_current_session  YesBothNoaudit_log_exclude_accountsYesYesYesGlobalYesaudit_log_fileYesYesYesGlobalNoaudit_log_flush  YesGlobalYesaudit_log_formatYesYesYesGlobalNoaudit_log_include_accountsYesYesYesGlobalYesaudit_log_policyYesYesYesGlobalVariesaudit_log_rotate_on_sizeYesYesYesGlobalYesaudit_log_statement_policyYesYesYesGlobalYesaudit_log_strategyYesYesYesGlobalNoauto_increment_increment  YesBothYesauto_increment_offset  YesBothYesautocommitYesYesYesBothYesautomatic_sp_privileges  YesGlobalYesavoid_temporal_upgradeYesYesYesGlobalYesback_log  YesGlobalNobasedirYesYesYesGlobalNobig-tablesYesYes  Yes- Variable: big_tables  YesBothYesbind-addressYesYes  No- Variable: bind_address  YesGlobalNobinlog_cache_sizeYesYesYesGlobalYesbinlog_checksum  YesGlobalYesbinlog_direct_non_transactional_updatesYesYesYesBothYesbinlog_error_actionYesYesYesBothYesbinlog-formatYesYes  Yes- Variable: binlog_format  YesBothYesbinlog_gtid_simple_recoveryYesYesYesGlobalNobinlog_max_flush_queue_time  YesGlobalYesbinlog_order_commits  YesGlobalYesbinlog_row_imageYesYesYesBothYesbinlog_rows_query_log_events  YesBothYesbinlog_stmt_cache_sizeYesYesYesGlobalYesbinlogging_impossible_modeYesYesYesBothYesblock_encryption_modeYesYesYesBothYesbulk_insert_buffer_sizeYesYesYesBothYescharacter_set_client  YesBothYescharacter_set_connection  YesBothYescharacter_set_database^[a]  YesBothYescharacter-set-filesystemYesYes  Yes- Variable: character_set_filesystem  YesBothYescharacter_set_results  YesBothYescharacter-set-serverYesYes  Yes- Variable: character_set_server  YesBothYescharacter_set_system  YesGlobalNocharacter-sets-dirYesYes  No- Variable: character_sets_dir  YesGlobalNocollation_connection  YesBothYescollation_database^[b]  YesBothYescollation-serverYesYes  Yes- Variable: collation_server  YesBothYescompletion_typeYesYesYesBothYesconcurrent_insertYesYesYesGlobalYesconnect_timeoutYesYesYesGlobalYescore_file  YesGlobalNocreate_old_temporalsYesYesYesGlobalNodaemon_memcached_enable_binlogYesYesYesGlobalNodaemon_memcached_engine_lib_nameYesYesYesGlobalNodaemon_memcached_engine_lib_pathYesYesYesGlobalNodaemon_memcached_optionYesYesYesGlobalNodaemon_memcached_r_batch_sizeYesYesYesGlobalNodaemon_memcached_w_batch_sizeYesYesYesGlobalNodatadirYesYesYesGlobalNodate_format  YesGlobalNodatetime_format  YesGlobalNodebugYesYesYesBothYesdebug_sync  YesSessionYesdefault-storage-engineYesYes  Yes- Variable: default_storage_engine  YesBothYesdefault_tmp_storage_engineYesYesYesBothYesdefault_week_formatYesYesYesBothYesdelay-key-writeYesYes  Yes- Variable: delay_key_write  YesGlobalYesdelayed_insert_limitYesYesYesGlobalYesdelayed_insert_timeoutYesYesYesGlobalYesdelayed_queue_sizeYesYesYesGlobalYesdisable-gtid-unsafe-statementsYesYesYesGlobalNodisable_gtid_unsafe_statementsYesYesYesGlobalNodisconnect_on_expired_passwordYesYesYesSessionNodiv_precision_incrementYesYesYesBothYesend_markers_in_json  YesBothYesenforce-gtid-consistencyYesYesYesGlobalNoenforce_gtid_consistencyYesYesYesGlobalNoengine-condition-pushdownYesYes  Yes- Variable: engine_condition_pushdown  YesBothYeseq_range_index_dive_limit  YesBothYeserror_count  YesSessionNoevent-schedulerYesYes  Yes- Variable: event_scheduler  YesGlobalYesexpire_logs_daysYesYesYesGlobalYesexplicit_defaults_for_timestampYesYesYesBothNoexternal_user  YesSessionNoflushYesYesYesGlobalYesflush_timeYesYesYesGlobalYesforeign_key_checks  YesBothYesft_boolean_syntaxYesYesYesGlobalYesft_max_word_lenYesYesYesGlobalNoft_min_word_lenYesYesYesGlobalNoft_query_expansion_limitYesYesYesGlobalNoft_stopword_fileYesYesYesGlobalNogeneral-logYesYes  Yes- Variable: general_log  YesGlobalYesgeneral_log_fileYesYesYesGlobalYesgroup_concat_max_lenYesYesYesBothYesgtid_done  YesBothNogtid_executed  YesBothNogtid_lost  YesGlobalNogtid-modeYesYes  No- Variable: gtid_mode  YesGlobalNogtid_mode  YesGlobalNogtid_next  YesSessionYesgtid_owned  YesBothNogtid_purged  YesGlobalYeshave_compress  YesGlobalNohave_crypt  YesGlobalNohave_csv  YesGlobalNohave_dynamic_loading  YesGlobalNohave_geometry  YesGlobalNohave_innodb  YesGlobalNohave_ndbcluster  YesGlobalNohave_openssl  YesGlobalNohave_partitioning  YesGlobalNohave_profiling  YesGlobalNohave_query_cache  YesGlobalNohave_rtree_keys  YesGlobalNohave_ssl  YesGlobalNohave_symlink  YesGlobalNohost_cache_size  YesGlobalYeshostname  YesGlobalNoidentity  YesSessionYesignore-builtin-innodbYesYes  No- Variable: ignore_builtin_innodb  YesGlobalNoignore_db_dirs  YesGlobalNoinit_connectYesYesYesGlobalYesinit-fileYesYes  No- Variable: init_file  YesGlobalNoinit_slaveYesYesYesGlobalYesinnodb_adaptive_flushingYesYesYesGlobalYesinnodb_adaptive_flushing_lwmYesYesYesGlobalYesinnodb_adaptive_hash_indexYesYesYesGlobalYesinnodb_adaptive_max_sleep_delayYesYesYesGlobalYesinnodb_additional_mem_pool_sizeYesYesYesGlobalNoinnodb_api_bk_commit_intervalYesYesYesGlobalYesinnodb_api_disable_rowlockYesYesYesGlobalNoinnodb_api_enable_binlogYesYesYesGlobalNoinnodb_api_enable_mdlYesYesYesGlobalNoinnodb_api_trx_levelYesYesYesGlobalYesinnodb_autoextend_incrementYesYesYesGlobalYesinnodb_autoinc_lock_modeYesYesYesGlobalNoinnodb_buffer_pool_dump_at_shutdownYesYesYesGlobalYesinnodb_buffer_pool_dump_nowYesYesYesGlobalYesinnodb_buffer_pool_filenameYesYesYesGlobalYesinnodb_buffer_pool_instancesYesYesYesGlobalNoinnodb_buffer_pool_load_abortYesYesYesGlobalYesinnodb_buffer_pool_load_at_startupYesYesYesGlobalNoinnodb_buffer_pool_load_nowYesYesYesGlobalYesinnodb_buffer_pool_sizeYesYesYesGlobalNoinnodb_change_buffer_max_sizeYesYesYesGlobalYesinnodb_change_bufferingYesYesYesGlobalYesinnodb_change_buffering_debugYesYesYesGlobalYesinnodb_checksum_algorithmYesYesYesGlobalYesinnodb_checksumsYesYesYesGlobalNoinnodb_cmp_per_index_enabledYesYesYesGlobalYesinnodb_commit_concurrencyYesYesYesGlobalYesinnodb_compression_failure_threshold_pctYesYesYesGlobalYesinnodb_compression_levelYesYesYesGlobalYesinnodb_compression_pad_pct_maxYesYesYesGlobalYesinnodb_concurrency_ticketsYesYesYesGlobalYesinnodb_data_file_pathYesYesYesGlobalNoinnodb_data_home_dirYesYesYesGlobalNoinnodb_disable_sort_file_cacheYesYesYesGlobalYesinnodb_doublewriteYesYesYesGlobalNoinnodb_fast_shutdownYesYesYesGlobalYesinnodb_fil_make_page_dirty_debugYesYesYesGlobalYesinnodb_file_formatYesYesYesGlobalYesinnodb_file_format_checkYesYesYesGlobalNoinnodb_file_format_maxYesYesYesGlobalYesinnodb_file_per_tableYesYesYesGlobalYesinnodb_flush_log_at_timeout  YesGlobalYesinnodb_flush_log_at_trx_commitYesYesYesGlobalYesinnodb_flush_methodYesYesYesGlobalNoinnodb_flush_neighborsYesYesYesGlobalYesinnodb_flushing_avg_loopsYesYesYesGlobalYesinnodb_force_load_corruptedYesYesYesGlobalNoinnodb_force_recoveryYesYesYesGlobalNoinnodb_ft_aux_table  YesGlobalYesinnodb_ft_cache_sizeYesYesYesGlobalNoinnodb_ft_enable_diag_printYesYesYesGlobalYesinnodb_ft_enable_stopwordYesYesYesGlobalYesinnodb_ft_max_token_sizeYesYesYesGlobalNoinnodb_ft_min_token_sizeYesYesYesGlobalNoinnodb_ft_num_word_optimizeYesYesYesGlobalYesinnodb_ft_result_cache_limitYesYesYesGlobalYesinnodb_ft_server_stopword_tableYesYesYesGlobalYesinnodb_ft_sort_pll_degreeYesYesYesGlobalNoinnodb_ft_total_cache_sizeYesYesYesGlobalNoinnodb_ft_user_stopword_tableYesYesYesBothYesinnodb_io_capacityYesYesYesGlobalYesinnodb_io_capacity_maxYesYesYesGlobalYesinnodb_large_prefixYesYesYesGlobalYesinnodb_limit_optimistic_insert_debugYesYesYesGlobalYesinnodb_lock_wait_timeoutYesYesYesBothYesinnodb_locks_unsafe_for_binlogYesYesYesGlobalNoinnodb_log_buffer_sizeYesYesYesGlobalNoinnodb_log_compressed_pagesYesYesYesGlobalYesinnodb_log_file_sizeYesYesYesGlobalNoinnodb_log_files_in_groupYesYesYesGlobalNoinnodb_log_group_home_dirYesYesYesGlobalNoinnodb_lru_scan_depthYesYesYesGlobalYesinnodb_max_dirty_pages_pctYesYesYesGlobalYesinnodb_max_dirty_pages_pct_lwmYesYesYesGlobalYesinnodb_max_purge_lagYesYesYesGlobalYesinnodb_max_purge_lag_delayYesYesYesGlobalYesinnodb_mirrored_log_groupsYesYesYesGlobalNoinnodb_monitor_disableYesYesYesGlobalYesinnodb_monitor_enableYesYesYesGlobalYesinnodb_monitor_resetYesYesYesGlobalYesinnodb_monitor_reset_allYesYesYesGlobalYesinnodb_numa_interleaveYesYesYesGlobalNoinnodb_old_blocks_pctYesYesYesGlobalYesinnodb_old_blocks_timeYesYesYesGlobalYesinnodb_online_alter_log_max_sizeYesYesYesGlobalYesinnodb_open_filesYesYesYesGlobalNoinnodb_optimize_fulltext_onlyYesYesYesGlobalYesinnodb_page_sizeYesYesYesGlobalNoinnodb_print_all_deadlocksYesYesYesGlobalYesinnodb_purge_batch_sizeYesYesYesGlobalYesinnodb_purge_threadsYesYesYesGlobalNoinnodb_random_read_aheadYesYesYesGlobalYesinnodb_read_ahead_thresholdYesYesYesGlobalYesinnodb_read_io_threadsYesYesYesGlobalNoinnodb_read_onlyYesYesYesGlobalNoinnodb_replication_delayYesYesYesGlobalYesinnodb_rollback_on_timeoutYesYesYesGlobalNoinnodb_rollback_segmentsYesYesYesGlobalYesinnodb_saved_page_number_debugYesYesYesGlobalYesinnodb_sort_buffer_sizeYesYesYesGlobalNoinnodb_spin_wait_delayYesYesYesGlobalYesinnodb_stats_auto_recalcYesYesYesGlobalYesinnodb_stats_methodYesYesYesGlobalYesinnodb_stats_on_metadataYesYesYesGlobalYesinnodb_stats_persistentYesYesYesGlobalYesinnodb_stats_persistent_sample_pagesYesYesYesGlobalYesinnodb_stats_sample_pagesYesYesYesGlobalYesinnodb_stats_transient_sample_pagesYesYesYesGlobalYesinnodb_status_outputYesYesYesGlobalYesinnodb_status_output_locksYesYesYesGlobalYesinnodb_strict_modeYesYesYesBothYesinnodb_support_xaYesYesYesBothYesinnodb_sync_array_sizeYesYesYesGlobalNoinnodb_sync_spin_loopsYesYesYesGlobalYesinnodb_table_locksYesYesYesBothYesinnodb_thread_concurrencyYesYesYesGlobalYesinnodb_thread_sleep_delayYesYesYesGlobalYesinnodb_tmpdirYesYesYesSessionYesinnodb_trx_purge_view_update_only_debugYesYesYesGlobalYesinnodb_trx_rseg_n_slots_debugYesYesYesGlobalYesinnodb_undo_directoryYesYesYesGlobalNoinnodb_undo_logsYesYesYesGlobalYesinnodb_undo_tablespacesYesYesYesGlobalNoinnodb_use_native_aioYesYesYesGlobalNoinnodb_use_sys_mallocYesYesYesGlobalNoinnodb_version  YesGlobalNoinnodb_write_io_threadsYesYesYesGlobalNoinsert_id  YesSessionYesinteractive_timeoutYesYesYesBothYesjoin_buffer_sizeYesYesYesBothYeskeep_files_on_createYesYesYesBothYeskey_buffer_sizeYesYesYesGlobalYeskey_cache_age_thresholdYesYesYesGlobalYeskey_cache_block_sizeYesYesYesGlobalYeskey_cache_division_limitYesYesYesGlobalYeslanguageYesYesYesGlobalNolarge_files_support  YesGlobalNolarge_page_size  YesGlobalNolarge-pagesYesYes  No- Variable: large_pages  YesGlobalNolast_insert_id  YesSessionYeslc-messagesYesYes  Yes- Variable: lc_messages  YesBothYeslc-messages-dirYesYes  No- Variable: lc_messages_dir  YesGlobalNolc_time_names  YesBothYeslicense  YesGlobalNolocal_infile  YesGlobalYeslock_wait_timeoutYesYesYesBothYeslocked_in_memory  YesGlobalNologYesYesYesGlobalYeslog-binYesYesYesGlobalNolog_bin  YesGlobalNolog_bin_basename  YesGlobalNolog_bin_index  YesGlobalNolog-bin-trust-function-creatorsYesYes  Yes- Variable: log_bin_trust_function_creators  YesGlobalYeslog-bin-use-v1-row-eventsYesYes  No- Variable: log_bin_use_v1_row_events  YesGlobalNolog_bin_use_v1_row_eventsYesYesYesGlobalNolog-errorYesYes  No- Variable: log_error  YesGlobalNolog-outputYesYes  Yes- Variable: log_output  YesGlobalYeslog-queries-not-using-indexesYesYes  Yes- Variable: log_queries_not_using_indexes  YesGlobalYeslog-slave-updatesYesYes  No- Variable: log_slave_updates  YesGlobalNolog_slave_updatesYesYesYesGlobalNolog_slow_admin_statements  YesGlobalYeslog-slow-queriesYesYes  Yes- Variable: log_slow_queries  YesGlobalYeslog_slow_slave_statements  YesGlobalYeslog_throttle_queries_not_using_indexes  YesGlobalYeslog-warningsYesYes  Yes- Variable: log_warnings  YesVariesYeslong_query_timeYesYesYesBothYeslow-priority-updatesYesYes  Yes- Variable: low_priority_updates  YesBothYeslower_case_file_system  YesGlobalNolower_case_table_namesYesYesYesGlobalNomaster_info_repositoryYesYesYesGlobalYesmaster_verify_checksum  YesGlobalYesmax_allowed_packetYesYesYesBothYesmax_binlog_cache_sizeYesYesYesGlobalYesmax_binlog_sizeYesYesYesGlobalYesmax_binlog_stmt_cache_sizeYesYesYesGlobalYesmax_connect_errorsYesYesYesGlobalYesmax_connectionsYesYesYesGlobalYesmax_delayed_threadsYesYesYesBothYesmax_digest_lengthYesYesYesGlobalNomax_error_countYesYesYesBothYesmax_heap_table_sizeYesYesYesBothYesmax_insert_delayed_threads  YesBothYesmax_join_sizeYesYesYesBothYesmax_length_for_sort_dataYesYesYesBothYesmax_prepared_stmt_countYesYesYesGlobalYesmax_relay_log_sizeYesYesYesGlobalYesmax_seeks_for_keyYesYesYesBothYesmax_sort_lengthYesYesYesBothYesmax_sp_recursion_depthYesYesYesBothYesmax_tmp_tables  YesBothYesmax_user_connectionsYesYesYesBothYesmax_write_lock_countYesYesYesGlobalYesmetadata_locks_cache_size  YesGlobalNometadata_locks_hash_instances  YesGlobalNomin-examined-row-limitYesYesYesBothYesmulti_range_countYesYesYesBothYesmyisam_data_pointer_sizeYesYesYesGlobalYesmyisam_max_sort_file_sizeYesYesYesGlobalYesmyisam_mmap_sizeYesYesYesGlobalNomyisam_recover_options  YesGlobalNomyisam_repair_threadsYesYesYesBothYesmyisam_sort_buffer_sizeYesYesYesBothYesmyisam_stats_methodYesYesYesBothYesmyisam_use_mmapYesYesYesGlobalYesmysql_firewall_max_query_sizeYesYesYesGlobalNomysql_firewall_modeYesYesYesGlobalYesmysql_firewall_traceYesYesYesGlobalYesnamed_pipe  YesGlobalNondb_autoincrement_prefetch_szYesYesYesBothYesndb-batch-sizeYesYesYesGlobalNondb-blob-read-batch-bytesYesYesYesBothYesndb-blob-write-batch-bytesYesYesYesBothYesndb_cache_check_timeYesYesYesGlobalYesndb_clear_apply_statusYes YesGlobalYesndb-cluster-connection-poolYesYesYesGlobalNoNdb_conflict_last_conflict_epoch  YesGlobalNondb-deferred-constraintsYesYes  Yes- Variable: ndb_deferred_constraints  YesBothYesndb_deferred_constraintsYesYesYesBothYesndb-distributionYesYes  Yes- Variable: ndb_distribution  YesGlobalYesndb_distributionYesYesYesGlobalYesndb_eventbuffer_free_percentYesYesYesGlobalYesndb_eventbuffer_max_allocYesYesYesGlobalYesndb_extra_loggingYesYesYesGlobalYesndb_force_sendYesYesYesBothYesndb_index_stat_cache_entriesYesYesYesBothYesndb_index_stat_enableYesYesYesBothYesndb_index_stat_optionYesYesYesBothYesndb_index_stat_update_freqYesYesYesBothYesndb_join_pushdown  YesBothYesndb-log-apply-statusYesYes  No- Variable: ndb_log_apply_status  YesGlobalNondb_log_apply_statusYesYesYesGlobalNondb_log_binYes YesBothYesndb_log_binlog_indexYes YesGlobalYesndb-log-empty-epochsYesYesYesGlobalYesndb_log_empty_epochsYesYesYesGlobalYesndb-log-exclusive-readsYesYes  Yes- Variable: ndb_log_exclusive_reads  YesBothYesndb_log_exclusive_readsYesYesYesBothYesndb-log-origYesYes  No- Variable: ndb_log_orig  YesGlobalNondb_log_origYesYesYesGlobalNondb-log-transaction-idYesYes  No- Variable: ndb_log_transaction_id  YesGlobalNondb_log_transaction_id  YesGlobalNondb-log-update-as-writeYesYesYesGlobalYesndb_log_updated_onlyYesYesYesGlobalYesndb_optimization_delay  YesGlobalYesndb_optimized_node_selectionYesYesYesGlobalNondb_recv_thread_cpu_mask  YesGlobalYesndb_show_foreign_key_mock_tablesYesYesYesGlobalYesndb_slave_conflict_roleYesYesYesGlobalYesNdb_slave_max_replicated_epoch  YesGlobalNondb_table_no_logging  YesSessionYesndb_table_temporary  YesSessionYesndb_use_copying_alter_table  YesBothNondb_use_exact_count  YesBothYesndb_use_transactionsYesYesYesBothYesndb_version  YesGlobalNondb_version_string  YesGlobalNondb-wait-connectedYesYesYesGlobalNondb-wait-setupYesYesYesGlobalNondbinfo_database  YesGlobalNondbinfo_max_bytesYes YesBothYesndbinfo_max_rowsYes YesBothYesndbinfo_offline  YesGlobalYesndbinfo_show_hiddenYes YesBothYesndbinfo_table_prefixYes YesBothYesndbinfo_version  YesGlobalNonet_buffer_lengthYesYesYesBothYesnet_read_timeoutYesYesYesBothYesnet_retry_countYesYesYesBothYesnet_write_timeoutYesYesYesBothYesnewYesYesYesBothYesoldYesYesYesGlobalNoold-alter-tableYesYes  Yes- Variable: old_alter_table  YesBothYesold_passwords  YesBothYesopen-files-limitYesYes  No- Variable: open_files_limit  YesGlobalNooptimizer_join_cache_levelYesYesYesBothYesoptimizer_prune_levelYesYesYesBothYesoptimizer_search_depthYesYesYesBothYesoptimizer_switchYesYesYesBothYesoptimizer_trace  YesBothYesoptimizer_trace_features  YesBothYesoptimizer_trace_limit  YesBothYesoptimizer_trace_max_mem_size  YesBothYesoptimizer_trace_offset  YesBothYesperformance_schemaYesYesYesGlobalNoperformance_schema_accounts_sizeYesYesYesGlobalNoperformance_schema_digests_sizeYesYesYesGlobalNoperformance_schema_events_stages_history_long_sizeYesYesYesGlobalNoperformance_schema_events_stages_history_sizeYesYesYesGlobalNoperformance_schema_events_statements_history_long_sizeYesYesYesGlobalNoperformance_schema_events_statements_history_sizeYesYesYesGlobalNoperformance_schema_events_waits_history_long_sizeYesYesYesGlobalNoperformance_schema_events_waits_history_sizeYesYesYesGlobalNoperformance_schema_hosts_sizeYesYesYesGlobalNoperformance_schema_max_cond_classesYesYesYesGlobalNoperformance_schema_max_cond_instancesYesYesYesGlobalNoperformance_schema_max_digest_lengthYesYesYesGlobalNoperformance_schema_max_file_classesYesYesYesGlobalNoperformance_schema_max_file_handlesYesYesYesGlobalNoperformance_schema_max_file_instancesYesYesYesGlobalNoperformance_schema_max_mutex_classesYesYesYesGlobalNoperformance_schema_max_mutex_instancesYesYesYesGlobalNoperformance_schema_max_rwlock_classesYesYesYesGlobalNoperformance_schema_max_rwlock_instancesYesYesYesGlobalNoperformance_schema_max_socket_classesYesYesYesGlobalNoperformance_schema_max_socket_instancesYesYesYesGlobalNoperformance_schema_max_stage_classesYesYesYesGlobalNoperformance_schema_max_statement_classesYesYesYesGlobalNoperformance_schema_max_table_handlesYesYesYesGlobalNoperformance_schema_max_table_instancesYesYesYesGlobalNoperformance_schema_max_thread_classesYesYesYesGlobalNoperformance_schema_max_thread_instancesYesYesYesGlobalNoperformance_schema_session_connect_attrs_sizeYesYesYesGlobalNoperformance_schema_setup_actors_sizeYesYesYesGlobalNoperformance_schema_setup_objects_sizeYesYesYesGlobalNoperformance_schema_users_sizeYesYesYesGlobalNopid-fileYesYes  No- Variable: pid_file  YesGlobalNoplugin_dirYesYesYesGlobalNoportYesYesYesGlobalNopreload_buffer_sizeYesYesYesBothYesprofiling  YesBothYesprofiling_history_sizeYesYesYesBothYesprotocol_version  YesGlobalNoproxy_user  YesSessionNopseudo_slave_mode  YesSessionYespseudo_thread_id  YesSessionYesquery_alloc_block_sizeYesYesYesBothYesquery_cache_limitYesYesYesGlobalYesquery_cache_min_res_unitYesYesYesGlobalYesquery_cache_sizeYesYesYesGlobalYesquery_cache_typeYesYesYesBothYesquery_cache_wlock_invalidateYesYesYesBothYesquery_prealloc_sizeYesYesYesBothYesrand_seed1  YesSessionYesrand_seed2  YesSessionYesrange_alloc_block_sizeYesYesYesBothYesread_buffer_sizeYesYesYesBothYesread_onlyYesYesYesGlobalYesread_rnd_buffer_sizeYesYesYesBothYesrelay-logYesYes  No- Variable: relay_log  YesGlobalNorelay_log_basename  YesGlobalNorelay-log-indexYesYes  No- Variable: relay_log_index  YesGlobalNorelay_log_indexYesYesYesGlobalNorelay_log_info_fileYesYesYesGlobalNorelay_log_info_repository  YesGlobalYesrelay_log_purgeYesYesYesGlobalYesrelay_log_recoveryYesYesYesGlobalVariesrelay_log_space_limitYesYesYesGlobalNoreport-hostYesYes  No- Variable: report_host  YesGlobalNoreport-passwordYesYes  No- Variable: report_password  YesGlobalNoreport-portYesYes  No- Variable: report_port  YesGlobalNoreport-userYesYes  No- Variable: report_user  YesGlobalNorpl_semi_sync_master_enabled  YesGlobalYesrpl_semi_sync_master_timeout  YesGlobalYesrpl_semi_sync_master_trace_level  YesGlobalYesrpl_semi_sync_master_wait_no_slave  YesGlobalYesrpl_semi_sync_slave_enabled  YesGlobalYesrpl_semi_sync_slave_trace_level  YesGlobalYesrpl_stop_slave_timeoutYesYesYesGlobalYessecure-authYesYes  Yes- Variable: secure_auth  YesGlobalYessecure-file-privYesYes  No- Variable: secure_file_priv  YesGlobalNoserver-idYesYes  Yes- Variable: server_id  YesGlobalYesserver-id-bitsYesYes  No- Variable: server_id_bits  YesGlobalNoserver_id_bitsYesYesYesGlobalNoserver_uuid  YesGlobalNosha256_password_private_key_path  YesGlobalNosha256_password_public_key_path  YesGlobalNoshared_memoryYesYesYesGlobalNoshared_memory_base_nameYesYesYesGlobalNoshow_old_temporalsYesYesYesBothYessimplified_binlog_gtid_recoveryYesYesYesGlobalNoskip_external_lockingYesYesYesGlobalNoskip-name-resolveYesYes  No- Variable: skip_name_resolve  YesGlobalNoskip-networkingYesYes  No- Variable: skip_networking  YesGlobalNoskip-show-databaseYesYes  No- Variable: skip_show_database  YesGlobalNoslave_allow_batchingYesYesYesGlobalYesslave_checkpoint_groupYesYesYesGlobalYesslave_checkpoint_periodYesYesYesGlobalYesslave_compressed_protocolYesYesYesGlobalYesslave_exec_modeYesYesYesGlobalYesslave-load-tmpdirYesYes  No- Variable: slave_load_tmpdir  YesGlobalNoslave_max_allowed_packet  YesGlobalYesslave-net-timeoutYesYes  Yes- Variable: slave_net_timeout  YesGlobalYesslave_parallel_workersYes YesGlobalYesslave_pending_jobs_size_max  YesGlobalYesslave_rows_search_algorithms  YesGlobalYesslave-skip-errorsYesYes  No- Variable: slave_skip_errors  YesGlobalNoslave_sql_verify_checksum  YesGlobalYesslave_transaction_retriesYesYesYesGlobalYesslave_type_conversionsYesYesYesGlobalNoslow_launch_timeYesYesYesGlobalYesslow-query-logYesYes  Yes- Variable: slow_query_log  YesGlobalYesslow_query_log_fileYesYesYesGlobalYessocketYesYesYesGlobalNosort_buffer_sizeYesYesYesBothYessql_auto_is_null  YesBothYessql_big_selects  YesBothYessql_big_tables  YesBothYessql_buffer_result  YesBothYessql_log_bin  YesSessionYessql_log_off  YesBothYessql_low_priority_updates  YesBothYessql_max_join_size  YesBothYessql-modeYesYes  Yes- Variable: sql_mode  YesBothYessql_notes  YesBothYessql_quote_show_create  YesBothYessql_safe_updates  YesBothYessql_select_limit  YesBothYessql_slave_skip_counter  YesGlobalYessql_warnings  YesBothYesssl-caYesYes  No- Variable: ssl_ca  YesGlobalNossl-capathYesYes  No- Variable: ssl_capath  YesGlobalNossl-certYesYes  No- Variable: ssl_cert  YesGlobalNossl-cipherYesYes  No- Variable: ssl_cipher  YesGlobalNossl-crlYesYes  No- Variable: ssl_crl  YesGlobalNossl-crlpathYesYes  No- Variable: ssl_crlpath  YesGlobalNossl-keyYesYes  No- Variable: ssl_key  YesGlobalNostorage_engine  YesBothYesstored_program_cacheYesYesYesGlobalYessync_binlogYesYesYesGlobalYessync_frmYesYesYesGlobalYessync_master_infoYesYesYesGlobalYessync_relay_logYesYesYesGlobalYessync_relay_log_infoYesYesYesGlobalYessystem_time_zone  YesGlobalNotable_definition_cache  YesGlobalYestable_open_cache  YesGlobalYestable_open_cache_instances  YesGlobalNothread_cache_sizeYesYesYesGlobalYesthread_concurrencyYesYesYesGlobalNothread_handlingYesYesYesGlobalNothread_pool_algorithmYesYesYesGlobalNothread_pool_high_priority_connectionYesYesYesBothYesthread_pool_max_unused_threadsYesYesYesGlobalYesthread_pool_prio_kickup_timerYesYesYesBothYesthread_pool_sizeYesYesYesGlobalNothread_pool_stall_limitYesYesYesGlobalYesthread_stackYesYesYesGlobalNotime_format  YesGlobalNotime_zone  YesBothYestimed_mutexesYesYesYesGlobalYestimestamp  YesSessionYestmp_table_sizeYesYesYesBothYestmpdirYesYesYesGlobalNotransaction_alloc_block_sizeYesYesYesBothYestransaction_allow_batching  YesSessionYestransaction_prealloc_sizeYesYesYesBothYestx_isolation  YesBothYestx_read_only  YesBothYesunique_checks  YesBothYesupdatable_views_with_limitYesYesYesBothYesvalidate_password_dictionary_file  YesGlobalVariesvalidate_password_length  YesGlobalYesvalidate_password_mixed_case_count  YesGlobalYesvalidate_password_number_count  YesGlobalYesvalidate_password_policy  YesGlobalYesvalidate_password_special_char_count  YesGlobalYesvalidate_user_plugins  YesGlobalNoversion  YesGlobalNoversion_comment  YesGlobalNoversion_compile_machine  YesGlobalNoversion_compile_os  YesGlobalNowait_timeoutYesYesYesBothYeswarning_count  YesSessionNo

^[a] This option is dynamic, but only the server should set this information. You should not set the value of this variable manually.

^[b] This option is dynamic, but only the server should set this information. You should not set the value of this variable manually.