时间：2021-07-01 10:21:17 帮助过：7人阅读
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