Configuration B


[mysqld]
port = 3307 
socket = /tmp/mysql.sock 
skip-locking 
key_buffer_size = 256M 
max_allowed_packet = 1M 
table_cache = 500 
sort_buffer_size = 24M 
net_buffer_length = 8K 
read_buffer_size = 1M 
read_rnd_buffer_size = 256K 
myisam_sort_buffer_size = 24M 
record_buffer=1M 
log-slow-queries 
long_query_time = 3 
query_cache_size = 512M 
max_connections = 500 
join_buffer_size = 16M 

[mysqldump] 
quick 
max_allowed_packet = 16M 

[mysql] 
no-auto-rehash 
# Remove the next comment character if you are not familiar with SQL 
#safe-updates 

[isamchk] 
key_buffer = 25M 
sort_buffer_size = 25M 
read_buffer = 6M 
write_buffer = 6M 

[myisamchk] 
key_buffer = 25M 
sort_buffer_size = 25M 
read_buffer = 6M 
write_buffer = 6M 

[mysqlhotcopy] 
interactive-timeout