win环境下mysql 5.7.15 x64变量默认值

my.ini为默认值，如下：

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = d:/wamp/mysql/
datadir = d:/wamp/mysql/data
port = 3306
#server_id = 1

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

导出的变量值为：

Variable_nameValueauto_increment_increment1auto_increment_offset1autocommitONautomatic_sp_privilegesONavoid_temporal_upgradeOFFback_log80basedird:\wamp\mysql\big_tablesOFFbind_address*binlog_cache_size32768binlog_checksumCRC32binlog_direct_non_transactional_updatesOFFbinlog_error_actionABORT_SERVERbinlog_formatROWbinlog_group_commit_sync_delay0binlog_group_commit_sync_no_delay_count0binlog_gtid_simple_recoveryONbinlog_max_flush_queue_time0binlog_order_commitsONbinlog_row_imageFULLbinlog_rows_query_log_eventsOFFbinlog_stmt_cache_size32768block_encryption_modeaes-128-ecbbulk_insert_buffer_size8388608character_set_clientutf8character_set_connectionutf8character_set_databaseutf8character_set_filesystembinarycharacter_set_resultsutf8character_set_serverlatin1character_set_systemutf8character_sets_dird:\wamp\mysql\share\charsets\check_proxy_usersOFFcollation_connectionutf8_general_cicollation_databaseutf8_general_cicollation_serverlatin1_swedish_cicompletion_typeNO_CHAINconcurrent_insertAUTOconnect_timeout10core_fileOFFdatadird:\wamp\mysql\data\date_format%Y-%m-%ddatetime_format%Y-%m-%d %H:%i:%sdefault_authentication_pluginmysql_native_passworddefault_password_lifetime0default_storage_engineInnoDBdefault_tmp_storage_engineInnoDBdefault_week_format0delay_key_writeONdelayed_insert_limit100delayed_insert_timeout300delayed_queue_size1000disabled_storage_engines disconnect_on_expired_passwordONdiv_precision_increment4end_markers_in_jsonOFFenforce_gtid_consistencyOFFeq_range_index_dive_limit200error_count0event_schedulerOFFexpire_logs_days0explicit_defaults_for_timestampOFFexternal_user flushOFFflush_time0foreign_key_checksONft_boolean_syntax+ -><()~*:""&|ft_max_word_len84ft_min_word_len4ft_query_expansion_limit20ft_stopword_file(built-in)general_logOFFgeneral_log_filed:\wamp\mysql\data\DESKTOP-FFRU10B.loggroup_concat_max_len1024gtid_executed_compression_period1000gtid_modeOFFgtid_nextAUTOMATICgtid_owned gtid_purged have_compressYEShave_cryptNOhave_dynamic_loadingYEShave_geometryYEShave_opensslDISABLEDhave_profilingYEShave_query_cacheYEShave_rtree_keysYEShave_sslDISABLEDhave_statement_timeoutYEShave_symlinkYEShost_cache_size279hostnameDESKTOP-FFRU10Bidentity0ignore_builtin_innodbOFFignore_db_dirs init_connect init_file init_slave innodb_adaptive_flushingONinnodb_adaptive_flushing_lwm10innodb_adaptive_hash_indexONinnodb_adaptive_hash_index_parts8innodb_adaptive_max_sleep_delay150000innodb_api_bk_commit_interval5innodb_api_disable_rowlockOFFinnodb_api_enable_binlogOFFinnodb_api_enable_mdlOFFinnodb_api_trx_level0innodb_autoextend_increment64innodb_autoinc_lock_mode1innodb_buffer_pool_chunk_size134217728innodb_buffer_pool_dump_at_shutdownONinnodb_buffer_pool_dump_nowOFFinnodb_buffer_pool_dump_pct25innodb_buffer_pool_filenameib_buffer_poolinnodb_buffer_pool_instances1innodb_buffer_pool_load_abortOFFinnodb_buffer_pool_load_at_startupONinnodb_buffer_pool_load_nowOFFinnodb_buffer_pool_size134217728innodb_change_buffer_max_size25innodb_change_bufferingallinnodb_checksum_algorithmcrc32innodb_checksumsONinnodb_cmp_per_index_enabledOFFinnodb_commit_concurrency0innodb_compression_failure_threshold_pct5innodb_compression_level6innodb_compression_pad_pct_max50innodb_concurrency_tickets5000innodb_data_file_pathibdata1:12M:autoextendinnodb_data_home_dir innodb_deadlock_detectONinnodb_default_row_formatdynamicinnodb_disable_sort_file_cacheOFFinnodb_doublewriteONinnodb_fast_shutdown1innodb_file_formatBarracudainnodb_file_format_checkONinnodb_file_format_maxBarracudainnodb_file_per_tableONinnodb_fill_factor100innodb_flush_log_at_timeout1innodb_flush_log_at_trx_commit1innodb_flush_method innodb_flush_neighbors1innodb_flush_syncONinnodb_flushing_avg_loops30innodb_force_load_corruptedOFFinnodb_force_recovery0innodb_ft_aux_table innodb_ft_cache_size8000000innodb_ft_enable_diag_printOFFinnodb_ft_enable_stopwordONinnodb_ft_max_token_size84innodb_ft_min_token_size3innodb_ft_num_word_optimize2000innodb_ft_result_cache_limit2000000000innodb_ft_server_stopword_table innodb_ft_sort_pll_degree2innodb_ft_total_cache_size640000000innodb_ft_user_stopword_table innodb_io_capacity200innodb_io_capacity_max2000innodb_large_prefixONinnodb_lock_wait_timeout50innodb_locks_unsafe_for_binlogOFFinnodb_log_buffer_size16777216innodb_log_checksumsONinnodb_log_compressed_pagesONinnodb_log_file_size50331648innodb_log_files_in_group2innodb_log_group_home_dir.\innodb_log_write_ahead_size8192innodb_lru_scan_depth1024innodb_max_dirty_pages_pct75.000000innodb_max_dirty_pages_pct_lwm0.000000innodb_max_purge_lag0innodb_max_purge_lag_delay0innodb_max_undo_log_size1073741824innodb_monitor_disable innodb_monitor_enable innodb_monitor_reset innodb_monitor_reset_all innodb_old_blocks_pct37innodb_old_blocks_time1000innodb_online_alter_log_max_size134217728innodb_open_files2000innodb_optimize_fulltext_onlyOFFinnodb_page_cleaners1innodb_page_size16384innodb_print_all_deadlocksOFFinnodb_purge_batch_size300innodb_purge_rseg_truncate_frequency128innodb_purge_threads4innodb_random_read_aheadOFFinnodb_read_ahead_threshold56innodb_read_io_threads4innodb_read_onlyOFFinnodb_replication_delay0innodb_rollback_on_timeoutOFFinnodb_rollback_segments128innodb_sort_buffer_size1048576innodb_spin_wait_delay6innodb_stats_auto_recalcONinnodb_stats_methodnulls_equalinnodb_stats_on_metadataOFFinnodb_stats_persistentONinnodb_stats_persistent_sample_pages20innodb_stats_sample_pages8innodb_stats_transient_sample_pages8innodb_status_outputOFFinnodb_status_output_locksOFFinnodb_strict_modeONinnodb_support_xaONinnodb_sync_array_size1innodb_sync_spin_loops30innodb_table_locksONinnodb_temp_data_file_pathibtmp1:12M:autoextendinnodb_thread_concurrency0innodb_thread_sleep_delay10000innodb_tmpdir innodb_undo_directory.\innodb_undo_log_truncateOFFinnodb_undo_logs128innodb_undo_tablespaces0innodb_use_native_aioONinnodb_version5.7.15innodb_write_io_threads4insert_id0interactive_timeout28800internal_tmp_disk_storage_engineInnoDBjoin_buffer_size262144keep_files_on_createOFFkey_buffer_size8388608key_cache_age_threshold300key_cache_block_size1024key_cache_division_limit100large_files_supportONlarge_page_size0large_pagesOFFlast_insert_id0lc_messagesen_USlc_messages_dird:\wamp\mysql\share\lc_time_namesen_USlicenseGPLlocal_infileONlock_wait_timeout31536000log_binOFFlog_bin_basename log_bin_index log_bin_trust_function_creatorsOFFlog_bin_use_v1_row_eventsOFFlog_builtin_as_identified_by_passwordOFFlog_errord:\wamp\mysql\data\DESKTOP-FFRU10B.errlog_error_verbosity3log_outputFILElog_queries_not_using_indexesOFFlog_slave_updatesOFFlog_slow_admin_statementsOFFlog_slow_slave_statementsOFFlog_statements_unsafe_for_binlogONlog_syslogONlog_syslog_tag log_throttle_queries_not_using_indexes0log_timestampsUTClog_warnings2long_query_time10.000000low_priority_updatesOFFlower_case_file_systemONlower_case_table_names1master_info_repositoryFILEmaster_verify_checksumOFFmax_allowed_packet4194304max_binlog_cache_size18446744073709547520max_binlog_size1073741824max_binlog_stmt_cache_size18446744073709547520max_connect_errors100max_connections151max_delayed_threads20max_digest_length1024max_error_count64max_execution_time0max_heap_table_size16777216max_insert_delayed_threads20max_join_size18446744073709551615max_length_for_sort_data1024max_points_in_geometry65536max_prepared_stmt_count16382max_relay_log_size0max_seeks_for_key4294967295max_sort_length1024max_sp_recursion_depth0max_tmp_tables32max_user_connections0max_write_lock_count4294967295metadata_locks_cache_size1024metadata_locks_hash_instances8min_examined_row_limit0multi_range_count256myisam_data_pointer_size6myisam_max_sort_file_size2146435072myisam_mmap_size18446744073709551615myisam_recover_optionsOFFmyisam_repair_threads1myisam_sort_buffer_size8388608myisam_stats_methodnulls_unequalmyisam_use_mmapOFFmysql_native_password_proxy_usersOFFnamed_pipeOFFnet_buffer_length16384net_read_timeout30net_retry_count10net_write_timeout60newOFFngram_token_size2offline_modeOFFoldOFFold_alter_tableOFFold_passwords0open_files_limit7048optimizer_prune_level1optimizer_search_depth62optimizer_switchindex_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=onoptimizer_traceenabled=off,one_line=offoptimizer_trace_featuresgreedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=onoptimizer_trace_limit1optimizer_trace_max_mem_size16384optimizer_trace_offset-1parser_max_mem_size18446744073709551615performance_schemaONperformance_schema_accounts_size-1performance_schema_digests_size10000performance_schema_events_stages_history_long_size10000performance_schema_events_stages_history_size10performance_schema_events_statements_history_long_size10000performance_schema_events_statements_history_size10performance_schema_events_transactions_history_long_size10000performance_schema_events_transactions_history_size10performance_schema_events_waits_history_long_size10000performance_schema_events_waits_history_size10performance_schema_hosts_size-1performance_schema_max_cond_classes80performance_schema_max_cond_instances-1performance_schema_max_digest_length1024performance_schema_max_file_classes80performance_schema_max_file_handles32768performance_schema_max_file_instances-1performance_schema_max_index_stat-1performance_schema_max_memory_classes320performance_schema_max_metadata_locks-1performance_schema_max_mutex_classes200performance_schema_max_mutex_instances-1performance_schema_max_prepared_statements_instances-1performance_schema_max_program_instances-1performance_schema_max_rwlock_classes40performance_schema_max_rwlock_instances-1performance_schema_max_socket_classes10performance_schema_max_socket_instances-1performance_schema_max_sql_text_length1024performance_schema_max_stage_classes150performance_schema_max_statement_classes193performance_schema_max_statement_stack10performance_schema_max_table_handles-1performance_schema_max_table_instances-1performance_schema_max_table_lock_stat-1performance_schema_max_thread_classes50performance_schema_max_thread_instances-1performance_schema_session_connect_attrs_size512performance_schema_setup_actors_size-1performance_schema_setup_objects_size-1performance_schema_users_size-1pid_filed:\wamp\mysql\data\DESKTOP-FFRU10B.pidplugin_dird:\wamp\mysql\lib\plugin\port3306preload_buffer_size32768profilingOFFprofiling_history_size15protocol_version10proxy_user pseudo_slave_modeOFFpseudo_thread_id6query_alloc_block_size8192query_cache_limit1048576query_cache_min_res_unit4096query_cache_size1048576query_cache_typeOFFquery_cache_wlock_invalidateOFFquery_prealloc_size8192rand_seed10rand_seed20range_alloc_block_size4096range_optimizer_max_mem_size8388608rbr_exec_modeSTRICTread_buffer_size131072read_onlyOFFread_rnd_buffer_size262144relay_log relay_log_basename relay_log_index relay_log_info_filerelay-log.inforelay_log_info_repositoryFILErelay_log_purgeONrelay_log_recoveryOFFrelay_log_space_limit0report_host report_password report_port3306report_user require_secure_transportOFFrpl_stop_slave_timeout31536000secure_authONsecure_file_priv server_id0server_id_bits32server_uuid5e344b6d-8164-11e6-a215-40167e219a3dsession_track_gtidsOFFsession_track_schemaONsession_track_state_changeOFFsession_track_system_variablestime_zone,autocommit,character_set_client,character_set_results,character_set_connectionsession_track_transaction_infoOFFsha256_password_proxy_usersOFFshared_memoryOFFshared_memory_base_nameMYSQLshow_compatibility_56OFFshow_old_temporalsOFFskip_external_lockingONskip_name_resolveOFFskip_networkingOFFskip_show_databaseOFFslave_allow_batchingOFFslave_checkpoint_group512slave_checkpoint_period300slave_compressed_protocolOFFslave_exec_modeSTRICTslave_load_tmpdirC:\Windows\TEMPslave_max_allowed_packet1073741824slave_net_timeout60slave_parallel_typeDATABASEslave_parallel_workers0slave_pending_jobs_size_max16777216slave_preserve_commit_orderOFFslave_rows_search_algorithmsTABLE_SCAN,INDEX_SCANslave_skip_errorsOFFslave_sql_verify_checksumONslave_transaction_retries10slave_type_conversions slow_launch_time2slow_query_logOFFslow_query_log_filed:\wamp\mysql\data\DESKTOP-FFRU10B-slow.logsocketMySQLsort_buffer_size262144sql_auto_is_nullOFFsql_big_selectsONsql_buffer_resultOFFsql_log_binONsql_log_offOFFsql_modeSTRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTIONsql_notesONsql_quote_show_createONsql_safe_updatesOFFsql_select_limit18446744073709551615sql_slave_skip_counter0sql_warningsOFFssl_ca ssl_capath ssl_cert ssl_cipher ssl_crl ssl_crlpath ssl_key stored_program_cache256super_read_onlyOFFsync_binlog1sync_frmONsync_master_info10000sync_relay_log10000sync_relay_log_info10000system_time_zone table_definition_cache1400table_open_cache2000table_open_cache_instances16thread_cache_size9thread_handlingone-thread-per-connectionthread_stack262144time_format%H:%i:%stime_zoneSYSTEMtimestamp1474618044.062102tls_versionTLSv1,TLSv1.1tmp_table_size16777216tmpdirC:\Windows\TEMPtransaction_alloc_block_size8192transaction_allow_batchingOFFtransaction_prealloc_size4096transaction_write_set_extractionOFFtx_isolationREPEATABLE-READtx_read_onlyOFFunique_checksONupdatable_views_with_limitYESversion5.7.15version_commentMySQL Community Server (GPL)version_compile_machinex86_64version_compile_osWin64wait_timeout28800warning_count0