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               + -><()~*:""&|ft_max_word_len                 84ft_min_word_len                 4ft_query_expansion_limit        20ft_stopword_file                (built-in)max_heap_table_size             16777216max_tmp_tables                  32thread_stack                    262144tmp_table_size                  16777216bulk_insert_buffer_size         8388608innodb_additional_mem_pool_size 8388608innodb_buffer_pool_size         134217728innodb_log_buffer_size          8388608join_buffer_size                131072key_buffer_size                 8388608myisam_sort_buffer_size         8388608net_buffer_length               16384read_buffer_size                131072read_rnd_buffer_size            262144sort_buffer_size                2097152binlog_cache_size               32768key_cache_age_threshold         300key_cache_block_size            1024key_cache_pision_limit        100query_cache_limit               1048576query_cache_min_res_unit        4096query_cache_size                0query_cache_type                ONhave_innodb                     YESinnodb_additional_mem_pool_size 8388608innodb_buffer_pool_size         134217728innodb_data_file_path           ibdata1:10M:autoextendinnodb_fast_shutdown            1innodb_file_per_table           OFFinnodb_flush_log_at_trx_commit  1innodb_flush_method             innodb_force_recovery           0innodb_lock_wait_timeout        50innodb_log_buffer_size          8388608innodb_log_file_size            5242880innodb_log_files_in_group       2innodb_log_group_home_dir       ./innodb_max_dirty_pages_pct      75innodb_mirrored_log_groups      1innodb_open_files               300innodb_thread_concurrency       0myisam_max_sort_file_size       2146435072myisam_recover_options          OFFmyisam_repair_threads           1auto_increment_increment        1auto_increment_offset           1autocommit                      ONautomatic_sp_privileges         ONbig_tables                      OFFbinlog_direct_non_transactional_OFFbinlog_format                   STATEMENTbinlog_stmt_cache_size          32768character_set_filesystem        binarycharacter_sets_dir              D:/wamp2/mysql/share/charsets/completion_type                 NO_CHAINdefault_storage_engine          InnoDBp_precision_increment         4engine_condition_pushdown       ONevent_scheduler                 OFFforeign_key_checks              ONgeneral_log                     OFFgeneral_log_file                D:/wamp2/mysql/data/webtest.loggroup_concat_max_len            1024have_csv                        YEShave_dynamic_loading            YEShave_geometry                   YEShave_ndbcluster                 NOhave_partitioning               YEShave_profiling                  YEShave_rtree_keys                 YEShave_ssl                        DISABLEDhostname                        webtestignore_builtin_innodb           OFFinnodb_adaptive_flushing        ONinnodb_adaptive_hash_index      ONinnodb_autoextend_increment     8innodb_autoinc_lock_mode        1innodb_buffer_pool_instances    1innodb_change_buffering         allinnodb_checksums                ONinnodb_commit_concurrency       0innodb_concurrency_tickets      500innodb_data_home_dir            innodb_doublewrite              ONinnodb_file_format              Antelopeinnodb_file_format_check        ONinnodb_file_format_max          Antelopeinnodb_force_load_corrupted     OFFinnodb_io_capacity              200innodb_large_prefix             OFFinnodb_locks_unsafe_for_binlog  OFFinnodb_max_purge_lag            0innodb_old_blocks_pct           37innodb_old_blocks_time          0innodb_print_all_deadlocks      OFFinnodb_purge_batch_size         20innodb_purge_threads            0innodb_random_read_ahead        OFFinnodb_read_ahead_threshold     56innodb_read_io_threads          4innodb_replication_delay        0innodb_rollback_on_timeout      OFFinnodb_rollback_segments        128innodb_spin_wait_delay          6innodb_stats_method             nulls_equalinnodb_stats_on_metadata        ONinnodb_stats_sample_pages       8innodb_strict_mode              OFFinnodb_support_xa               ONinnodb_sync_spin_loops          30innodb_table_locks              ONinnodb_thread_sleep_delay       10000innodb_use_native_aio           ONinnodb_use_sys_malloc           ONinnodb_version                  5.5.34innodb_write_io_threads         4keep_files_on_create            OFFlarge_page_size                 0large_pages                     OFFlc_messages                     en_USlc_messages_dir                 D:/wamp2/mysql/share/lc_time_names                   en_USlicense                         GPLlock_wait_timeout               31536000log_bin_trust_function_creators OFFlog_output                      FILElog_queries_not_using_indexes   OFFlower_case_file_system          ONmax_binlog_stmt_cache_size      18446744073709547520max_insert_delayed_threads      20max_long_data_size              1048576max_prepared_stmt_count         16382max_sp_recursion_depth          0metadata_locks_cache_size       1024min_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=onperformance_schema              OFFperformance_schema_events_waits_10000performance_schema_events_waits_10performance_schema_max_cond_clas80performance_schema_max_cond_inst1000performance_schema_max_file_clas50performance_schema_max_file_hand32768performance_schema_max_file_inst10000performance_schema_max_mutex_cla200performance_schema_max_mutex_ins1000000performance_schema_max_rwlock_cl30performance_schema_max_rwlock_in1000000performance_schema_max_table_han100000performance_schema_max_table_ins50000performance_schema_max_thread_cl50performance_schema_max_thread_in1000plugin_dir                      D:/wamp2/mysql/lib/plugin/profiling                       OFFprofiling_history_size          15query_cache_wlock_invalidate    OFFrelay_log                       relay_log_index                 relay_log_info_file             relay-log.inforelay_log_recovery              OFFrelay_log_space_limit           0report_host                     report_password                 report_port                     3307report_user                     secure_file_priv                skip_name_resolve               OFFslave_compressed_protocol       OFFslave_exec_mode                 STRICTslave_load_tmpdir               D:/wamp2/tmp/slave_max_allowed_packet        1073741824slave_skip_errors               OFFslave_transaction_retries       10slave_type_conversions          slow_query_log                  OFFslow_query_log_file             D:/wamp2/mysql/data/webtest-slow.logsocket                          MySQLsql_auto_is_null                OFFsql_big_selects                 ONsql_big_tables                  OFFsql_buffer_result               OFFsql_log_bin                     ONsql_log_off                     OFFsql_low_priority_updates        OFFsql_max_join_size               18446744073709551615sql_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_key                         stored_program_cache            256sync_binlog                     0sync_frm                        ONsync_master_info                0sync_relay_log                  0sync_relay_log_info             0system_time_zone                table_definition_cache          400table_open_cache                400thread_concurrency              10thread_handling                 one-thread-per-connectiontime_zone                       SYSTEMtimed_mutexes                   OFFunique_checks                   ONupdatable_views_with_limit      YES

 

bitsCN.com