win环境下mysql5.5.34x64社区版所有变量的默认值_MySQL

bitsCN.com

win环境下mysql5.5.34x64社区版所有变量的默认值

my.ini文件内容：

[mysqld]port  = 3307basedir=D:/wamp2/mysqltmpdir=D:/wamp2/tmp/sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

变量的默认值：

init_file                       old_passwords                   OFFport                            3307protocol_version                10server_id                       0version                         5.5.34version_comment                 MySQL Community Server (GPL)version_compile_machine         x86version_compile_os              Win64concurrent_insert               AUTOhave_compress                   YEShave_crypt                      NOhave_innodb                     YEShave_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:/wamp2/mysqldatadir                         D:/wamp2/mysql/data/innodb_data_file_path           ibdata1:10M:autoextendinnodb_log_group_home_dir       ./log_error                       D:/wamp2/mysql/data/webtest.erropen_files_limit                3009pid_file                        D:/wamp2/mysql/data/webtest.pidtmpdir                          D:/wamp2/tmp/innodb_log_buffer_size          8388608innodb_log_file_size            5242880innodb_log_files_in_group       2innodb_log_group_home_dir       ./log                             OFFlog_bin                         OFFlog_error                       D:/wamp2/mysql/data/webtest.errlog_slave_updates               OFFlog_slow_queries                OFFlog_warnings                    1max_binlog_cache_size           18446744073709547520max_binlog_size                 1073741824max_relay_log_size              0rpl_recovery_rank               0delay_key_write                 ONdelayed_insert_limit            100delayed_insert_timeout          300delayed_queue_size              1000flush                           OFFflush_time                      1800long_query_time                 10.000000low_priority_updates            OFFmax_delayed_threads             20max_join_size                   18446744073709551615max_seeks_for_key               4294967295max_sort_length                 1024max_write_lock_count            4294967295query_alloc_block_size          8192query_prealloc_size             8192range_alloc_block_size          4096slow_launch_time                2thread_cache_size               0expire_logs_days                0max_error_count                 64max_length_for_sort_data        1024preload_buffer_size             32768relay_log_purge                 ONsecure_auth                     OFFshared_memory                   OFFshared_memory_base_name         MYSQLstorage_engine                  InnoDBback_log                        50connect_timeout                 10interactive_timeout             28800max_connect_errors              10max_connections                 151max_user_connections            0wait_timeout                    28800connect_timeout                 10max_allowed_packet              1048576named_pipe                      OFFnet_read_timeout                30net_retry_count                 10net_write_timeout               60skip_networking                 OFFslave_net_timeout               3600wait_timeout                    28800skip_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            latin1character_set_connection        latin1character_set_database          latin1character_set_results           latin1character_set_server            latin1character_set_system            utf8collation_connection            latin1_swedish_cicollation_database              latin1_swedish_cicollation_server                latin1_swedish_cidate_format                     %Y-%m-%ddatetime_format                 %Y-%m-%d %H:%i:%sdefault_week_format             0time_format                     %H:%i:%sft_boolean_syntax               + ->
 

						bitsCN.com