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