[mysqld]
debug=d:i:F:L:n:O,/usr/local/mysql/err
log-bin
server-id=2
skip-name-resolve
skip-show-database
skip-locking
log-slow-queries=/var/log/mysql/slow.log
set-variable = back_log=10
set-variable = connect_timeout=10
set-variable = interactive_timeout=28800
set-variable = join_buffer=1024000
set-variable = key_buffer_size=256M

set-variable = max_allowed_packet=4M
set-variable = max_connect_errors=130
set-variable = max_connections=2048

set-variable = myisam_sort_buffer_size=64M

set-variable = net_buffer_length=128K
set-variable = net_read_timeout=30
set-variable = net_retry_count=10000
set-variable = net_write_timeout=60

set-variable = query_cache_size=64M
set-variable = query_cache_limit=4M
set-variable = query_cache_type=1

set-variable = read_buffer_size=16M
set-variable = sort_buffer=16M
set-variable = table_cache=2048

set-variable = thread_stack=256k
set-variable = thread_cache=64
set-variable = thread_concurrency=8

set-variable = tmp_table_size=2000000
set-variable = tmpdir=/usr/local/tmp
set-variable = wait_timeout=28800

set-variable = delayed_insert_limit=2000
set-variable = delayed_insert_timeout=1800
set-variable = delayed_queue_size=8000
set-variable = max_delayed_threads=32



[mysqldump]
quick
set-variable = max_allowed_packet=16M

[isamchk]
set-variable = key_buffer=32M
set-variable = sort_buffer=32M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=32M
set-variable = sort_buffer=32M
set-variable = read_buffer=2M
set-variable = write_buffer=2M