[client]
port                            = 3306
socket                          = /var/lib/mysql/mysql.sock

[mysqld]
port                            = 3306
socket                          = /var/lib/mysql/mysql.sock

## Features (skip certain things)
skip-bdb
skip-ndbcluster

## Server tuning
thread_concurrency              = 8
thread_cache                    = 16
max_connections                 = 20

## Performance tuning (logging)
long_query_time                 = 5
log-slow-queries                = /var/lib/mysql/slow-queries.log

# Performance reasons dictate, to keep the binary log and data on the same
# physical partition
datadir                         = /var/lib/mysql/db
log-bin                         = /var/lib/mysql/t3-mysql1
relay-log                       = /var/lib/mysql/t3-mysql1-relay
relay-log-index                 = /var/lib/mysql/t3-mysql1-relay.index
master-info-file                = /var/lib/mysql/master.info
relay-log-info-file             = /var/lib/mysql/relay.info

# Remove old binary logs after 5 days
expire_logs_days                = 5

## Performance tuning (InnoDB)
innodb_flush_method             = O_DIRECT
innodb_buffer_pool_size         = 1024M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size            = 256M
innodb_flush_log_at_trx_commit  = 2
innodb_thread_concurrency       = 8
innodb_file_per_table

## Performance tuning (cache)
join_buffer_size                = 2M
key_buffer                      = 384M
query_cache_size                = 124M
query_cache_limit               = 16M
query_cache_min_res_unit        = 512
table_cache                     = 2048
sort_buffer_size                = 2M
read_buffer_size                = 2M
read_rnd_buffer_size            = 8M
myisam_sort_buffer_size         = 64M
thread_cache_size               = 8

# Temporary tables
max_heap_table_size             = 2048M
tmp_table_size                  = 1024M

## Replication settings
server-id                       = 41
max_allowed_packet              = 16M
master-user                     = replication
master-password                 = <pickyourdamnown>
master-port                     = 3306
auto_increment_increment        = 10
auto_increment_offset           = 1

# The safe_mysqld script
[safe_mysqld]
datadir                         = /var/lib/mysql/db
err-log                         = /var/lib/mysql/mysqld.log

[mysqldump]
quick
max_allowed_packet              = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer                      = 256M
sort_buffer_size                = 256M
read_buffer                     = 2M
write_buffer                    = 2M

[myisamchk]
key_buffer                      = 256M
sort_buffer_size                = 256M
read_buffer                     = 2M
write_buffer                    = 2M

[mysqlhotcopy]
interactive-timeout