High server load caused by mysql

Hi, having high server load now, need help High server load caused by mysql

Server details:
Pentium 4 \ 2.8 Ghz
1gb RAM
80GB SATA 7200RPM Hardisk

When I do mysqladmin - status:
Uptime: 240572 Threads: 106 Questions: 511097 Slow queries: 35 Opens: 742 Flush tables: 1 Open tables: 370 Queries per second avg: 2.125
my my.cnf:
[mysqld]



datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

set-variable = max_connections=500

set-variable = key_buffer=16M

set-variable = myisam_sort_buffer_size=64M

set-variable = join_buffer=1M

set-variable = record_buffer=1M

set-variable = sort_buffer=2M

set-variable = table_cache=1024

set-variable = thread_cache_size=256

set-variable = wait_timeout=3600

set-variable = connect_timeout=10

set-variable = max_allowed_packet=16M

set-variable = max_connect_errors=10



[mysql.server]

user=mysql

basedir=/var/lib



[safe_mysqld]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

open_files_limit=8192

Attached is the top results.

Any help would be greatly appreciated High server load caused by mysql

 

 

 

 

Top