win环境下
mysql5.6.14的所有变量的默认值
在
windows mysql5.6.14 x64版本下my.ini如下：
[mysqld] port = 3306 socket = /tmp/mysql.sock basedir=D:/wamp/mysql datadir=D:/wamp/data5/ tmpdir=D:/wamp/tmp/ character-set-server=utf8 wait_timeout=60 interactive_timeout=30 skip-name-resolve bind-address=0.0.0.0 thread_concurrency =4 default-storage-engine = Innodb slow-query-log=1 long_query_time = 0.01 slow-query-log-file=slow.log server-id = 1 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 通过工具查看的mysql的所有变量如下： init_file old_passwords 0 port 3306 protocol_version 10 server_id 1 version 5.6.14-log version_comment MySQL Community Server (GPL) version_compile_machine x86_64 version_compile_os Win64 concurrent_insert AUTO have_compress YES have_crypt NO have_openssl DISABLED have_query_cache YES have_symlink YES large_files_support ON local_infile ON low_priority_updates OFF lower_case_table_names 1 named_pipe OFF new OFF read_only OFF skip_networking OFF basedir D:/wamp/mysql datadir D:\wamp\data5\ innodb_data_file_path ibdata1:12M:autoextend innodb_log_group_home_dir .\ log_error D:\wamp\data5\webtest.err open_files_limit 7048 pid_file D:\wamp\data5\webtest.pid tmpdir D:/wamp/tmp/ innodb_log_buffer_size 8M innodb_log_file_size 48M innodb_log_files_in_group 2 innodb_log_group_home_dir .\ log_bin OFF log_error D:\wamp\data5\webtest.err log_slave_updates OFF log_warnings 1 max_binlog_cache_size 17592186044416M max_binlog_size 1024M max_relay_log_size0 delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 0 long_query_time 2.000000 low_priority_updates OFF max_delayed_threads 20 max_join_size 17592186044416M max_seeks_for_key 4095.99999904632M max_sort_length 1024 max_write_lock_count 4294967295 query_alloc_block_size 8192 query_prealloc_size 8192 range_alloc_block_size 4096 slow_launch_time 2 thread_cache_size 9 expire_logs_days 0 max_error_count 64 max_length_for_sort_data 1024 preload_buffer_size 32K relay_log_purge ON secure_auth ON shared_memory OFF shared_memory_base_name MYSQL storage_engine InnoDB back_log 80 connect_timeout 10 interactive_timeout 30 max_connect_errors 100 max_connections 151 max_user_connections 0 wait_timeout 60 connect_timeout 10 max_allowed_packet 4194304 named_pipe OFF net_read_timeout 30 net_retry_count 10 net_write_timeout 60 skip_networking OFF slave_net_timeout 3600 wait_timeout 60 skip_networking OFF skip_show_database OFF init_connect init_slave log_warnings 1 lower_case_table_names 1 max_sort_length 1024 skip_external_locking ON sql_mode STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION transaction_alloc_block_size 8192 transaction_prealloc_size 4096 tx_isolation REPEATABLE-READ character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_results utf8 character_set_server utf8 character_set_system utf8 collation_connection utf8_general_ci collation_database utf8_general_ci collation_server utf8_general_ci date_format %Y-%m-%d