各位高手来看看my.ini的优化1000人在线的

#This File was made using the WinMySQLAdmin 1.4 Tool
#2004-2-23 16:28:14

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=D:/mysql
#bind-address=210.5.*.*
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

900多人在线的时候总是出现

Discuz! info: Can not connect to MySQL server

Time: 2004-3-13 9:35pm
Script:  bbs/viewthread.php

Error: Can't connect to MySQL server on 'localhost' (10048)
Errno.: 2003

Discuz! info: Can not connect to MySQL server

Time: 2004-3-13 9:35pm
Script:  bbs/viewthread.php

Error: Can't connect to MySQL server on 'localhost' (10048)
Errno.: 2003

支持不住，服务挂掉啦。

我需要查看你的mysql在高峰時的一些變量值﹐有辦法給我弄到嗎﹖
在phpmyadmin里面可以查到的~~

220-250

为什么不使用系统SOCKET？？？？要使用tcp连接？你的WEB与MYSQL是分开的服务器的？

Originally posted by BENDY at 2004-3-23 07:21 PM:
为什么不使用系统SOCKET？？？？要使用tcp连接？你的WEB与MYSQL是分开的服务器的？

同一个服务器
怎么改成SOCKET?
有什么好处?

Originally posted by AsIwish at 2004-3-24 01:43 PM:

同一个服务器
怎么改成SOCKET?
有什么好处?

哦。一时没看。你的是WINDOWS。用不了。。呵。。。

Originally posted by BENDY at 2004-3-25 06:25 AM:

哦。一时没看。你的是WINDOWS。用不了。。呵。。。

昏到

你看看 apache 在系统里面占用了多少内存？

他是IIS的WEB SERVER…