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               + ->
 

						bitsCN.com