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

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

my.ini文件内容：[mysqld]

port = 3307

basedir=D:/wamp2/mysql

tmpdir=D:/wamp2/tmp/

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

变量的默认值：

init_file

old_passwords OFF

port 3307

protocol_version 10

server_id 0

version 5.5.34

version_comment MySQL Community Server (GPL)

version_compile_machine x86

version_compile_os Win64

concurrent_insert AUTO

have_compress YES

have_crypt NO

have_innodb YES

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:/wamp2/mysql

datadir D:wamp2mysqldata

innodb_data_file_path ibdata1:10M:autoextend

innodb_log_group_home_dir .

log_error D:wamp2mysqldatawebtest.err

open_files_limit 3009

pid_file D:wamp2mysqldatawebtest.pid

tmpdir D:/wamp2/tmp/

innodb_log_buffer_size 8388608

innodb_log_file_size 5242880

innodb_log_files_in_group 2

innodb_log_group_home_dir .

log OFF

log_bin OFF

log_error D:wamp2mysqldatawebtest.err

log_slave_updates OFF

log_slow_queries OFF

log_warnings 1

max_binlog_cache_size 18446744073709547520

max_binlog_size 1073741824

max_relay_log_size 0

rpl_recovery_rank 0

delay_key_write ON

delayed_insert_limit 100

delayed_insert_timeout 300

delayed_queue_size 1000

flush OFF

flush_time 1800

long_query_time 10.000000

low_priority_updates OFF

max_delayed_threads 20

max_join_size 18446744073709551615

max_seeks_for_key 4294967295

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 0

expire_logs_days 0

max_error_count 64

max_length_for_sort_data 1024

preload_buffer_size 32768

relay_log_purge ON

secure_auth OFF

shared_memory OFF

shared_memory_base_name MYSQL

storage_engine InnoDB

back_log 50

connect_timeout 10

interactive_timeout 28800

max_connect_errors 10

max_connections 151

max_user_connections 0

wait_timeout 28800

connect_timeout 10

max_allowed_packet 1048576

named_pipe OFF

net_read_timeout 30

net_retry_count 10

net_write_timeout 60

skip_networking OFF

slave_net_timeout 3600

wait_timeout 28800

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 latin1

character_set_connection latin1

character_set_database latin1

character_set_results latin1

character_set_server latin1

character_set_system utf8

collation_connection latin1_swedish_ci

collation_database latin1_swedish_ci

collation_server latin1_swedish_ci

date_format %Y-%m-%d

datetime_format %Y-%m-%d %H:%i:%s

default_week_format 0

time_format %H:%i:%s

ft_boolean_syntax + ->

ft_max_word_len 84

ft_min_word_len 4

ft_query_expansion_limit 20

ft_stopword_file (built-in)

max_heap_table_size 16777216

max_tmp_tables 32

thread_stack 262144

tmp_table_size 16777216

bulk_insert_buffer_size 8388608

innodb_additional_mem_pool_size 8388608

innodb_buffer_pool_size 134217728

innodb_log_buffer_size 8388608

join_buffer_size 131072

key_buffer_size 8388608

myisam_sort_buffer_size 8388608

net_buffer_length 16384

read_buffer_size 131072

read_rnd_buffer_size 262144

sort_buffer_size 2097152

binlog_cache_size 32768

key_cache_age_threshold 300

key_cache_block_size 1024

key_cache_pision_limit 100

query_cache_limit 1048576

query_cache_min_res_unit 4096

query_cache_size 0

query_cache_type ON

have_innodb YES

innodb_additional_mem_pool_size 8388608

innodb_buffer_pool_size 134217728

innodb_data_file_path ibdata1:10M:autoextend

innodb_fast_shutdown 1

innodb_file_per_table OFF

innodb_flush_log_at_trx_commit 1

innodb_flush_method

innodb_force_recovery 0

innodb_lock_wait_timeout 50

innodb_log_buffer_size 8388608

innodb_log_file_size 5242880

innodb_log_files_in_group 2

innodb_log_group_home_dir .

innodb_max_dirty_pages_pct 75

innodb_mirrored_log_groups 1

innodb_open_files 300

innodb_thread_concurrency 0

myisam_max_sort_file_size 2146435072

myisam_recover_options OFF

myisam_repair_threads 1

auto_increment_increment 1

auto_increment_offset 1

autocommit ON

automatic_sp_privileges ON

big_tables OFF

binlog_direct_non_transactional_OFF

binlog_format STATEMENT

binlog_stmt_cache_size 32768

character_set_filesystem binary

character_sets_dir D:wamp2mysqlsharecharsets

completion_type NO_CHAIN

default_storage_engine InnoDB

p_precision_increment 4

engine_condition_pushdown ON

event_scheduler OFF

foreign_key_checks ON

general_log OFF

general_log_file D:wamp2mysqldatawebtest.log

group_concat_max_len 1024

