win环境下mysql5.6.14的所有变量的默认值

时间:2022-04-04 03:33:07

在windows mysql5.6.14 x64版本下my.ini如下:

[mysqld]

port  = 3306
socket  = /tmp/mysql.sock
basedir=D:/wamp/mysql
datadir=D:/wamp/data5/
tmpdir=D:/wamp/tmp/
character-set-server=utf8
wait_timeout=60
interactive_timeout=30
skip-name-resolve
bind-address=0.0.0.0
thread_concurrency =4
default-storage-engine = Innodb
slow-query-log=1
long_query_time = 0.01
slow-query-log-file=slow.log
server-id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

通过工具查看的mysql的所有变量如下:
init_file                      
old_passwords                   0
port                            3306
protocol_version                10
server_id                       1
version                         5.6.14-log
version_comment                 MySQL Community Server (GPL)
version_compile_machine         x86_64
version_compile_os              Win64
concurrent_insert               AUTO
have_compress                   YES
have_crypt                      NO
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:/wamp/mysql
datadir                         D:\wamp\data5\
innodb_data_file_path           ibdata1:12M:autoextend
innodb_log_group_home_dir       .\
log_error                       D:\wamp\data5\webtest.err
open_files_limit                7048
pid_file                        D:\wamp\data5\webtest.pid
tmpdir                          D:/wamp/tmp/
innodb_log_buffer_size          8M
innodb_log_file_size            48M
innodb_log_files_in_group       2
innodb_log_group_home_dir       .\
log_bin                         OFF
log_error                       D:\wamp\data5\webtest.err
log_slave_updates               OFF
log_warnings                    1
max_binlog_cache_size           17592186044416M
max_binlog_size                 1024M
max_relay_log_size              0
delay_key_write                 ON
delayed_insert_limit            100
delayed_insert_timeout          300
delayed_queue_size              1000
flush                           OFF
flush_time                      0
long_query_time                 2.000000
low_priority_updates            OFF
max_delayed_threads             20
max_join_size                   17592186044416M
max_seeks_for_key               4095.99999904632M
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               9
expire_logs_days                0
max_error_count                 64
max_length_for_sort_data        1024
preload_buffer_size             32K
relay_log_purge                 ON
secure_auth                     ON
shared_memory                   OFF
shared_memory_base_name         MYSQL
storage_engine                  InnoDB
back_log                        80
connect_timeout                 10
interactive_timeout             30
max_connect_errors              100
max_connections                 151
max_user_connections            0
wait_timeout                    60
connect_timeout                 10
max_allowed_packet              4194304
named_pipe                      OFF
net_read_timeout                30
net_retry_count                 10
net_write_timeout               60
skip_networking                 OFF
slave_net_timeout               3600
wait_timeout                    60
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            utf8
character_set_connection        utf8
character_set_database          utf8
character_set_results           utf8
character_set_server            utf8
character_set_system            utf8
collation_connection            utf8_general_ci
collation_database              utf8_general_ci
collation_server                utf8_general_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             16M
max_tmp_tables                  32
thread_stack                    256K
tmp_table_size                  16M
bulk_insert_buffer_size         8M
innodb_additional_mem_pool_size 8M
innodb_buffer_pool_size         128M
innodb_log_buffer_size          8M
join_buffer_size                256K
key_buffer_size                 8M
myisam_sort_buffer_size         8M
net_buffer_length               16K
read_buffer_size                128K
read_rnd_buffer_size            256K
sort_buffer_size                256K
binlog_cache_size               32K
key_cache_age_threshold         300
key_cache_block_size            1024
key_cache_division_limit        100
query_cache_limit               1M
query_cache_min_res_unit        4K
query_cache_size                1M
query_cache_type                OFF
innodb_additional_mem_pool_size 8M
innodb_buffer_pool_size         128M
innodb_data_file_path           ibdata1:12M:autoextend
innodb_fast_shutdown            1
innodb_file_per_table           ON
innodb_flush_log_at_trx_commit  1
innodb_flush_method            
innodb_force_recovery           0
innodb_lock_wait_timeout        50
innodb_log_buffer_size          8M
innodb_log_file_size            48M
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               2000
innodb_thread_concurrency       0
myisam_max_sort_file_size       2047M
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
bind_address                    0.0.0.0
binlog_checksum                 CRC32
binlog_direct_non_transactional_OFF
binlog_format                   STATEMENT
binlog_max_flush_queue_time     0
binlog_order_commits            ON
binlog_row_image                FULL
binlog_rows_query_log_events    OFF
binlog_stmt_cache_size          32K
character_set_filesystem        binary
character_sets_dir              D:\wamp\mysql\share\charsets\
completion_type                 NO_CHAIN
core_file                       OFF
default_storage_engine          InnoDB
default_tmp_storage_engine      InnoDB
disconnect_on_expired_password  ON
div_precision_increment         4
end_markers_in_json             OFF
enforce_gtid_consistency        OFF
eq_range_index_dive_limit       10
event_scheduler                 OFF
explicit_defaults_for_timestamp OFF
foreign_key_checks              ON
general_log                     OFF
general_log_file                D:\wamp\data5\webtest.log
group_concat_max_len            1024
gtid_executed                  
gtid_mode                       OFF
gtid_owned                     
gtid_purged                    
have_dynamic_loading            YES
have_geometry                   YES
have_profiling                  YES
have_rtree_keys                 YES
have_ssl                        DISABLED
host_cache_size                 279
hostname                        webtest
ignore_builtin_innodb           OFF
ignore_db_dirs                 
innodb_adaptive_flushing        ON
innodb_adaptive_flushing_lwm    10
innodb_adaptive_hash_index      ON
innodb_adaptive_max_sleep_delay 150000
innodb_api_bk_commit_interval   5
innodb_api_disable_rowlock      OFF
innodb_api_enable_binlog        OFF
innodb_api_enable_mdl           OFF
innodb_api_trx_level            0
innodb_autoextend_increment     64
innodb_autoinc_lock_mode        1
innodb_buffer_pool_dump_at_shutdOFF
innodb_buffer_pool_dump_now     OFF
innodb_buffer_pool_filename     ib_buffer_pool
innodb_buffer_pool_instances    8
innodb_buffer_pool_load_abort   OFF
innodb_buffer_pool_load_at_startOFF
innodb_buffer_pool_load_now     OFF
innodb_change_buffer_max_size   25
innodb_change_buffering         all
innodb_checksum_algorithm       innodb
innodb_checksums                ON
innodb_cmp_per_index_enabled    OFF
innodb_commit_concurrency       0
innodb_compression_failure_thres5
innodb_compression_level        6
innodb_compression_pad_pct_max  50
innodb_concurrency_tickets      5000
innodb_data_home_dir           
innodb_disable_sort_file_cache  OFF
innodb_doublewrite              ON
innodb_file_format              Antelope
innodb_file_format_check        ON
innodb_file_format_max          Antelope
innodb_flush_log_at_timeout     1
innodb_flush_neighbors          1
innodb_flushing_avg_loops       30
innodb_force_load_corrupted     OFF
innodb_ft_aux_table            
innodb_ft_cache_size            8000000
innodb_ft_enable_diag_print     OFF
innodb_ft_enable_stopword       ON
innodb_ft_max_token_size        84
innodb_ft_min_token_size        3
innodb_ft_num_word_optimize     2000
innodb_ft_result_cache_limit    2000000000
innodb_ft_server_stopword_table
innodb_ft_sort_pll_degree       2
innodb_ft_total_cache_size      640000000
innodb_ft_user_stopword_table  
innodb_io_capacity              200
innodb_io_capacity_max          2000
innodb_large_prefix             OFF
innodb_locks_unsafe_for_binlog  OFF
innodb_log_compressed_pages     ON
innodb_lru_scan_depth           1024
innodb_max_dirty_pages_pct_lwm  0
innodb_max_purge_lag            0
innodb_max_purge_lag_delay      0
innodb_monitor_disable         
innodb_monitor_enable          
innodb_monitor_reset           
innodb_monitor_reset_all       
innodb_old_blocks_pct           37
innodb_old_blocks_time          1000
innodb_online_alter_log_max_size128M
innodb_optimize_fulltext_only   OFF
innodb_page_size                16K
innodb_print_all_deadlocks      OFF
innodb_purge_batch_size         300
innodb_purge_threads            1
innodb_random_read_ahead        OFF
innodb_read_ahead_threshold     56
innodb_read_io_threads          4
innodb_read_only                OFF
innodb_replication_delay        0
innodb_rollback_on_timeout      OFF
innodb_rollback_segments        128
innodb_sort_buffer_size         1M
innodb_spin_wait_delay          6
innodb_stats_auto_recalc        ON
innodb_stats_method             nulls_equal
innodb_stats_on_metadata        OFF
innodb_stats_persistent         ON
innodb_stats_persistent_sample_p20
innodb_stats_sample_pages       8
innodb_stats_transient_sample_pa8
innodb_strict_mode              OFF
innodb_support_xa               ON
innodb_sync_array_size          1
innodb_sync_spin_loops          30
innodb_table_locks              ON
innodb_thread_sleep_delay       10000
innodb_undo_directory           .
innodb_undo_logs                128
innodb_undo_tablespaces         0
innodb_use_native_aio           ON
innodb_use_sys_malloc           ON
innodb_version                  5.6.14
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:\wamp\mysql\share\
lc_time_names                   en_US
license                         GPL
lock_wait_timeout               31536000
log_bin_basename               
log_bin_index                  
log_bin_trust_function_creators OFF
log_bin_use_v1_row_events       OFF
log_output                      FILE
log_queries_not_using_indexes   OFF
log_slow_admin_statements       OFF
log_slow_slave_statements       OFF
log_throttle_queries_not_using_i0
lower_case_file_system          ON
master_info_repository          FILE
master_verify_checksum          OFF
max_binlog_stmt_cache_size      18446744073709547520
max_insert_delayed_threads      20
max_prepared_stmt_count         16382
max_sp_recursion_depth          0
metadata_locks_cache_size       1024
metadata_locks_hash_instances   8
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,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched
optimizer_trace                 enabled=off,one_line=off
optimizer_trace_features        greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer_trace_limit           1
optimizer_trace_max_mem_size    16K
optimizer_trace_offset          -1
performance_schema              ON
performance_schema_accounts_size100
performance_schema_digests_size 10000
performance_schema_events_stages10000
performance_schema_events_stages10
performance_schema_events_statem10000
performance_schema_events_statem10
performance_schema_events_waits_10000
performance_schema_events_waits_10
performance_schema_hosts_size   100
performance_schema_max_cond_clas80
performance_schema_max_cond_inst3504
performance_schema_max_file_clas50
performance_schema_max_file_hand32768
performance_schema_max_file_inst7693
performance_schema_max_mutex_cla200
performance_schema_max_mutex_ins15906
performance_schema_max_rwlock_cl30
performance_schema_max_rwlock_in9102
performance_schema_max_socket_cl10
performance_schema_max_socket_in322
performance_schema_max_stage_cla150
performance_schema_max_statement168
performance_schema_max_table_han4000
performance_schema_max_table_ins12500
performance_schema_max_thread_cl50
performance_schema_max_thread_in402
performance_schema_session_conne512
performance_schema_setup_actors_100
performance_schema_setup_objects100
performance_schema_users_size   100
plugin_dir                      D:\wamp\mysql\lib\plugin\
profiling                       OFF
profiling_history_size          15
query_cache_wlock_invalidate    OFF
relay_log                      
relay_log_basename             
relay_log_index                
relay_log_info_file             relay-log.info
relay_log_info_repository       FILE
relay_log_recovery              OFF
relay_log_space_limit           0
report_host                    
report_password                
report_port                     3306
report_user                    
rpl_stop_slave_timeout          31536000
secure_file_priv               
server_id_bits                  32
server_uuid                     2ab70a0e-a1c4-11e2-9c60-60eb69d711ca
skip_name_resolve               ON
slave_allow_batching            OFF
slave_checkpoint_group          512
slave_checkpoint_period         300
slave_compressed_protocol       OFF
slave_exec_mode                 STRICT
slave_load_tmpdir               D:\wamp\tmp\
slave_max_allowed_packet        1073741824
slave_parallel_workers          0
slave_pending_jobs_size_max     16777216
slave_rows_search_algorithms    TABLE_SCAN,INDEX_SCAN
slave_skip_errors               OFF
slave_sql_verify_checksum       ON
slave_transaction_retries       10
slave_type_conversions         
slow_query_log                  ON
slow_query_log_file             slow.log
socket                          /tmp/mysql.sock
sql_auto_is_null                OFF
sql_big_selects                 ON
sql_buffer_result               OFF
sql_log_bin                     ON
sql_log_off                     OFF
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_crl                        
ssl_crlpath                    
ssl_key                        
stored_program_cache            256
sync_binlog                     0
sync_frm                        ON
sync_master_info                10000
sync_relay_log                  10000
sync_relay_log_info             10000
system_time_zone               
table_definition_cache          1400
table_open_cache                2000
table_open_cache_instances      1
thread_concurrency              4
thread_handling                 one-thread-per-connection
time_zone                       SYSTEM
timed_mutexes                   OFF
tx_read_only                    OFF
unique_checks                   ON
updatable_views_with_limit      YES