# power by phpStudy 2014 www.phpStudy.net 官网下载最新版
[client]
port=3306
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir="D:/phpStudy/MySQL/"
datadir="D:/phpStudy/MySQL/data/"
character-set-server=utf8
#default-storage-engine=MyISAM
default-storage-engine=INNODB
#支持 INNODB 引擎模式。修改为 default-storage-engine=INNODB 即可。
#如果 INNODB 模式如果不能启动,删除data目录下ib开头的日志文件重新启动。
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=1024
query_cache_type=1
query_cache_size=32MB
table_cache=256
tmp_table_size=200M
thread_cache_size=16
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=64M
key_buffer_size=256M
read_buffer_size=8M
read_rnd_buffer_size=8M
sort_buffer_size=8M
#innodb_additional_mem_pool_size=16M
#innodb_flush_log_at_trx_commit=1
#innodb_log_buffer_size=64M
#innodb_buffer_pool_size=4G
#innodb_log_file_size=256M
#innodb_thread_concurrency=50
innodb_additional_mem_pool_size=16M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=64M
innodb_buffer_pool_size=1G
innodb_log_file_size=500M
innodb_thread_concurrency=0
#tmpdir="usr/tmp"
#innodb_force_recovery = 6
#innodb_purge_thread = 0