据说这是高手优化的MySQL,供大家参考,其中连接数: max_connections=1500可以根据服务器的性能更改.
#set-variable=connect_timeout=5
#set-variable=wait_timeout=5
建议启用,负担重的服务器可以适当减少持续连接时间
[mysqld]
basedir=D:/mysql
#bind-address=ip
datadir=D:/mysql/data
#language=D:/mysql/share/yourlanguagedirectory
#slowquerylog#=
#tmpdir#=
#port=3306
set-variable=max_connections=1500
skip-locking
#skip-networking
set-variable=key_buffer=384M
set-variable=max_allowed_packet=1M
set-variable=table_cache=512...[ 查看全文 ]