MySQL optimization

I want to optimize my server performance and here is its specs:


Here is MySQL conf. file (my.cnf):
Code: 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=700
interactive_timeout=100
wait_timeout=3600
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=2
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
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=20M

[mysql]
no-auto-rehash

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

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

[mysqlhotcopy]
interactive-timeout

#mysqladmin status
Code: 
Uptime: 92496  Threads: 11  Questions: 1979340  Slow queries: 163  
Opens: 22699  Flush tables: 1  Open tables: 1024  Queries per second avg: 21.399
#top
Code: 
11:31pm  up days, 10:01,  1 user,  load average: 1.13, 1.67, 1.83
138 processes: 133 sleeping, 2 running, 3 zombie, 0 stopped
CPU states: 13.1% user,  6.9% system,  0.3% nice, 79.4% idle
Mem:   997288K av,  962724K used,   34564K free,       0K shrd,   63560K buff
Swap: 2096472K av,  150036K used, 1946436K free                  675228K cached
Any suggestion is highly appreciated

 

 

 

 

Top