After running a perl script mysql tuner, i got the following result... please suggest me what values need change to improve the performance and decrease the server load. These days server load is increased on my VPS.


[--] Total buffers: 1.2G global + 7.5M per thread (105 max threads)
[!!] Maximum possible memory usage: 2.0G (98% of installed RAM)
[OK] Slow queries: 0% (1/130K)
[OK] Highest usage of available connections: 23% (25/105)
[OK] Key buffer size / total MyISAM indexes: 544.0M/274.4M
[OK] Key buffer hit rate: 99.0% (353K cached / 3K reads)
[OK] Query cache efficiency: 77.1% (52K cached / 68K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3K sorts)
[OK] Temporary tables created on disk: 15% (140 on disk / 930 total)
[OK] Thread cache hit rate: 99% (25 created / 11K connections)
[OK] Table cache hit rate: 97% (572 open / 586 opened)
[OK] Open file limit used: 66% (1K/1K)
[OK] Table locks acquired immediately: 99% (30K immediate / 30K locks)



[mysqld]
skip-bdb
local-infile=0
query_cache_limit=4M
query_cache_size=160M
query_cache_type=1
max_user_connections=150
max_connections=105
interactive_timeout=100
wait_timeout=15
connect_timeout=20
thread_cache_size=320
key_buffer=544M
join_buffer_size=3M
max_allowed_packet=32M
table_cache=768
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_heap_table_size=240M
tmp_table_size=240M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=128M
server-id=1
local-infile=0
log-slow-queries=/var/log/slow_queries.log
long_query_time = 10

innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size=256M
innodb_additional_mem_pool_size=20M
innodb_log_file_size=64M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=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

#[mysqldump]
#quick
#max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=4M
write_buffer=4M

[myisamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=4M
write_buffer=4M

[mysqlhotcopy]
interactive-timeout


Memory usage high on connection tracking and on following...

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.domain.com.pid --skip-external-locking