MySQL5.6.14 WIN64位常用配置

my.ini

[WinMySQLAdmin]
D:\mysql-5.6.17-winx64\bin\mysqld.exe


[client]
port=3306
default-character-set=utf8


[mysqld]
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
basedir=D:\mysql-5.6.17-winx64
datadir=D:\mysql-5.6.17-winx64\data
character-set-server=utf8


innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit=1
#innodb_thread_concurrency=8
innodb_log_buffer_size=2M
key_buffer_size=128M
tmp_table_size=128M
read_buffer_size=4M
read_rnd_buffer_size=16M
sort_buffer_size=32M
max_connections=1024
thread_cache_size=120
query_cache_size=64M