mysql load issues

I admin a very busy forum that has around 150k members. Generally at busy times we have around 1000 active members posting and browsing. We have a dedicated server for apache and another for mysql. They are connected over a gigabit network. My load is around 20ish for the mysql server

Here is the server specs. They are the same for both servers
Dual Xeon 2.66GHz HT enabled
2gig RAM
2 10k SCSI drives

Here is my status for mysql
Code:
Uptime: 429  Threads: 57  Questions: 101487  Slow queries: 3  Opens: 575  Flush tables: 1  Open tables: 569  Queries per second avg: 236.566
free -m
Code:
             total       used       free     shared    buffers     cached
Mem:          2026       1483        542          0         57       1225
-/+ buffers/cache:        200       1825
Swap:         1992          0       1992
top
Code:
top - 19:23:37 up 23:34,  2 users,  load average: 9.85, 10.45, 11.14
Tasks: 276 total,   1 running, 275 sleeping,   0 stopped,   0 zombie
 Cpu0 : 22.6% us,  3.4% sy,  0.0% ni, 72.8% id,  0.4% wa,  0.2% hi,  0.5% si
 Cpu1 : 19.6% us,  2.3% sy,  0.0% ni, 77.3% id,  0.7% wa,  0.0% hi,  0.1% si
 Cpu2 : 23.8% us,  2.6% sy,  0.0% ni, 73.1% id,  0.5% wa,  0.0% hi,  0.1% si
 Cpu3 : 17.2% us,  2.0% sy,  0.0% ni, 80.1% id,  0.7% wa,  0.0% hi,  0.1% si
Mem:   2075104k total,  1512832k used,   562272k free,    59196k buffers
Swap:  2040244k total,        0k used,  2040244k free,  1255104k cached
/etc/my.cnf
Code:
[mysqld]
max_connections = 800
skip-locking
key_buffer=512M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
table_cache=1028
thread_cache_size=286
max_allowed_packet=5M
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
thread_concurrency=8
query_cache_limit=4M
query_cache_size=64M
query_cache_type=1
Any help or ideas?

Thanks

 

 

 

 

Top