my.cnf optimization

Hello,

I am running P4 2.8 with 512MB Ram

would the following my.cnf configuration alright?

thanks in advance

[mysqld]
set-variable = max_connections=500
set-variable = key_buffer=48M
set-variable = myisam_sort_buffer_size=48M
set-variable = join_buffer_size=512K
set-variable = read_buffer_size=512K
set-variable = sort_buffer_size=1M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=14400
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
set-variable = query_cache_limit=1M
set-variable = query_cache_size=24M
set-variable = query_cache_type=1

[mysqld_safe]
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

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

 

 

 

 

Top