need help with mysql and load

the load in my server is very high its 70 need help

here is my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
max_connections=1000
max_user_connections=2000
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
#log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=32M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M




and here is the top

top - 15:23:04 up 10:21, 1 user, load average: 68.80, 46.73, 52.01
Tasks: 1099 total, 11 running, 1082 sleeping, 6 stopped, 0 zombie
Cpu(s): 44.8% us, 53.6% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.2% hi, 1.4% si
Mem: 1026380k total, 1005500k used, 20880k free, 1384k buffers
Swap: 1052248k total, 286824k used, 765424k free, 52944k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11757 mysql 17 0 528m 107m **** R 11.5 10.7 0:03.99 mysqld
11786 mysql 17 0 528m 107m **** R 11.5 10.7 0:04.89 mysqld
12041 mysql 17 0 528m 107m **** R 10.4 10.7 0:03.75 mysqld
11739 mysql 17 0 528m 107m **** D 10.1 10.7 0:04.35 mysqld
11873 mysql 17 0 528m 107m **** R 9.8 10.7 0:02.04 mysqld
11901 mysql 17 0 528m 107m **** R 9.8 10.7 0:03.23 mysqld
11915 mysql 17 0 528m 107m **** R 9.8 10.7 0:05.94 mysqld
11733 mysql 17 0 528m 107m **** R 8.7 10.7 0:09.40 mysqld
11887 mysql 17 0 528m 107m **** D 8.4 10.7 0:01.99 mysqld
11772 mysql 17 0 528m 107m **** D 8.1 10.7 0:03.32 mysqld
11802 mysql 17 0 528m 107m **** D 7.2 10.7 0:03.36 mysqld
11869 mysql 17 0 528m 107m **** D 7.2 10.7 0:02.94 mysqld
18124 nobody 15 0 10988 4168 2396 S 6.9 0.4 0:08.28 httpd
12033 mysql 17 0 528m 107m **** R 6.9 10.7 0:01.43 mysqld
12019 mysql 17 0 528m 107m **** D 5.2 10.7 0:01.79 mysqld
11866 mysql 17 0 528m 107m **** D 4.9 10.7 0:01.77 mysqld
11769 mysql 17 0 528m 107m **** D 4.6 10.7 0:06.85 mysqld


so please tell my the best optimization for mysql

thanks

 

 

 

 

Top