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
Quels sont les outils d'analyse des données ?
Comment vérifier l'adresse Mac
Tutoriel de configuration du mot de passe de démarrage de Windows 10
Comment utiliser définir
Comment récupérer les données du disque dur mobile
Que veut dire Kappa ?
Comment annuler après gitcommit
Les fichiers de programme peuvent-ils être supprimés ?
![[Web front-end] Démarrage rapide de Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
