Optimal mysql config?

i currently have this config

Still sql times are huge, I was given this config by a friend. But to be honest it sucks.

Any suggestions?

[mysqld]
connect_timeout=15
interactive_timeout=100
join_buffer_size=1M
key_buffer=128M
max_allowed_packet=16M
max_connections=500
max_connect_errors=10
myisam_sort_buffer_size=64M
read_buffer_size=1M
read_rnd_buffer_size=768K
sort_buffer_size=1M
table_cache=1024
thread_cache_size=100
thread_concurrency=4
wait_timeout=300
query_cache_size=32M
query_cache_limit=1M
query_cache_type=1
skip-innodb

Server spec;

Dual xeon 2.8 ghz
1gb ram
2 hard drives ( Not raid )
Fairly busy server.

Could someone please give us a good config, I have tried different combos still the sql times are fairly high. around 0.1935sec

Thanks.

 

 

 

 

Top