win环境下mysql5.6.14的所有变量的默认值_MySQL

bitsCN.com

win环境下mysql5.6.14的所有变量的默认值

 

在windows mysql5.6.14 x64版本下my.ini如下：

 

[mysqld]port  = 3306socket  = /tmp/mysql.sockbasedir=D:/wamp/mysqldatadir=D:/wamp/data5/tmpdir=D:/wamp/tmp/character-set-server=utf8wait_timeout=60interactive_timeout=30skip-name-resolvebind-address=0.0.0.0thread_concurrency =4default-storage-engine = Innodbslow-query-log=1long_query_time = 0.01slow-query-log-file=slow.logserver-id = 1sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 通过工具查看的mysql的所有变量如下：init_file                       old_passwords                   0port                            3306protocol_version                10server_id                       1version                         5.6.14-logversion_comment                 MySQL Community Server (GPL)version_compile_machine         x86_64version_compile_os              Win64concurrent_insert               AUTOhave_compress                   YEShave_crypt                      NOhave_openssl                    DISABLEDhave_query_cache                YEShave_symlink                    YESlarge_files_support             ONlocal_infile                    ONlow_priority_updates            OFFlower_case_table_names          1named_pipe                      OFFnew                             OFFread_only                       OFFskip_networking                 OFFbasedir                         D:/wamp/mysqldatadir                         D:/wamp/data5/innodb_data_file_path           ibdata1:12M:autoextendinnodb_log_group_home_dir       ./log_error                       D:/wamp/data5/webtest.erropen_files_limit                7048pid_file                        D:/wamp/data5/webtest.pidtmpdir                          D:/wamp/tmp/innodb_log_buffer_size          8Minnodb_log_file_size            48Minnodb_log_files_in_group       2innodb_log_group_home_dir       ./log_bin                         OFFlog_error                       D:/wamp/data5/webtest.errlog_slave_updates               OFFlog_warnings                    1max_binlog_cache_size           17592186044416Mmax_binlog_size                 1024Mmax_relay_log_size              0delay_key_write                 ONdelayed_insert_limit            100delayed_insert_timeout          300delayed_queue_size              1000flush                           OFFflush_time                      0long_query_time                 2.000000low_priority_updates            OFFmax_delayed_threads             20max_join_size                   17592186044416Mmax_seeks_for_key               4095.99999904632Mmax_sort_length                 1024max_write_lock_count            4294967295query_alloc_block_size          8192query_prealloc_size             8192range_alloc_block_size          4096slow_launch_time                2thread_cache_size               9expire_logs_days                0max_error_count                 64max_length_for_sort_data        1024preload_buffer_size             32Krelay_log_purge                 ONsecure_auth                     ONshared_memory                   OFFshared_memory_base_name         MYSQLstorage_engine                  InnoDBback_log                        80connect_timeout                 10interactive_timeout             30max_connect_errors              100max_connections                 151max_user_connections            0wait_timeout                    60connect_timeout                 10max_allowed_packet              4194304named_pipe                      OFFnet_read_timeout                30net_retry_count                 10net_write_timeout               60skip_networking                 OFFslave_net_timeout               3600wait_timeout                    60skip_networking                 OFFskip_show_database              OFFinit_connect                    init_slave                      log_warnings                    1lower_case_table_names          1max_sort_length                 1024skip_external_locking           ONsql_mode                        STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTIONtransaction_alloc_block_size    8192transaction_prealloc_size       4096tx_isolation                    REPEATABLE-READcharacter_set_client            utf8character_set_connection        utf8character_set_database          utf8character_set_results           utf8character_set_server            utf8character_set_system            utf8collation_connection            utf8_general_cicollation_database              utf8_general_cicollation_server                utf8_general_cidate_format                     %Y-%m-%ddatetime_format                 %Y-%m-%d %H:%i:%sdefault_week_format             0time_format                     %H:%i:%sft_boolean_syntax               + -><()~*:""&|ft_max_word_len                 84ft_min_word_len                 4ft_query_expansion_limit        20ft_stopword_file                (built-in)max_heap_table_size             16Mmax_tmp_tables                  32thread_stack                    256Ktmp_table_size                  16Mbulk_insert_buffer_size         8Minnodb_additional_mem_pool_size 8Minnodb_buffer_pool_size         128Minnodb_log_buffer_size          8Mjoin_buffer_size                256Kkey_buffer_size                 8Mmyisam_sort_buffer_size         8Mnet_buffer_length               16Kread_buffer_size                128Kread_rnd_buffer_size            256Ksort_buffer_size                256Kbinlog_cache_size               32Kkey_cache_age_threshold         300key_cache_block_size            1024key_cache_pision_limit        100query_cache_limit               1Mquery_cache_min_res_unit        4Kquery_cache_size                1Mquery_cache_type                OFFinnodb_additional_mem_pool_size 8Minnodb_buffer_pool_size         128Minnodb_data_file_path           ibdata1:12M:autoextendinnodb_fast_shutdown            1innodb_file_per_table           ONinnodb_flush_log_at_trx_commit  1innodb_flush_method             innodb_force_recovery           0innodb_lock_wait_timeout        50innodb_log_buffer_size          8Minnodb_log_file_size            48Minnodb_log_files_in_group       2innodb_log_group_home_dir       ./innodb_max_dirty_pages_pct      75innodb_mirrored_log_groups      1innodb_open_files               2000innodb_thread_concurrency       0myisam_max_sort_file_size       2047Mmyisam_recover_options          OFFmyisam_repair_threads           1auto_increment_increment        1auto_increment_offset           1autocommit                      ONautomatic_sp_privileges         ONbig_tables                      OFFbind_address                    0.0.0.0binlog_checksum                 CRC32binlog_direct_non_transactional_OFFbinlog_format                   STATEMENTbinlog_max_flush_queue_time     0binlog_order_commits            ONbinlog_row_image                FULLbinlog_rows_query_log_events    OFFbinlog_stmt_cache_size          32Kcharacter_set_filesystem        binarycharacter_sets_dir              D:/wamp/mysql/share/charsets/completion_type                 NO_CHAINcore_file                       OFFdefault_storage_engine          InnoDBdefault_tmp_storage_engine      InnoDBdisconnect_on_expired_password  ONp_precision_increment         4end_markers_in_json             OFFenforce_gtid_consistency        OFFeq_range_index_pe_limit       10event_scheduler                 OFFexplicit_defaults_for_timestamp OFFforeign_key_checks              ONgeneral_log                     OFFgeneral_log_file                D:/wamp/data5/webtest.loggroup_concat_max_len            1024gtid_executed                   gtid_mode                       OFFgtid_owned                      gtid_purged                     have_dynamic_loading            YEShave_geometry                   YEShave_profiling                  YEShave_rtree_keys                 YEShave_ssl                        DISABLEDhost_cache_size                 279hostname                        webtestignore_builtin_innodb           OFFignore_db_dirs                  innodb_adaptive_flushing        ONinnodb_adaptive_flushing_lwm    10innodb_adaptive_hash_index      ONinnodb_adaptive_max_sleep_delay 150000innodb_api_bk_commit_interval   5innodb_api_disable_rowlock      OFFinnodb_api_enable_binlog        OFFinnodb_api_enable_mdl           OFFinnodb_api_trx_level            0innodb_autoextend_increment     64innodb_autoinc_lock_mode        1innodb_buffer_pool_dump_at_shutdOFFinnodb_buffer_pool_dump_now     OFFinnodb_buffer_pool_filename     ib_buffer_poolinnodb_buffer_pool_instances    8innodb_buffer_pool_load_abort   OFFinnodb_buffer_pool_load_at_startOFFinnodb_buffer_pool_load_now     OFFinnodb_change_buffer_max_size   25innodb_change_buffering         allinnodb_checksum_algorithm       innodbinnodb_checksums                ONinnodb_cmp_per_index_enabled    OFFinnodb_commit_concurrency       0innodb_compression_failure_thres5innodb_compression_level        6innodb_compression_pad_pct_max  50innodb_concurrency_tickets      5000innodb_data_home_dir            innodb_disable_sort_file_cache  OFFinnodb_doublewrite              ONinnodb_file_format              Antelopeinnodb_file_format_check        ONinnodb_file_format_max          Antelopeinnodb_flush_log_at_timeout     1innodb_flush_neighbors          1innodb_flushing_avg_loops       30innodb_force_load_corrupted     OFFinnodb_ft_aux_table             innodb_ft_cache_size            8000000innodb_ft_enable_diag_print     OFFinnodb_ft_enable_stopword       ONinnodb_ft_max_token_size        84innodb_ft_min_token_size        3innodb_ft_num_word_optimize     2000innodb_ft_result_cache_limit    2000000000innodb_ft_server_stopword_table innodb_ft_sort_pll_degree       2innodb_ft_total_cache_size      640000000innodb_ft_user_stopword_table   innodb_io_capacity              200innodb_io_capacity_max          2000innodb_large_prefix             OFFinnodb_locks_unsafe_for_binlog  OFFinnodb_log_compressed_pages     ONinnodb_lru_scan_depth           1024innodb_max_dirty_pages_pct_lwm  0innodb_max_purge_lag            0innodb_max_purge_lag_delay      0innodb_monitor_disable          innodb_monitor_enable           innodb_monitor_reset            innodb_monitor_reset_all        innodb_old_blocks_pct           37innodb_old_blocks_time          1000innodb_online_alter_log_max_size128Minnodb_optimize_fulltext_only   OFFinnodb_page_size                16Kinnodb_print_all_deadlocks      OFFinnodb_purge_batch_size         300innodb_purge_threads            1innodb_random_read_ahead        OFFinnodb_read_ahead_threshold     56innodb_read_io_threads          4innodb_read_only                OFFinnodb_replication_delay        0innodb_rollback_on_timeout      OFFinnodb_rollback_segments        128innodb_sort_buffer_size         1Minnodb_spin_wait_delay          6innodb_stats_auto_recalc        ONinnodb_stats_method             nulls_equalinnodb_stats_on_metadata        OFFinnodb_stats_persistent         ONinnodb_stats_persistent_sample_p20innodb_stats_sample_pages       8innodb_stats_transient_sample_pa8innodb_strict_mode              OFFinnodb_support_xa               ONinnodb_sync_array_size          1innodb_sync_spin_loops          30innodb_table_locks              ONinnodb_thread_sleep_delay       10000innodb_undo_directory           .innodb_undo_logs                128innodb_undo_tablespaces         0innodb_use_native_aio           ONinnodb_use_sys_malloc           ONinnodb_version                  5.6.14innodb_write_io_threads         4keep_files_on_create            OFFlarge_page_size                 0large_pages                     OFFlc_messages                     en_USlc_messages_dir                 D:/wamp/mysql/share/lc_time_names                   en_USlicense                         GPLlock_wait_timeout               31536000log_bin_basename                log_bin_index                   log_bin_trust_function_creators OFFlog_bin_use_v1_row_events       OFFlog_output                      FILElog_queries_not_using_indexes   OFFlog_slow_admin_statements       OFFlog_slow_slave_statements       OFFlog_throttle_queries_not_using_i0lower_case_file_system          ONmaster_info_repository          FILEmaster_verify_checksum          OFFmax_binlog_stmt_cache_size      18446744073709547520max_insert_delayed_threads      20max_prepared_stmt_count         16382max_sp_recursion_depth          0metadata_locks_cache_size       1024metadata_locks_hash_instances   8min_examined_row_limit          0multi_range_count               256myisam_data_pointer_size        6myisam_mmap_size                18446744073709551615myisam_stats_method             nulls_unequalmyisam_use_mmap                 OFFold                             OFFold_alter_table                 OFFoptimizer_prune_level           1optimizer_search_depth          62optimizer_switch                index_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,batchedoptimizer_trace                 enabled=off,one_line=offoptimizer_trace_features        greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=onoptimizer_trace_limit           1optimizer_trace_max_mem_size    16Koptimizer_trace_offset          -1performance_schema              ONperformance_schema_accounts_size100performance_schema_digests_size 10000performance_schema_events_stages10000performance_schema_events_stages10performance_schema_events_statem10000performance_schema_events_statem10performance_schema_events_waits_10000performance_schema_events_waits_10performance_schema_hosts_size   100performance_schema_max_cond_clas80performance_schema_max_cond_inst3504performance_schema_max_file_clas50performance_schema_max_file_hand32768performance_schema_max_file_inst7693performance_schema_max_mutex_cla200performance_schema_max_mutex_ins15906performance_schema_max_rwlock_cl30performance_schema_max_rwlock_in9102performance_schema_max_socket_cl10performance_schema_max_socket_in322performance_schema_max_stage_cla150performance_schema_max_statement168performance_schema_max_table_han4000performance_schema_max_table_ins12500performance_schema_max_thread_cl50performance_schema_max_thread_in402performance_schema_session_conne512performance_schema_setup_actors_100performance_schema_setup_objects100performance_schema_users_size   100plugin_dir                      D:/wamp/mysql/lib/plugin/profiling                       OFFprofiling_history_size          15query_cache_wlock_invalidate    OFFrelay_log                       relay_log_basename              relay_log_index                 relay_log_info_file             relay-log.inforelay_log_info_repository       FILErelay_log_recovery              OFFrelay_log_space_limit           0report_host                     report_password                 report_port                     3306report_user                     rpl_stop_slave_timeout          31536000secure_file_priv                server_id_bits                  32server_uuid                     2ab70a0e-a1c4-11e2-9c60-60eb69d711caskip_name_resolve               ONslave_allow_batching            OFFslave_checkpoint_group          512slave_checkpoint_period         300slave_compressed_protocol       OFFslave_exec_mode                 STRICTslave_load_tmpdir               D:/wamp/tmp/slave_max_allowed_packet        1073741824slave_parallel_workers          0slave_pending_jobs_size_max     16777216slave_rows_search_algorithms    TABLE_SCAN,INDEX_SCANslave_skip_errors               OFFslave_sql_verify_checksum       ONslave_transaction_retries       10slave_type_conversions          slow_query_log                  ONslow_query_log_file             slow.logsocket                          /tmp/mysql.socksql_auto_is_null                OFFsql_big_selects                 ONsql_buffer_result               OFFsql_log_bin                     ONsql_log_off                     OFFsql_notes                       ONsql_quote_show_create           ONsql_safe_updates                OFFsql_select_limit                18446744073709551615sql_slave_skip_counter          0sql_warnings                    OFFssl_ca                          ssl_capath                      ssl_cert                        ssl_cipher                      ssl_crl                         ssl_crlpath                     ssl_key                         stored_program_cache            256sync_binlog                     0sync_frm                        ONsync_master_info                10000sync_relay_log                  10000sync_relay_log_info             10000system_time_zone                table_definition_cache          1400table_open_cache                2000table_open_cache_instances      1thread_concurrency              4thread_handling                 one-thread-per-connectiontime_zone                       SYSTEMtimed_mutexes                   OFFtx_read_only                    OFFunique_checks                   ONupdatable_views_with_limit      YES

 

bitsCN.com