Default value of all variables of mysql5.6.14 in Windows _ MySQL

Default value of all variables of mysql5.6.14 in win environment: bitsCN.com

Default values of all variables of mysql5.6.14 in win environment

In windows mysql5.6.14 x64, my. ini is as follows:

[Mysqld] port = 3306 socket =/tmp/mysql. sockbasedir = D:/wamp/mysqldatadir = D:/wamp/data5/tmpdir = D: /wamp/tmp/character-set-server = utf8wait_timeout = 60interactive_timeout = timeout = 0.0.0.0thread _ concurrency = disabled = Innodbslow-query-log = disabled = 0.01slow-query-log-file = slow. logserver-id = 1sql_mode = NO_ENGINE_SUBSTITUTION, and STRICT_TRANS_TABLES The following table lists the variables: init_file old_passwords 0 port 255.10server_id 1 version 5.6.14-runtime MySQL Community Server (GPL) without using Win64concurrent_insert into YEShave_crypt NOhave_openssl without have_symlink between ONlocal_infile without creating new Fread_only OFFskip_networking OFFbasedir D:/wamp/mysqldatadir D:/wamp/data5/innodb_data_file_path ibdata1: 12 M: 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/webt Est. export OFFlog_warnings before loading 0delay_key_write interval limit 1000 flush OFFflush_time 0long_query_time 2.000000low _ priority_updates limit 20max_join_size limit _ sort_length 1024max_write_lock _ Count 4294967295query_alloc_block_size 8192query_prealloc_size %2thread_cache_size %0max_error_count %1024preload_buffer_size ONsecure_auth ONshared_memory %mysqlstorage_engine InnoDBback_log 80connect_timeout 10interactive_timeout %100max_conn Ections when 0wait_timeout 60connect_timeout when there are already 60skip_networking when 3600wait_timeout 60skip_networking when OFFinit_connect init_slave log_warnings when 1max_sort_length when ONsql_mode when, NO_EN Limit 4096tx_isolation REPEATABLE-READcharacter_set_client utf8character_set_connection utf8character_set_database limit utf8character_set_server utf8character_set_system utf8collation_connection limit % Y-% m-% ddatetime_form At % 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 limit 32thread_stack limit 8Mnet_buffer_length 16Kread_buffer_size limit 100query_cache_limit limit ibdata1: 12 M: autoextendinnodb_fast_shutdown 1innodb_file_per_table 1_1innodb_flush_method innodb_force_recovery 0innodb_lock_wait_timeout 50innodb_log_buffer_size 8Minnodb_log_file_size too large. /commandid 1innodb_open_files when there were too many 1auto_increment_offset 1 autocommit when ONbig_tables OFFbind_address 0.0.0binlog _ checksum when 0binlog_order_commits ONbinlog_row_image when there were too many D: /wamp/mysql/share/charsets/completion_type NO_CHAINcore_file OFFdefault_storage_engine contains invalid variable when 10event_sched1_1_ongeneral_log OFFgeneral_log_file D:/wamp/data5/webtest. please refer to gtid_mode OFFgtid_owned gtid_purged when YEShave_geometry YEShave_profiling when YEShave_ssl when 279 hostname has already been used when there are already too many other attempts when there are too many other problems. when too many OFFinnodb_doublewrite ONinnodb_file_format when there are too many invalid innodb_old_blocks_pct when OFFinnodb_page_size invalid too many rows have been written into 4innodb_read_only OFFinnodb_replication_delay too many rows have been written into ONinnodb_stats_method too many rows offline innodb_support_xa too many 30innodb_table_locks too many innodb_undo_directory. innodb_undo_logs 128innodb_undo_tablespaces when using ONinnodb_version 5.6.14innodb _ write_io_threads 4keep_files_on_create OFFlarge_page_size 0large_pages OFFlc_messages limit D: /wamp/mysql/share/lc_time_names en_USlicense restart your log_bin_index when offline log_output when there are too many rows when 0multi_range_count when there are too many rows when OFFold limit 62optimizer_switch index_merge = on, index_merge_union = on, Condition = on, index_merge_intersection = on, Condition = on, index_condition_pushdown = on, mrr = on, mrr_cost_based = on, block_nested_loop = on, disable enabled = off, one_line = export greedy_search = on, range_optimizer = on, dynamic_range = on, repeated_subselect = 255.16koptimizer_trace_offset-1performance_schema limit 100plugin_dir D: /wamp/mysql/lib/plugin/profiling publish offline relay_log export relay_log_index export relay-log.inforelay_log_info_repository export 0report_host report_password report_port 3306report_user has been attached server_id_bits 32server_uuid has been too many then D: /wamp/tmp/slave_max_allowed_packet contains invalid parameter TABLE_SCAN, which indicates ONslave_transaction_retries 10slave_type_conversions slow_query_log ONslow_query_log_file slow. logsocket/tmp/mysql. please refer to the following link for more information: OFFssl_ca ssl_capath ssl_cert ssl_cipher ssl_crl ssl_crlpath ssl_key validation system_time_zone validation

BitsCN.com