have_csv YES

have_dynamic_loading YES

have_geometry YES

have_ndbcluster NO

have_partitioning YES

have_profiling YES

have_rtree_keys YES

have_ssl DISABLED

hostname webtest

ignore_builtin_innodb OFF

innodb_adaptive_flushing ON

innodb_adaptive_hash_index ON

innodb_autoextend_increment 8

innodb_autoinc_lock_mode 1

innodb_buffer_pool_instances 1

innodb_change_buffering all

innodb_checksums ON

innodb_commit_concurrency 0

innodb_concurrency_tickets 500

innodb_data_home_dir

innodb_doublewrite ON

innodb_file_format Antelope

innodb_file_format_check ON

innodb_file_format_max Antelope

innodb_force_load_corrupted OFF

innodb_io_capacity 200

innodb_large_prefix OFF

innodb_locks_unsafe_for_binlog OFF

innodb_max_purge_lag 0

innodb_old_blocks_pct 37

innodb_old_blocks_time 0

innodb_print_all_deadlocks OFF

innodb_purge_batch_size 20

innodb_purge_threads 0

innodb_random_read_ahead OFF

innodb_read_ahead_threshold 56

innodb_read_io_threads 4

innodb_replication_delay 0

innodb_rollback_on_timeout OFF

innodb_rollback_segments 128

innodb_spin_wait_delay 6

innodb_stats_method nulls_equal

innodb_stats_on_metadata ON

innodb_stats_sample_pages 8

innodb_strict_mode OFF

innodb_support_xa ON

innodb_sync_spin_loops 30

innodb_table_locks ON

innodb_thread_sleep_delay 10000

innodb_use_native_aio ON

innodb_use_sys_malloc ON

innodb_version 5.5.34

innodb_write_io_threads 4

keep_files_on_create OFF

large_page_size 0

large_pages OFF

lc_messages en_US

lc_messages_dir D:wamp2mysqlshare

lc_time_names en_US

license GPL

lock_wait_timeout 31536000

log_bin_trust_function_creators OFF

log_output FILE

log_queries_not_using_indexes OFF

lower_case_file_system ON

max_binlog_stmt_cache_size 18446744073709547520

max_insert_delayed_threads 20

max_long_data_size 1048576

max_prepared_stmt_count 16382

max_sp_recursion_depth 0

metadata_locks_cache_size 1024

min_examined_row_limit 0

multi_range_count 256

myisam_data_pointer_size 6

myisam_mmap_size 18446744073709551615

myisam_stats_method nulls_unequal

myisam_use_mmap OFF

old OFF

old_alter_table OFF

optimizer_prune_level 1

optimizer_search_depth 62

optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on

performance_schema OFF

performance_schema_events_waits_10000

performance_schema_events_waits_10

performance_schema_max_cond_clas80

performance_schema_max_cond_inst1000

performance_schema_max_file_clas50

performance_schema_max_file_hand32768

performance_schema_max_file_inst10000

performance_schema_max_mutex_cla200

performance_schema_max_mutex_ins1000000

performance_schema_max_rwlock_cl30

performance_schema_max_rwlock_in1000000

performance_schema_max_table_han100000

performance_schema_max_table_ins50000

performance_schema_max_thread_cl50

performance_schema_max_thread_in1000

plugin_dir D:wamp2mysqllibplugin

profiling OFF

profiling_history_size 15

query_cache_wlock_invalidate OFF

relay_log

relay_log_index

relay_log_info_file relay-log.info

relay_log_recovery OFF

relay_log_space_limit 0

report_host

report_password

report_port 3307

report_user

secure_file_priv

skip_name_resolve OFF

slave_compressed_protocol OFF

slave_exec_mode STRICT

slave_load_tmpdir D:wamp2tmp

slave_max_allowed_packet 1073741824

slave_skip_errors OFF

slave_transaction_retries 10

slave_type_conversions

slow_query_log OFF

slow_query_log_file D:wamp2mysqldatawebtest-slow.log

socket MySQL

sql_auto_is_null OFF

sql_big_selects ON

sql_big_tables OFF

sql_buffer_result OFF

sql_log_bin ON

sql_log_off OFF

sql_low_priority_updates OFF

sql_max_join_size 18446744073709551615

sql_notes ON

sql_quote_show_create ON

sql_safe_updates OFF

sql_select_limit 18446744073709551615

sql_slave_skip_counter 0

sql_warnings OFF

ssl_ca

ssl_capath

ssl_cert

ssl_cipher

ssl_key

stored_program_cache 256

sync_binlog 0

sync_frm ON

sync_master_info 0

sync_relay_log 0

sync_relay_log_info 0

system_time_zone

table_definition_cache 400

table_open_cache 400

thread_concurrency 10

thread_handling one-thread-per-connection

time_zone SYSTEM

timed_mutexes OFF

unique_checks ON

updatable_views_with_limit YES