日期:2014-05-16 浏览次数:20736 次
在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