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

页面导航:首页 > 数据库 > Mysql > win环境下mysql5.5.34x64社区版所有变量的默认值

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

来源: 作者: 时间:2016-02-03 08:56 【

win环境下mysql5 5 34x64社区版所有变量的默认值my ini文件内容:[mysqld]port = 3307basedir=D: wamp2 mysqltmpdir=D: wamp2 tmp sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 变量的默认值:ini
win环境下5.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:\wamp2\mysql\data\
innodb_data_file_path           ibdata1:10M:autoextend
innodb_log_group_home_dir       .\
log_error                       D:\wamp2\mysql\data\webtest.err
open_files_limit                3009
pid_file                        D:\wamp2\mysql\data\webtest.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:\wamp2\mysql\data\webtest.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_division_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:\wamp2\mysql\share\charsets\
completion_type                 NO_CHAIN
default_storage_engine          InnoDB
div_precision_increment         4
engine_condition_pushdown       ON
event_scheduler                 OFF
foreign_key_checks              ON
general_log                     OFF
general_log_file                D:\wamp2\mysql\data\webtest.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:\wamp2\mysql\share\
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:\wamp2\mysql\lib\plugin\
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:\wamp2\tmp\
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:\wamp2\mysql\data\webtest-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

 


Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<