56,912
社区成员




# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
[client]
port=3307
default-character-set=gbk
[mysql]
default-character-set=gbk
[mysqld]
port=3307
basedir="D:/Neware/Server/Data/mysql/"
datadir="D:/Neware/Server/Data/"
character-set-server=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=5000
max_connect_errors=10000
query_cache_size=91M
table_cache=1024
tmp_table_size=64M
thread_cache_size=120
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=54M
key_buffer_size=142M
read_buffer_size=20M
read_rnd_buffer_size=20M
sort_buffer_size=2M
max_allowed_packet=500M
innodb_additional_mem_pool_size=6M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=64M
innodb_buffer_pool_size=275M
innodb_log_file_size=55M
innodb_thread_concurrency=8
innodb_autoextend_increment=256
bulk_insert_buffer_size=128
sync_binlog=0
[WinMySQLAdmin]
Server=D:\Neware\Server\Data\mysql\bin\mysqld.exe