1G,2.4P4cpu*2内存怎么优化 mysql 3.23.58 使他能够支持2000人在先访问 用mysql 5.0装好了改成长连接就没问题了。你基本上不需要调整什么。2000对于默认配置和你的硬件来说不算是一个很大的量。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在Windows下长连接似乎没有多大作用 长连接?你说的是mysql_pconnect吗?讨厌死了 试试这个吧:[mysqld]basedir=D:/mysql#bind-address=ipdatadir=D:/mysql/data#language=D:/mysql/share/your language directory#slow query log#=#tmpdir#=#port=3306set-variable = max_connections=2500skip-locking#skip-networkingset-variable = key_buffer=256Mset-variable = max_allowed_packet=1Mset-variable = table_cache=512set-variable = sort_buffer=2Mset-variable = record_buffer=2Mset-variable = thread_cache=8# Try number of CPU's*2 for thread_concurrencyset-variable = thread_concurrency=8set-variable = myisam_sort_buffer_size=64M#set-variable = connect_timeout=5#set-variable = wait_timeout=5server-id = 1[isamchk]set-variable = key_buffer=128Mset-variable = sort_buffer=128Mset-variable = read_buffer=2Mset-variable = write_buffer=2M[myisamchk]set-variable = key_buffer=128Mset-variable = sort_buffer=128Mset-variable = read_buffer=2Mset-variable = write_buffer=2M[WinMySQLadmin]Server=D:/mysql/bin/mysqld-nt.exe mysql统计问题 求SQL语句。在线等。 怎么样修改前200条数据 如何把 时间戳 改成 时间格式啊??? postgresql中 sql语句过长问题 insert语句的主键冲突问题 请教SQL查询问题 mysql 用命令createdb 建数据库的问题 mysql数据库利用主从同步部署为环形互相热备的方案 MySQL获取锁失败求解-Lock wait timeout exceeded; try restarting transaction 如何在mysql数据库中查找并替换特定的字符? mysql中有没有类似于connect by这样的解决层递搜索的(如此例)(急)
[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