Help me fine tune my.cnf

[Linlay]

I got a VPS with 256MB ram


Connections per second:      0.3259
Kilobytes received per second:    0.0001
Kilobytes sent per second:    0.0003
Queries per second:    19.3041
Percentage of slow queries:    0
Opened vs. Open tables:
(table_cache)    0 (should be <= 80)
Table cache usage:
(table_cache)    0.2339 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size)    0.0019 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)    0.5907 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)    97.6929 (should be >= 30 )
Thread cache usage:
(thread_cache_size)    0.2461 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)    0 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer)    0 (should be <= 0.001)
Query cache enabled:
(query_cache_type)    1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit)    8026.4 (should be <= 0.1)
Query cache prune rate:
(query_cache_size)    0 (should be <= 0.05)








root@host [~]# cat /etc/my.cnf
[mysqld]
set-variable = max_connections=500
skip-locking
connect_timeout=6
key_buffer=128M
join_buffer=4M
record_buffer=4M
sort_buffer=32M
table_cache=2048
thread_cache_size=512
max_allowed_packet=5M
wait_timeout=15
query_cache_limit=2M
query_cache_size=64M
query_cache_type=1
thread_concurrency=5

[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
sort_buffer=32M
read_buffer=16M
write_buffer=16M

[Ben_S]

http://www.simplemachines.org/community/index.php?topic=59691.0