Configuration A

[mysqld]
server-id=1
port=3306
socket=/var/lib/mysql/mysql.sock
key_buffer=64M
max_allowed_packet=16M
join_buffer_size=1M
sort_buffer_size=2M
read_buffer_size=1M
myisam_sort_buffer_size=64M
thread_cache=1024
thread_cache_size=80
interactive_timeout=30
wait_timeout=40
connect_timeout=10
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
tmp_table_size=512M
thread_concurrency=2
pid-file=/var/run/mysqld/mysqld.pid
# memory=key_buffer+(sort_buffer_size+read_buffer_size)*max_connections
max_connections=600
max_connect_errors=10
max_user_connections=400
table_cache=2400
old_passwords=1
key_buffer_size=256M
log-slow-queries = /var/log/mysql-slow.log
long_query_time = 1
low_priority_updates=1
concurrent_insert=2
skip-bdb
skip-name-resolve
skip-locking
#skip-innodb
[mysqld_safe]
err-log=/var/log/mysqld.log
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M