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
