[mysqld]

## General
datadir                         = /var/lib/mysql
tmpdir                          = /var/lib/mysqltmp
socket                          = /var/lib/mysql/mysql.sock
port                            = 3306
skip-name-resolve
sql-mode                        = NO_ENGINE_SUBSTITUTION
#event-scheduler                = 1
bind-address                    = 0.0.0.0

## Cache
#thread-cache-size               = 16
thread-cache-size               = 24
thread_concurrency              = 32
#table-open-cache                = 4096
table-open-cache                = 8192
table-definition-cache          = 2048
query-cache-size                = 32M
query-cache-limit               = 1M

## Per-thread Buffers
#sort-buffer-size                = 1M
sort-buffer-size                = 400M
#read-buffer-size                = 1M
read-buffer-size                = 128M
#read-rnd-buffer-size            = 1M
read-rnd-buffer-size            = 128M
#join-buffer-size                = 1M
join-buffer-size                = 256M
low_priority_updates            = TRUE

## Temp Tables
#tmp-table-size                  = 32M
#tmp-table-size                  = 512M
tmp-table-size                  = 1024M
#max-heap-table-size             = 64M
max-heap-table-size             = 512M

## Networking
back-log                        = 100
#max-connections                = 200
max-connect-errors              = 10000
max-allowed-packet              = 16M
interactive-timeout             = 3600
#wait-timeout                    = 600
wait-timeout                    = 28800

### Storage Engines
#default-storage-engine         = InnoDB
innodb                          = FORCE

## MyISAM
#key-buffer-size                 = 64M
#key-buffer-size                 = 4096M
key-buffer-size                 = 6144M
#myisam-sort-buffer-size         = 128M
myisam-sort-buffer-size         = 400M

## InnoDB
innodb-buffer-pool-size        = 128M
innodb-log-file-size           = 100M
innodb-log-buffer-size         = 8M
innodb-file-per-table          = 1
innodb-open-files              = 300

## Replication
server-id                       = 3
log-bin                        = /var/log/mysql/bin-log
relay-log                      = /var/lib/mysqllogs/relay-log
#relay-log-space-limit           = 16G
relay-log-space-limit           = 0
expire-logs-days                = 7
#expire-logs-days                = 10
#read-only                      = 1
#sync-binlog                    = 1
#log-slave-updates              = 1
#binlog-format                  = STATEMENT
binlog-format                  = MIXED
auto-increment-offset          = 2
auto-increment-increment       = 2

### Kurrer (ignore duplicate entries)
slave-skip-errors               = 1062

report-host                     = rz-csmed22-hb
replicate-same-server-id        = 0

## Logging
#log-output                      = FILE
#slow-query-log                  = 1
#slow-query-log-file             = /var/log/mysql/slow-log
#log-slow-slave-statements
#long-query-time                 = 2

[mysqld_safe]
log-error                       = /var/log/mysqld.log
open-files-limit                = 65535

[mysql]
no-auto-rehash

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

[mysqldump]
socket          = /var/lib/mysql/mysql.sock
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout