mysql config

Mysql query times seem to be really high at the moment

here is the current config

[mysqld]
set-variable = max_connections=500
safe-show-database
port = 3306
skip-locking
set-variable = max_connections=250
set-variable = max_user_connections=20
set-variable = key_buffer=48M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1028
set-variable = myisam_sort_buffer_size=32M
set-variable = interactive_timeout=100
set-variable = wait_timeout=100
set-variable = connect_timeout=10
set-variable = thread_cache_size=128
query_cache_type = 1
query_cache_size = 16M

anything i can add to it/mod it to make query times better?

Its a 2.4 celeron, not the best. However it has 1gb of ram....

Thanks.

 

 

 

 

Top