I just got a new Dual Xeon 3.0 / 2Gb's ram / 2x 73Gb 15,000 RPM SCSI's in Raid 0. This is my current my.cnf file. What would you suggest changing or is this good?
[mysqld]
max_connections = 1000
safe-show-database
key_buffer = 1024M
myisam_sort_buffer_size = 128M
join_buffer_size = 32M
read_buffer_size = 32M
sort_buffer_size = 32M
table_cache = 1024
thread_cache_size = 256
wait_timeout = 30
connect_timeout = 20
max_allowed_packet = 64M
max_connect_errors = 15
query_cache_limit = 16M
query_cache_size = 128M
query_cache_type = 1
skip-innodb
skip-name-resolve
[mysqld_safe]
open_files_limit = 8192
err-log=/var/log/mysqld.log
log-bin
[mysqldump]
quick
max_allowed_packet = 64M
[isamchk]
key_buffer = 1024M
sort_buffer_size = 1024M
read_buffer = 32M
write_buffer = 32M
[myisamchk]
key_buffer = 1024M
sort_buffer = 1024M
read_buffer = 64M
write_buffer = 64M
[mysqld]
max_connections = 1000
safe-show-database
key_buffer = 1024M
myisam_sort_buffer_size = 128M
join_buffer_size = 32M
read_buffer_size = 32M
sort_buffer_size = 32M
table_cache = 1024
thread_cache_size = 256
wait_timeout = 30
connect_timeout = 20
max_allowed_packet = 64M
max_connect_errors = 15
query_cache_limit = 16M
query_cache_size = 128M
query_cache_type = 1
skip-innodb
skip-name-resolve
[mysqld_safe]
open_files_limit = 8192
err-log=/var/log/mysqld.log
log-bin
[mysqldump]
quick
max_allowed_packet = 64M
[isamchk]
key_buffer = 1024M
sort_buffer_size = 1024M
read_buffer = 32M
write_buffer = 32M
[myisamchk]
key_buffer = 1024M
sort_buffer = 1024M
read_buffer = 64M
write_buffer = 64M
