[mysqld]
basedir                         = /usr
user                            = root
datadir                         = /home/rack/sandbox/data
pid-file                        = /home/rack/sandbox/data/mysql.pid
tmpdir                          = /home/rack/sandbox/tmp
socket                          = /home/rack/sandbox/data/mysql.sock
skip-name-resolve
sql-mode                        = NO_ENGINE_SUBSTITUTION
#event-scheduler                = 1

## Cache
thread-cache-size               = 0
table-open-cache                = 512
table-definition-cache          = 512
query-cache-size                = 0
query-cache-type                = 0

## Per-thread Buffers
#sort-buffer-size               = 2M

## Temp Tables
#tmp-table-size                 = 16M
#max-heap-table-size            = 16M

## Networking
skip-networking
#port                           = 5541
back-log                        = 50
max-connections                 = 64
max-connect-errors              = 10000
max-allowed-packet              = 16M
interactive-timeout             = 3600
wait-timeout                    = 600

### Storage Engines

## MyISAM
key-buffer-size                 = 8M
myisam-sort-buffer-size         = 128M
myisam-recover-options          = DEFAULT

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

## Replication
server-id                       = 1
log-bin                         = bin-log
#relay-log                      = relay-log
relay-log-space-limit           = 16G
expire-logs-days                = 7
#read-only                      = 1
#sync-binlog                    = 1
#log-slave-updates              = 1
#binlog-format                  = MIXED
#auto-increment-offset          = 1
#auto-increment-increment       = 2

## Logging
log-output                      = FILE
slow-query-log                  = 1
slow-query-log-file             = /home/rack/sandbox/data/slow.log
log-slow-slave-statements
log-slow-admin-statements
long-query-time                 = 2


[mysqld_safe]
ledir                           = /home/rack/sandbox/bin
log-error                       = /home/rack/sandbox/data/mysqld.log
open-files-limit                = 65535