mysql is killing my box :!!

Hello . I have invision board with about 500 user online running in a box with : Dual Pentium Xeon 2.8 Ghz , 2Gram , 1SCSI and 80G IDE for backup . RedHat 9 , Cpanel , phpsuexe , apache 1.3.29 . I think my box quite strong but everytime mysql process eating about 70% resource in my server and it make a whole server load go over 40 . mysql is killing my box :!!
This is my my.cnf :

[mysql]
no-auto-rehash

[mysqld]
max_connections=800
thread_concurrency=20
skip-networking
delay-key-write-for-all-tables
set-variable = long_query_time=3
set-variable = wait_timeout=60
skip-locking
safe-show-database
key_buffer=32M
myisam_sort_buffer_size=64M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
read_buffer=1M
table_cache=1024
thread_cache_size=256
wait_timeout=100
connect_timeout=10
tmp_table_size=64M
max_allowed_packet=8M
max_connect_errors=10
log_bin
[safe_mysqld]
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[isamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M


Anyone have idea about this ?
Sorry for my bad english .

 

 

 

 

Top