日期:2014-05-16  浏览次数:20736 次

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

在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    &n