1G,2.4P4cpu*2内存怎么优化 mysql 3.23.58 使他能够支持2000人在先访问

Question

用mysql 5.0装好了改成长连接就没问题了。你基本上不需要调整什么。2000对于默认配置和你的硬件来说不算是一个很大的量。

Answer 1

在Windows下长连接似乎没有多大作用

Answer 2

长连接？你说的是mysql_pconnect吗？讨厌死了

Answer 3

试试这个吧:
[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=2500
skip-locking
#skip-networking
set-variable        = key_buffer=256M
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