1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
[client]
port=3306
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir="D:/mysql/"
datadir="D:/mysql/db-datas/Data/"
tmpdir = "F:/tempmysql"
character-set-server=utf8
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=800
query_cache_size=166M
tmp_table_size=28M
#*** MyISAM Specific options
myisam_max_sort_file_size=100M
myisam_sort_buffer_size=28M
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#*** INNODB Specific options ***
innodb_file_per_table
innodb_data_home_dir="D:/mysql/db-datas/"
innodb_use_sys_malloc=ON
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=10M
innodb_buffer_pool_size=950M
innodb_log_file_size=190M
innodb_thread_concurrency=16
innodb_write_io_threads = 8
innodb_read_io_threads = 8 |