Need some help on a server load problem
)I currently run a phpBB community on one of my friend's server...I was told it is delicated server and great hardware power, but I keep running into server problems on daily basis. I have been constantly told by the admin that the server is getting too many MySQL processes...yet coding-wise I could not able to find anything wrong since it is a un modded-phpBB with registration disabled.
Community size: 2500 users, about 200 concurrent users online when server load gets strained.
phpBB version: phpBB 2.0.10
The server setting: dual 2.8 GHz P4, 2GB RAM, 40GB HD, running web and MySQL on the same server
MySQL setting:
[mysqld]
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
I'd appreciate the help if anyone can give me some advice on what might went wrong.
Also, since I don't feel it is a good choice for me to stay on that server (because getting tech support is hard with non-professional hosts), I was considering getting a paid delicated server on myself. what kind of basic server spec I should go for to host a phpbb community with 3000 total, 500 concurrent users?
Thanks a lot for reading my questions. Any response would be appreciated.
