mysql 1500_优化的my.ini[mysql]．1500在线．突破最大连接数

[mysqld]

basedir=D:/mysql

#bind-address=ip

datadir=D:/mysql/data

#language=D:/mysql/share/your language directory

#slow query log#=

#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

set-variable        = sort_buffer=2M

set-variable        = record_buffer=2M

set-variable        = thread_cache=8

# Try number of CPU's*2 for thread_concurrency

set-variable        = thread_concurrency=8

set-variable        = myisam_sort_buffer_size=64M

#set-variable        = connect_timeout=5

#set-variable        = wait_timeout=5

server-id        = 1

[isamchk]

set-variable        = key_buffer=128M

set-variable        = sort_buffer=128M

set-variable        = read_buffer=2M

set-variable        = write_buffer=2M

[myisamchk] set-variable        = key_buffer=128M set-variable        = sort_buffer=128M set-variable        = read_buffer=2M set-variable        = write_buffer=2M [WinMySQLadmin] Server=D:/mysql/bin/mysqld-nt.exe