Mysql配置引數詳解(一)

sgmcumt發表於2018-01-26

一 檢視全部設定項

要檢視完整的配置項,使用以下命名

[root@mysqlserver ~]# mysqld --verbose --help

二 各引數說明

NameCmd-LineOption FileSystem VarVar ScopeDynamic
audit_log_buffer_sizeYesYesYesGlobalNo
audit_log_compressionYesYesYesGlobalNo
audit_log_connection_policyYesYesYesGlobalYes
audit_log_current_session YesBothNo
audit_log_encryptionYesYesYesGlobalNo
audit_log_exclude_accountsYesYesYesGlobalYes
audit_log_fileYesYesYesGlobalNo
audit_log_filter_id YesBothNo
audit_log_flush YesGlobalYes
audit_log_formatYesYesYesGlobalNo
audit_log_include_accountsYesYesYesGlobalYes
audit_log_policyYesYesYesGlobalNo
audit_log_read_buffer_sizeYesYesYesGlobalNo
audit_log_rotate_on_sizeYesYesYesGlobalYes
audit_log_statement_policyYesYesYesGlobalYes
audit_log_strategyYesYesYesGlobalNo
authentication_ldap_sasl_auth_method_nameYesYesYesGlobalYes
authentication_ldap_sasl_bind_base_dnYesYesYesGlobalYes
authentication_ldap_sasl_bind_root_dnYesYesYesGlobalYes
authentication_ldap_sasl_bind_root_pwdYesYesYesGlobalYes
authentication_ldap_sasl_ca_pathYesYesYesGlobalYes
authentication_ldap_sasl_group_search_attrYesYesYesGlobalYes
authentication_ldap_sasl_group_search_filterYesYesYesGlobalYes
authentication_ldap_sasl_init_pool_sizeYesYesYesGlobalYes
authentication_ldap_sasl_log_statusYesYesYesGlobalYes
authentication_ldap_sasl_max_pool_sizeYesYesYesGlobalYes
authentication_ldap_sasl_server_hostYesYesYesGlobalYes
authentication_ldap_sasl_server_portYesYesYesGlobalYes
authentication_ldap_sasl_tlsYesYesYesGlobalYes
authentication_ldap_sasl_user_search_attrYesYesYesGlobalYes
authentication_ldap_simple_auth_method_nameYesYesYesGlobalYes
authentication_ldap_simple_bind_base_dnYesYesYesGlobalYes
authentication_ldap_simple_bind_root_dnYesYesYesGlobalYes
authentication_ldap_simple_bind_root_pwdYesYesYesGlobalYes
authentication_ldap_simple_ca_pathYesYesYesGlobalYes
authentication_ldap_simple_group_search_attrYesYesYesGlobalYes
authentication_ldap_simple_group_search_filterYesYesYesGlobalYes
authentication_ldap_simple_init_pool_sizeYesYesYesGlobalYes
authentication_ldap_simple_log_statusYesYesYesGlobalYes
authentication_ldap_simple_max_pool_sizeYesYesYesGlobalYes
authentication_ldap_simple_server_hostYesYesYesGlobalYes
authentication_ldap_simple_server_portYesYesYesGlobalYes
authentication_ldap_simple_tlsYesYesYesGlobalYes
authentication_ldap_simple_user_search_attrYesYesYesGlobalYes
auto_generate_certsYesYesYesGlobalNo
auto_increment_increment YesBothYes
auto_increment_offset YesBothYes
autocommitYesYesYesBothYes
automatic_sp_privileges YesGlobalYes
avoid_temporal_upgradeYesYesYesGlobalYes
back_log YesGlobalNo
basedirYesYesYesGlobalNo
big-tablesYesYes Yes
- Variable: big_tables YesBothYes
bind-addressYesYes No
- Variable: bind_address YesGlobalNo
binlog_cache_sizeYesYesYesGlobalYes
binlog_checksum YesGlobalYes
binlog_direct_non_transactional_updatesYesYesYesBothYes
binlog_error_actionYesYesYesGlobalYes
binlog-formatYesYes Yes
- Variable: binlog_format YesBothYes
binlog_group_commit_sync_delayYesYesYesGlobalYes
binlog_group_commit_sync_no_delay_countYesYesYesGlobalYes
binlog_gtid_simple_recoveryYesYesYesGlobalNo
binlog_max_flush_queue_time YesGlobalYes
binlog_order_commits YesGlobalYes
binlog_row_imageYesYesYesBothYes
binlog_rows_query_log_eventsYesYesYesBothYes
binlog_stmt_cache_sizeYesYesYesGlobalYes
binlogging_impossible_modeYesYesYesBothYes
block_encryption_modeYesYesYesBothYes
bulk_insert_buffer_sizeYesYesYesBothYes
character_set_client YesBothYes
character_set_connection YesBothYes
character_set_database[a] YesBothYes
character-set-filesystemYesYes Yes
- Variable: character_set_filesystem YesBothYes
character_set_results YesBothYes
character-set-serverYesYes Yes
- Variable: character_set_server YesBothYes
character_set_system YesGlobalNo
character-sets-dirYesYes No
- Variable: character_sets_dir YesGlobalNo
check_proxy_usersYesYesYesGlobalYes
collation_connection YesBothYes
collation_database[b] YesBothYes
collation-serverYesYes Yes
- Variable: collation_server YesBothYes
completion_typeYesYesYesBothYes
concurrent_insertYesYesYesGlobalYes
connect_timeoutYesYesYesGlobalYes
connection_control_failed_connections_thresholdYesYesYesGlobalYes
connection_control_max_connection_delayYesYesYesGlobalYes
connection_control_min_connection_delayYesYesYesGlobalYes
core_file YesGlobalNo
daemon_memcached_enable_binlogYesYesYesGlobalNo
daemon_memcached_engine_lib_nameYesYesYesGlobalNo
daemon_memcached_engine_lib_pathYesYesYesGlobalNo
daemon_memcached_optionYesYesYesGlobalNo
daemon_memcached_r_batch_sizeYesYesYesGlobalNo
daemon_memcached_w_batch_sizeYesYesYesGlobalNo
datadirYesYesYesGlobalNo
date_format YesGlobalNo
datetime_format YesGlobalNo
debugYesYesYesBothYes
debug_sync YesSessionYes
default_authentication_pluginYesYesYesGlobalNo
default_password_lifetimeYesYesYesGlobalYes
default-storage-engineYesYes Yes
- Variable: default_storage_engine YesBothYes
default_tmp_storage_engineYesYesYesBothYes
default_week_formatYesYesYesBothYes
delay-key-writeYesYes Yes
- Variable: delay_key_write YesGlobalYes
delayed_insert_limitYesYesYesGlobalYes
delayed_insert_timeoutYesYesYesGlobalYes
delayed_queue_sizeYesYesYesGlobalYes
disabled_storage_enginesYesYesYesGlobalNo
disconnect_on_expired_passwordYesYesYesSessionNo
div_precision_incrementYesYesYesBothYes
end_markers_in_json YesBothYes
enforce-gtid-consistencyYesYesYesGlobalVaries
enforce_gtid_consistencyYesYesYesGlobalVaries
eq_range_index_dive_limit YesBothYes
error_count YesSessionNo
event-schedulerYesYes Yes
- Variable: event_scheduler YesGlobalYes
executed_gtids_compression_period YesGlobalYes
expire_logs_daysYesYesYesGlobalYes
explicit_defaults_for_timestampYesYesYesBothYes
external_user YesSessionNo
flushYesYesYesGlobalYes
flush_timeYesYesYesGlobalYes
foreign_key_checks YesBothYes
ft_boolean_syntaxYesYesYesGlobalYes
ft_max_word_lenYesYesYesGlobalNo
ft_min_word_lenYesYesYesGlobalNo
ft_query_expansion_limitYesYesYesGlobalNo
ft_stopword_fileYesYesYesGlobalNo
general-logYesYes Yes
- Variable: general_log YesGlobalYes
general_log_fileYesYesYesGlobalYes
group_concat_max_lenYesYesYesBothYes
group_replication_allow_local_disjoint_gtids_joinYesYesYesGlobalYes
group_replication_allow_local_lower_version_joinYesYesYesGlobalYes
group_replication_auto_increment_incrementYesYesYesGlobalYes
group_replication_bootstrap_groupYesYesYesGlobalYes
group_replication_components_stop_timeoutYesYesYesGlobalYes
group_replication_compression_thresholdYesYesYesGlobalYes
group_replication_enforce_update_everywhere_checksYesYesYesGlobalYes
group_replication_flow_control_applier_thresholdYesYesYesGlobalYes
group_replication_flow_control_certifier_thresholdYesYesYesGlobalYes
group_replication_flow_control_modeYesYesYesGlobalYes
group_replication_force_membersYesYesYesGlobalYes
group_replication_group_nameYesYesYesGlobalYes
group_replication_group_seedsYesYesYesGlobalYes
group_replication_gtid_assignment_block_sizeYesYesYesGlobalYes
group_replication_ip_whitelistYesYesYesGlobalYes
group_replication_local_addressYesYesYesGlobalYes
group_replication_member_weightYesYesYesGlobalYes
group_replication_poll_spin_loopsYesYesYesGlobalYes
group_replication_recovery_complete_atYesYesYesGlobalYes
group_replication_recovery_reconnect_intervalYesYesYesGlobalYes
group_replication_recovery_retry_countYesYesYesGlobalYes
group_replication_recovery_ssl_caYesYesYesGlobalYes
group_replication_recovery_ssl_capathYesYesYesGlobalYes
group_replication_recovery_ssl_certYesYesYesGlobalYes
group_replication_recovery_ssl_cipherYesYesYesGlobalYes
group_replication_recovery_ssl_crlYesYesYesGlobalYes
group_replication_recovery_ssl_crlpathYesYesYesGlobalYes
group_replication_recovery_ssl_keyYesYesYesGlobalYes
group_replication_recovery_ssl_verify_server_certYesYesYesGlobalYes
group_replication_recovery_use_sslYesYesYesGlobalYes
group_replication_single_primary_modeYesYesYesGlobalYes
group_replication_ssl_modeYesYesYesGlobalYes
group_replication_start_on_bootYesYesYesGlobalYes
group_replication_transaction_size_limitYesYesYesGlobalYes
group_replication_unreachable_majority_timeoutYesYesYesGlobalYes
gtid_executed YesVariesNo
gtid_executed_compression_period YesGlobalYes
gtid-modeYesYes Varies
- Variable: gtid_mode YesGlobalVaries
gtid_mode YesGlobalVaries
gtid_next YesSessionYes
gtid_owned YesBothNo
gtid_purged YesGlobalYes
have_compress YesGlobalNo
have_crypt YesGlobalNo
have_dynamic_loading YesGlobalNo
have_geometry YesGlobalNo
have_openssl YesGlobalNo
have_profiling YesGlobalNo
have_query_cache YesGlobalNo
have_rtree_keys YesGlobalNo
have_ssl YesGlobalNo
have_statement_timeout YesGlobalNo
have_symlink YesGlobalNo
host_cache_size YesGlobalYes
hostname YesGlobalNo
identity YesSessionYes
ignore-builtin-innodbYesYes No
- Variable: ignore_builtin_innodb YesGlobalNo
ignore_db_dirs YesGlobalNo
init_connectYesYesYesGlobalYes
init-fileYesYes No
- Variable: init_file YesGlobalNo
init_slaveYesYesYesGlobalYes
innodb_adaptive_flushingYesYesYesGlobalYes
innodb_adaptive_flushing_lwmYesYesYesGlobalYes
innodb_adaptive_hash_indexYesYesYesGlobalYes
innodb_adaptive_hash_index_partsYesYesYesGlobalNo
innodb_adaptive_max_sleep_delayYesYesYesGlobalYes
innodb_additional_mem_pool_sizeYesYesYesGlobalNo
innodb_api_bk_commit_intervalYesYesYesGlobalYes
innodb_api_disable_rowlockYesYesYesGlobalNo
innodb_api_enable_binlogYesYesYesGlobalNo
innodb_api_enable_mdlYesYesYesGlobalNo
innodb_api_trx_levelYesYesYesGlobalYes
innodb_autoextend_incrementYesYesYesGlobalYes
innodb_autoinc_lock_modeYesYesYesGlobalNo
innodb_background_drop_list_emptyYesYesYesGlobalYes
innodb_buffer_pool_chunk_sizeYesYesYesGlobalNo
innodb_buffer_pool_dump_at_shutdownYesYesYesGlobalYes
innodb_buffer_pool_dump_nowYesYesYesGlobalYes
innodb_buffer_pool_dump_pctYesYesYesGlobalYes
innodb_buffer_pool_filenameYesYesYesGlobalYes
innodb_buffer_pool_instancesYesYesYesGlobalNo
innodb_buffer_pool_load_abortYesYesYesGlobalYes
innodb_buffer_pool_load_at_startupYesYesYesGlobalNo
innodb_buffer_pool_load_nowYesYesYesGlobalYes
innodb_buffer_pool_sizeYesYesYesGlobalVaries
innodb_change_buffer_max_sizeYesYesYesGlobalYes
innodb_change_bufferingYesYesYesGlobalYes
innodb_change_buffering_debugYesYesYesGlobalYes
innodb_checksum_algorithmYesYesYesGlobalYes
innodb_checksumsYesYesYesGlobalNo
innodb_cmp_per_index_enabledYesYesYesGlobalYes
innodb_commit_concurrencyYesYesYesGlobalYes
innodb_compress_debugYesYesYesGlobalYes
innodb_compression_failure_threshold_pctYesYesYesGlobalYes
innodb_compression_levelYesYesYesGlobalYes
innodb_compression_pad_pct_maxYesYesYesGlobalYes
innodb_concurrency_ticketsYesYesYesGlobalYes
innodb_data_file_pathYesYesYesGlobalNo
innodb_data_home_dirYesYesYesGlobalNo
innodb_deadlock_detectYesYesYesGlobalYes
innodb_default_row_formatYesYesYesGlobalYes
innodb_disable_resize_buffer_pool_debugYesYesYesGlobalYes
innodb_disable_sort_file_cacheYesYesYesGlobalYes
innodb_doublewriteYesYesYesGlobalNo
innodb_fast_shutdownYesYesYesGlobalYes
innodb_fil_make_page_dirty_debugYesYesYesGlobalYes
innodb_file_formatYesYesYesGlobalYes
innodb_file_format_checkYesYesYesGlobalNo
innodb_file_format_maxYesYesYesGlobalYes
innodb_file_per_tableYesYesYesGlobalYes
innodb_fill_factorYesYesYesGlobalYes
innodb_flush_log_at_timeout YesGlobalYes
innodb_flush_log_at_trx_commitYesYesYesGlobalYes
innodb_flush_methodYesYesYesGlobalNo
innodb_flush_neighborsYesYesYesGlobalYes
innodb_flush_syncYesYesYesGlobalYes
innodb_flushing_avg_loopsYesYesYesGlobalYes
innodb_force_load_corruptedYesYesYesGlobalNo
innodb_force_recoveryYesYesYesGlobalNo
innodb_ft_aux_tableYesYesYesGlobalYes
innodb_ft_cache_sizeYesYesYesGlobalNo
innodb_ft_enable_diag_printYesYesYesGlobalYes
innodb_ft_enable_stopwordYesYesYesGlobalYes
innodb_ft_max_token_sizeYesYesYesGlobalNo
innodb_ft_min_token_sizeYesYesYesGlobalNo
innodb_ft_num_word_optimizeYesYesYesGlobalYes
innodb_ft_result_cache_limitYesYesYesGlobalYes
innodb_ft_server_stopword_tableYesYesYesGlobalYes
innodb_ft_sort_pll_degreeYesYesYesGlobalNo
innodb_ft_total_cache_sizeYesYesYesGlobalNo
innodb_ft_user_stopword_tableYesYesYesBothYes
innodb_io_capacityYesYesYesGlobalYes
innodb_io_capacity_maxYesYesYesGlobalYes
innodb_large_prefixYesYesYesGlobalYes
innodb_limit_optimistic_insert_debugYesYesYesGlobalYes
innodb_lock_wait_timeoutYesYesYesBothYes
innodb_locks_unsafe_for_binlogYesYesYesGlobalNo
innodb_log_buffer_sizeYesYesYesGlobalNo
innodb_log_checksum_algorithmYesYesYesGlobalYes
innodb_log_checksumsYesYesYesGlobalYes
innodb_log_compressed_pagesYesYesYesGlobalYes
innodb_log_file_sizeYesYesYesGlobalNo
innodb_log_files_in_groupYesYesYesGlobalNo
innodb_log_group_home_dirYesYesYesGlobalNo
innodb_log_write_ahead_sizeYesYesYesGlobalYes
innodb_lru_scan_depthYesYesYesGlobalYes
innodb_max_dirty_pages_pctYesYesYesGlobalYes
innodb_max_dirty_pages_pct_lwmYesYesYesGlobalYes
innodb_max_purge_lagYesYesYesGlobalYes
innodb_max_purge_lag_delayYesYesYesGlobalYes
innodb_max_undo_log_sizeYesYesYesGlobalYes
innodb_merge_threshold_set_all_debugYesYesYesGlobalYes
innodb_monitor_disableYesYesYesGlobalYes
innodb_monitor_enableYesYesYesGlobalYes
innodb_monitor_resetYesYesYesGlobalYes
innodb_monitor_reset_allYesYesYesGlobalYes
innodb_numa_interleaveYesYesYesGlobalNo
innodb_old_blocks_pctYesYesYesGlobalYes
innodb_old_blocks_timeYesYesYesGlobalYes
innodb_online_alter_log_max_sizeYesYesYesGlobalYes
innodb_open_filesYesYesYesGlobalNo
innodb_optimize_fulltext_onlyYesYesYesGlobalYes
innodb_optimize_point_storageYesYesYesSessionYes
innodb_page_cleanersYesYesYesGlobalNo
innodb_page_sizeYesYesYesGlobalNo
innodb_print_all_deadlocksYesYesYesGlobalYes
innodb_purge_batch_sizeYesYesYesGlobalYes
innodb_purge_rseg_truncate_frequencyYesYesYesGlobalYes
innodb_purge_threadsYesYesYesGlobalNo
innodb_random_read_aheadYesYesYesGlobalYes
innodb_read_ahead_thresholdYesYesYesGlobalYes
innodb_read_io_threadsYesYesYesGlobalNo
innodb_read_onlyYesYesYesGlobalNo
innodb_replication_delayYesYesYesGlobalYes
innodb_rollback_on_timeoutYesYesYesGlobalNo
innodb_rollback_segmentsYesYesYesGlobalYes
innodb_saved_page_number_debugYesYesYesGlobalYes
innodb_sort_buffer_sizeYesYesYesGlobalNo
innodb_spin_wait_delayYesYesYesGlobalYes
innodb_stats_auto_recalcYesYesYesGlobalYes
innodb_stats_include_delete_markedYesYesYesGlobalYes
innodb_stats_methodYesYesYesGlobalYes
innodb_stats_on_metadataYesYesYesGlobalYes
innodb_stats_persistentYesYesYesGlobalYes
innodb_stats_persistent_sample_pagesYesYesYesGlobalYes
innodb_stats_sample_pagesYesYesYesGlobalYes
innodb_stats_transient_sample_pagesYesYesYesGlobalYes
innodb_status_outputYesYesYesGlobalYes
innodb_status_output_locksYesYesYesGlobalYes
innodb_strict_modeYesYesYesBothYes
innodb_support_xaYesYesYesBothYes
innodb_sync_array_sizeYesYesYesGlobalNo
innodb_sync_debugYesYesYesGlobalNo
innodb_sync_spin_loopsYesYesYesGlobalYes
innodb_table_locksYesYesYesBothYes
innodb_temp_data_file_pathYesYesYesGlobalNo
innodb_thread_concurrencyYesYesYesGlobalYes
innodb_thread_sleep_delayYesYesYesGlobalYes
innodb_tmpdirYesYesYesBothYes
innodb_trx_purge_view_update_only_debugYesYesYesGlobalYes
innodb_trx_rseg_n_slots_debugYesYesYesGlobalYes
innodb_undo_directoryYesYesYesGlobalNo
innodb_undo_log_truncateYesYesYesGlobalYes
innodb_undo_logsYesYesYesGlobalYes
innodb_undo_tablespacesYesYesYesGlobalNo
innodb_use_native_aioYesYesYesGlobalNo
innodb_use_sys_mallocYesYesYesGlobalNo
innodb_version YesGlobalNo
innodb_write_io_threadsYesYesYesGlobalNo
insert_id YesSessionYes
interactive_timeoutYesYesYesBothYes
internal_tmp_disk_storage_engineYesYesYesGlobalYes
join_buffer_sizeYesYesYesBothYes
keep_files_on_createYesYesYesBothYes
key_buffer_sizeYesYesYesGlobalYes
key_cache_age_thresholdYesYesYesGlobalYes
key_cache_block_sizeYesYesYesGlobalYes
key_cache_division_limitYesYesYesGlobalYes
keyring_aws_cmk_idYesYesYesGlobalYes
keyring_aws_conf_fileYesYesYesGlobalNo
keyring_aws_data_fileYesYesYesGlobalNo
keyring_aws_regionYesYesYesGlobalYes
keyring_encrypted_file_dataYesYesYesGlobalYes
keyring_encrypted_file_passwordYesYesYesGlobalYes
keyring_file_dataYesYesYesGlobalYes
keyring_okv_conf_dirYesYesYesGlobalYes
keyring_operations YesGlobalYes
languageYesYesYesGlobalNo
large_files_support YesGlobalNo
large_page_size YesGlobalNo
large-pagesYesYes No
- Variable: large_pages YesGlobalNo
last_insert_id YesSessionYes
lc-messagesYesYes Yes
- Variable: lc_messages YesBothYes
lc-messages-dirYesYes No
- Variable: lc_messages_dir YesGlobalNo
lc_time_names YesBothYes
license YesGlobalNo
local_infile YesGlobalYes
lock_wait_timeoutYesYesYesBothYes
locked_in_memory YesGlobalNo
log_backward_compatible_user_definitionsYesYesYesGlobalYes
log-binYesYesYesGlobalNo
log_bin YesGlobalNo
log_bin_basename YesGlobalNo
log_bin_index YesGlobalNo
log-bin-trust-function-creatorsYesYes Yes
- Variable: log_bin_trust_function_creators YesGlobalYes
log-bin-use-v1-row-eventsYesYes No
- Variable: log_bin_use_v1_row_events YesGlobalNo
log_bin_use_v1_row_eventsYesYesYesGlobalNo
log_builtin_as_identified_by_passwordYesYesYesGlobalYes
log-errorYesYes No
- Variable: log_error YesGlobalNo
log_error_verbosityYesYesYesGlobalYes
log-outputYesYes Yes
- Variable: log_output YesGlobalYes
log-queries-not-using-indexesYesYes Yes
- Variable: log_queries_not_using_indexes YesGlobalYes
log-slave-updatesYesYes No
- Variable: log_slave_updates YesGlobalNo
log_slave_updatesYesYesYesGlobalNo
log_slow_admin_statements YesGlobalYes
log_slow_slave_statements YesGlobalYes
log_statements_unsafe_for_binlog YesGlobalYes
log_syslogYesYesYesGlobalYes
log_syslog_facilityYesYesYesGlobalYes
log_syslog_include_pidYesYesYesGlobalYes
log_syslog_tagYesYesYesGlobalYes
log_throttle_queries_not_using_indexes YesGlobalYes
log_timestampsYesYesYesGlobalYes
log-warningsYesYes Yes
- Variable: log_warnings YesGlobalYes
long_query_timeYesYesYesBothYes
low-priority-updatesYesYes Yes
- Variable: low_priority_updates YesBothYes
lower_case_file_system YesGlobalNo
lower_case_table_namesYesYesYesGlobalNo
master_info_repositoryYesYesYesGlobalYes
master_verify_checksum YesGlobalYes
max_allowed_packetYesYesYesBothYes
max_binlog_cache_sizeYesYesYesGlobalYes
max_binlog_sizeYesYesYesGlobalYes
max_binlog_stmt_cache_sizeYesYesYesGlobalYes
max_connect_errorsYesYesYesGlobalYes
max_connectionsYesYesYesGlobalYes
max_delayed_threadsYesYesYesBothYes
max_digest_lengthYesYesYesGlobalNo
max_error_countYesYesYesBothYes
max_execution_timeYesYesYesBothYes
max_heap_table_sizeYesYesYesBothYes
max_insert_delayed_threads YesBothYes
max_join_sizeYesYesYesBothYes
max_length_for_sort_dataYesYesYesBothYes
max_points_in_geometryYesYesYesBothYes
max_prepared_stmt_countYesYesYesGlobalYes
max_relay_log_sizeYesYesYesGlobalYes
max_seeks_for_keyYesYesYesBothYes
max_sort_lengthYesYesYesBothYes
max_sp_recursion_depthYesYesYesBothYes
max_statement_time YesBothYes
max_tmp_tables YesBothYes
max_user_connectionsYesYesYesBothYes
max_write_lock_countYesYesYesGlobalYes
mecab_rc_fileYesYesYesGlobalNo
metadata_locks_cache_size YesGlobalNo
metadata_locks_hash_instances YesGlobalNo
min-examined-row-limitYesYesYesBothYes
multi_range_countYesYesYesBothYes
myisam_data_pointer_sizeYesYesYesGlobalYes
myisam_max_sort_file_sizeYesYesYesGlobalYes
myisam_mmap_sizeYesYesYesGlobalNo
myisam_recover_options YesGlobalNo
myisam_repair_threadsYesYesYesBothYes
myisam_sort_buffer_sizeYesYesYesBothYes
myisam_stats_methodYesYesYesBothYes
myisam_use_mmapYesYesYesGlobalYes
mysql_firewall_modeYesYesYesGlobalYes
mysql_firewall_traceYesYesYesGlobalYes
mysql_native_password_proxy_usersYesYesYesGlobalYes
mysqlx-bind-addressYesYesYesGlobalNo
mysqlx_bind_addressYesYesYesGlobalNo
mysqlx-connect-timeoutYesYesYesGlobalYes
mysqlx_connect_timeoutYesYesYesGlobalYes
mysqlx-idle-worker-thread-timeoutYesYesYesGlobalYes
mysqlx_idle_worker_thread_timeoutYesYesYesGlobalYes
mysqlx-max-allowed-packetYesYesYesGlobalYes
mysqlx_max_allowed_packetYesYesYesGlobalYes
mysqlx-max-connectionsYesYesYesGlobalYes
mysqlx_max_connectionsYesYesYesGlobalYes
mysqlx-min-worker-threadsYesYesYesGlobalYes
mysqlx_min_worker_threadsYesYesYesGlobalYes
mysqlx-portYesYesYesGlobalNo
mysqlx_portYesYesYesGlobalNo
mysqlx-port-open-timeoutYesYesYesGlobalNo
mysqlx_port_open_timeoutYesYesYesGlobalNo
mysqlx-socketYesYesYesGlobalNo
mysqlx_socketYesYesYesGlobalNo
mysqlx-sslYesYesYesGlobalNo
mysqlx-ssl-caYesYesYesGlobalNo
mysqlx-ssl-capathYesYesYesGlobalNo
mysqlx-ssl-certYesYesYesGlobalNo
mysqlx-ssl-crlYesYesYesGlobalNo
mysqlx-ssl-crlpathYesYesYesGlobalNo
mysqlx-ssl-keyYesYesYesGlobalNo
named_pipe YesGlobalNo
ndb-allow-copying-alter-tableYesYesYesBothYes
ndb_autoincrement_prefetch_szYesYesYesBothYes
ndb-batch-sizeYesYesYesGlobalNo
ndb-blob-read-batch-bytesYesYesYesBothYes
ndb-blob-write-batch-bytesYesYesYesBothYes
ndb_cache_check_timeYesYesYesGlobalYes
ndb_clear_apply_statusYes YesGlobalYes
ndb-cluster-connection-poolYesYesYesGlobalNo
ndb-cluster-connection-pool-nodeidsYesYesYesGlobalNo
ndb_data_node_neighbourYesYesYesGlobalYes
ndb-default-column-formatYesYes Yes
- Variable: ndb_default_column_format YesGlobalYes
ndb_default_column_formatYesYesYesGlobalYes
ndb-deferred-constraintsYesYes Yes
- Variable: ndb_deferred_constraints YesBothYes
ndb_deferred_constraintsYesYesYesBothYes
ndb-distributionYesYes Yes
- Variable: ndb_distribution YesGlobalYes
ndb_distributionYesYesYesGlobalYes
ndb_eventbuffer_free_percentYesYesYesGlobalYes
ndb_eventbuffer_max_allocYesYesYesGlobalYes
ndb_extra_loggingYesYesYesGlobalYes
ndb_force_sendYesYesYesBothYes
ndb_fully_replicatedYesYesYesBothYes
ndb_index_stat_enableYesYesYesBothYes
ndb_index_stat_optionYesYesYesBothYes
ndb_join_pushdown YesBothYes
ndb-log-apply-statusYesYes No
- Variable: ndb_log_apply_status YesGlobalNo
ndb_log_apply_statusYesYesYesGlobalNo
ndb_log_binYes YesBothYes
ndb_log_binlog_indexYes YesGlobalYes
ndb-log-empty-epochsYesYesYesGlobalYes
ndb_log_empty_epochsYesYesYesGlobalYes
ndb-log-empty-updateYesYesYesGlobalYes
ndb_log_empty_updateYesYesYesGlobalYes
ndb-log-exclusive-readsYesYes Yes
- Variable: ndb_log_exclusive_reads YesBothYes
ndb_log_exclusive_readsYesYesYesBothYes
ndb-log-origYesYes No
- Variable: ndb_log_orig YesGlobalNo
ndb_log_origYesYesYesGlobalNo
ndb-log-transaction-idYesYes No
- Variable: ndb_log_transaction_id YesGlobalNo
ndb_log_transaction_id YesGlobalNo
ndb-log-update-minimalYesYesYesGlobalYes
ndb_log_updated_onlyYesYesYesGlobalYes
ndb_optimization_delay YesGlobalYes
ndb_optimized_node_selectionYesYesYesGlobalNo
ndb_read_backupYesYesYesGlobalYes
ndb_recv_thread_cpu_mask YesGlobalYes
ndb_report_thresh_binlog_epoch_slipYesYesYesGlobalYes
ndb_report_thresh_binlog_mem_usageYesYesYesGlobalYes
ndb_show_foreign_key_mock_tablesYesYesYesGlobalYes
ndb_slave_conflict_roleYesYesYesGlobalYes
Ndb_slave_max_replicated_epoch YesGlobalNo
Ndb_system_name YesGlobalNo
ndb_table_no_logging YesSessionYes
ndb_table_temporary YesSessionYes
ndb_use_copying_alter_table YesBothNo
ndb_use_exact_count YesBothYes
ndb_use_transactionsYesYesYesBothYes
ndb_version YesGlobalNo
ndb_version_string YesGlobalNo
ndb-wait-connectedYesYesYesGlobalNo
ndb-wait-setupYesYesYesGlobalNo
ndbinfo_database YesGlobalNo
ndbinfo_max_bytesYes YesBothYes
ndbinfo_max_rowsYes YesBothYes
ndbinfo_offline YesGlobalYes
ndbinfo_show_hiddenYes YesBothYes
ndbinfo_table_prefixYes YesBothYes
ndbinfo_version YesGlobalNo
net_buffer_lengthYesYesYesBothYes
net_read_timeoutYesYesYesBothYes
net_retry_countYesYesYesBothYes
net_write_timeoutYesYesYesBothYes
newYesYesYesBothYes
ngram_token_sizeYesYesYesGlobalNo
offline_modeYesYesYesGlobalYes
oldYesYesYesGlobalNo
old-alter-tableYesYes Yes
- Variable: old_alter_table YesBothYes
old_passwords YesBothYes
open-files-limitYesYes No
- Variable: open_files_limit YesGlobalNo
optimizer_prune_levelYesYesYesBothYes
optimizer_search_depthYesYesYesBothYes
optimizer_switchYesYesYesBothYes
optimizer_trace YesBothYes
optimizer_trace_features YesBothYes
optimizer_trace_limit YesBothYes
optimizer_trace_max_mem_size YesBothYes
optimizer_trace_offset YesBothYes
parser_max_mem_sizeYesYesYesBothYes
performance_schemaYesYesYesGlobalNo
performance_schema_accounts_sizeYesYesYesGlobalNo
performance_schema_digests_sizeYesYesYesGlobalNo
performance_schema_events_stages_history_long_sizeYesYesYesGlobalNo
performance_schema_events_stages_history_sizeYesYesYesGlobalNo
performance_schema_events_statements_history_long_sizeYesYesYesGlobalNo
performance_schema_events_statements_history_sizeYesYesYesGlobalNo
performance_schema_events_transactions_history_long_sizeYesYesYesGlobalNo
performance_schema_events_transactions_history_sizeYesYesYesGlobalNo
performance_schema_events_waits_history_long_sizeYesYesYesGlobalNo
performance_schema_events_waits_history_sizeYesYesYesGlobalNo
performance_schema_hosts_sizeYesYesYesGlobalNo
performance_schema_max_cond_classesYesYesYesGlobalNo
performance_schema_max_cond_instancesYesYesYesGlobalNo
performance_schema_max_digest_lengthYesYesYesGlobalNo
performance_schema_max_file_classesYesYesYesGlobalNo
performance_schema_max_file_handlesYesYesYesGlobalNo
performance_schema_max_file_instancesYesYesYesGlobalNo
performance_schema_max_index_statYesYesYesGlobalNo
performance_schema_max_memory_classesYesYesYesGlobalNo
performance_schema_max_metadata_locksYesYesYesGlobalNo
performance_schema_max_mutex_classesYesYesYesGlobalNo
performance_schema_max_mutex_instancesYesYesYesGlobalNo
performance_schema_max_prepared_statements_instancesYesYesYesGlobalNo
performance_schema_max_program_instancesYesYesYesGlobalNo
performance_schema_max_rwlock_classesYesYesYesGlobalNo
performance_schema_max_rwlock_instancesYesYesYesGlobalNo
performance_schema_max_socket_classesYesYesYesGlobalNo
performance_schema_max_socket_instancesYesYesYesGlobalNo
performance_schema_max_sql_text_lengthYesYesYesGlobalNo
performance_schema_max_stage_classesYesYesYesGlobalNo
performance_schema_max_statement_classesYesYesYesGlobalNo
performance_schema_max_statement_stackYesYesYesGlobalNo
performance_schema_max_table_handlesYesYesYesGlobalNo
performance_schema_max_table_instancesYesYesYesGlobalNo
performance_schema_max_table_lock_statYesYesYesGlobalNo
performance_schema_max_thread_classesYesYesYesGlobalNo
performance_schema_max_thread_instancesYesYesYesGlobalNo
performance_schema_session_connect_attrs_sizeYesYesYesGlobalNo
performance_schema_setup_actors_sizeYesYesYesGlobalNo
performance_schema_setup_objects_sizeYesYesYesGlobalNo
performance_schema_users_sizeYesYesYesGlobalNo
pid-fileYesYes No
- Variable: pid_file YesGlobalNo
plugin_dirYesYesYesGlobalNo
portYesYesYesGlobalNo
preload_buffer_sizeYesYesYesBothYes
profiling YesBothYes
profiling_history_sizeYesYesYesBothYes
protocol_version YesGlobalNo
proxy_user YesSessionNo
pseudo_slave_mode YesSessionYes
pseudo_thread_id YesSessionYes
query_alloc_block_sizeYesYesYesBothYes
query_cache_limitYesYesYesGlobalYes
query_cache_min_res_unitYesYesYesGlobalYes
query_cache_sizeYesYesYesGlobalYes
query_cache_typeYesYesYesBothYes
query_cache_wlock_invalidateYesYesYesBothYes
query_prealloc_sizeYesYesYesBothYes
rand_seed1 YesSessionYes
rand_seed2 YesSessionYes
range_alloc_block_sizeYesYesYesBothYes
range_optimizer_max_mem_sizeYesYesYesBothYes
rbr_exec_mode YesSessionYes
read_buffer_sizeYesYesYesBothYes
read_onlyYesYesYesGlobalYes
read_rnd_buffer_sizeYesYesYesBothYes
relay-logYesYes No
- Variable: relay_log YesGlobalNo
relay_log_basename YesGlobalNo
relay-log-indexYesYes No
- Variable: relay_log_index YesGlobalNo
relay_log_indexYesYesYesGlobalNo
relay_log_info_fileYesYesYesGlobalNo
relay_log_info_repository YesGlobalYes
relay_log_purgeYesYesYesGlobalYes
relay_log_recoveryYesYesYesGlobalNo
relay_log_space_limitYesYesYesGlobalNo
report-hostYesYes No
- Variable: report_host YesGlobalNo
report-passwordYesYes No
- Variable: report_password YesGlobalNo
report-portYesYes No
- Variable: report_port YesGlobalNo
report-userYesYes No
- Variable: report_user YesGlobalNo
require_secure_transportYesYesYesGlobalYes
rewriter_enabled YesGlobalYes
rewriter_verbose YesGlobalYes
rpl_semi_sync_master_enabled YesGlobalYes
rpl_semi_sync_master_timeout YesGlobalYes
rpl_semi_sync_master_trace_level YesGlobalYes
rpl_semi_sync_master_wait_for_slave_count YesGlobalYes
rpl_semi_sync_master_wait_no_slave YesGlobalYes
rpl_semi_sync_master_wait_point YesGlobalYes
rpl_semi_sync_slave_enabled YesGlobalYes
rpl_semi_sync_slave_trace_level YesGlobalYes
rpl_stop_slave_timeoutYesYesYesGlobalYes
secure-authYesYes Yes
- Variable: secure_auth YesGlobalYes
secure-file-privYesYes No
- Variable: secure_file_priv YesGlobalNo
server-idYesYes Yes
- Variable: server_id YesGlobalYes
server-id-bitsYesYes No
- Variable: server_id_bits YesGlobalNo
server_id_bitsYesYesYesGlobalNo
server_uuid YesGlobalNo
session_track_gtidsYesYesYesBothYes
session_track_schemaYesYesYesBothYes
session_track_state_changeYesYesYesBothYes
session_track_system_variablesYesYesYesBothYes
sha256_password_auto_generate_rsa_keysYesYesYesGlobalNo
sha256_password_private_key_pathYesYesYesGlobalNo
sha256_password_proxy_usersYesYesYesGlobalYes
sha256_password_public_key_pathYesYesYesGlobalNo
shared_memoryYesYesYesGlobalNo
shared_memory_base_nameYesYesYesGlobalNo
show_compatibility_56YesYesYesGlobalYes
show_old_temporalsYesYesYesBothYes
simplified_binlog_gtid_recoveryYesYesYesGlobalNo
skip_external_lockingYesYesYesGlobalNo
skip-name-resolveYesYes No
- Variable: skip_name_resolve YesGlobalNo
skip-networkingYesYes No
- Variable: skip_networking YesGlobalNo
skip-show-databaseYesYes No
- Variable: skip_show_database YesGlobalNo
slave_allow_batchingYesYesYesGlobalYes
slave_checkpoint_groupYesYesYesGlobalYes
slave_checkpoint_periodYesYesYesGlobalYes
slave_compressed_protocolYesYesYesGlobalYes
slave_exec_modeYesYesYesGlobalYes
slave-load-tmpdirYesYes No
- Variable: slave_load_tmpdir YesGlobalNo
slave_max_allowed_packet YesGlobalYes
slave-net-timeoutYesYes Yes
- Variable: slave_net_timeout YesGlobalYes
slave_parallel_type YesGlobalYes
slave_parallel_workersYes YesGlobalYes
slave_pending_jobs_size_max YesGlobalYes
slave_preserve_commit_orderYes YesGlobalYes
slave_rows_search_algorithms YesGlobalYes
slave-skip-errorsYesYes No
- Variable: slave_skip_errors YesGlobalNo
slave_sql_verify_checksum YesGlobalYes
slave_transaction_retriesYesYesYesGlobalYes
slave_type_conversionsYesYesYesGlobalNo
slow_launch_timeYesYesYesGlobalYes
slow-query-logYesYes Yes
- Variable: slow_query_log YesGlobalYes
slow_query_log_fileYesYesYesGlobalYes
socketYesYesYesGlobalNo
sort_buffer_sizeYesYesYesBothYes
sql_auto_is_null YesBothYes
sql_big_selects YesBothYes
sql_buffer_result YesBothYes
sql_log_bin YesSessionYes
sql_log_off YesBothYes
sql-modeYesYes Yes
- Variable: sql_mode YesBothYes
sql_notes YesBothYes
sql_quote_show_create YesBothYes
sql_safe_updates YesBothYes
sql_select_limit YesBothYes
sql_slave_skip_counter YesGlobalYes
sql_warnings YesBothYes
ssl-caYesYes No
- Variable: ssl_ca YesGlobalNo
ssl-capathYesYes No
- Variable: ssl_capath YesGlobalNo
ssl-certYesYes No
- Variable: ssl_cert YesGlobalNo
ssl-cipherYesYes No
- Variable: ssl_cipher YesGlobalNo
ssl-crlYesYes No
- Variable: ssl_crl YesGlobalNo
ssl-crlpathYesYes No
- Variable: ssl_crlpath YesGlobalNo
ssl-keyYesYes No
- Variable: ssl_key YesGlobalNo
storage_engine YesBothYes
stored_program_cacheYesYesYesGlobalYes
super_read_onlyYesYesYesGlobalYes
sync_binlogYesYesYesGlobalYes
sync_frmYesYesYesGlobalYes
sync_master_infoYesYesYesGlobalYes
sync_relay_logYesYesYesGlobalYes
sync_relay_log_infoYesYesYesGlobalYes
system_time_zone YesGlobalNo
table_definition_cache YesGlobalYes
table_open_cache YesGlobalYes
table_open_cache_instances YesGlobalNo
thread_cache_sizeYesYesYesGlobalYes
thread_concurrencyYesYesYesGlobalNo
thread_handlingYesYesYesGlobalNo
thread_pool_algorithmYesYesYesGlobalNo
thread_pool_high_priority_connectionYesYesYesBothYes
thread_pool_max_unused_threadsYesYesYesGlobalYes
thread_pool_prio_kickup_timerYesYesYesBothYes
thread_pool_sizeYesYesYesGlobalNo
thread_pool_stall_limitYesYesYesGlobalYes
thread_stackYesYesYesGlobalNo
time_format YesGlobalNo
time_zone YesBothYes
timed_mutexesYesYesYesGlobalYes
timestamp YesSessionYes
tls_versionYesYesYesGlobalNo
tmp_table_sizeYesYesYesBothYes
tmpdirYesYesYesGlobalNo
transaction_alloc_block_sizeYesYesYesBothYes
transaction_allow_batching YesSessionYes
transaction-isolationYesYes Yes
- Variable: tx_isolation YesBothYes
transaction_prealloc_sizeYesYesYesBothYes
transaction-read-onlyYesYes Yes
- Variable: tx_read_only YesBothYes
transaction_write_set_extractionYes YesBothYes
tx_isolation YesBothYes
tx_read_only YesBothYes
unique_checks YesBothYes
updatable_views_with_limitYesYesYesBothYes
validate_password_check_user_nameYesYesYesGlobalYes
validate_password_dictionary_file YesGlobalVaries
validate_password_length YesGlobalYes
validate_password_mixed_case_count YesGlobalYes
validate_password_number_count YesGlobalYes
validate_password_policy YesGlobalYes
validate_password_special_char_count YesGlobalYes
validate_user_plugins YesGlobalNo
version YesGlobalNo
version_comment YesGlobalNo
version_compile_machine YesGlobalNo
version_compile_os YesGlobalNo
version_tokens_sessionYesYesYesBothYes
version_tokens_session_numberYesYesYesBothNo
wait_timeoutYesYesYesBothYes
warning_count YesSessionNo

原文參照mysql官方文件:https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_basedir

相關文章