High server load, low memory usage

Hi,

My configuration looks like this:

CPU: 3.0 Ghz PIV (with HT)
Memory: 2GB
Hard Drive: 120 GB

FreeBSD, PHP 4.3.11, Apache 1.3.33, MySQL 4.1.12


my.cnf:
********************************
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=800
max_connections=1000
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=256M
join_buffer=1M
max_allowed_packet=16M
table_cache=2048
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
********************************


httpd.conf
********************************
Timeout 300
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 300
MaxRequestsPerChild 1000
********************************


There are usually 100-350 users online, all sites (4) are using forums so MySQL usage is the main problem. Right now I'm using ~30% of memory and server load is between 3 and 6 with 250-350 users online.. Is there anything I should change in these settings to get the a good balance between memory usage and server load?

 

 

 

 

Top