[mysqld]

## General
datadir                         = /var/lib/mysql
tmpdir                          = /var/lib/mysqltmp
socket                          = /var/lib/mysql/mysql.sock
skip-external-locking           = 1
skip-name-resolve
open-files-limit                = 20000
#sql-mode                       = TRADITIONAL
#event-scheduler                = 1

## Cache
thread-cache-size               = 16
table-open-cache                = 8192
table-definition-cache          = 512
query-cache-size                = 64M
query-cache-limit               = 1M

## Per-thread Buffers
sort-buffer-size                = 2M
read-buffer-size                = 1M
read-rnd-buffer-size            = 8M
join-buffer-size                = 2M
thread_stack                = 256K

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

## Networking
back-log                        = 100

max-connections                 = 1000
max-connect-errors              = 10000
max-allowed-packet              = 16M
interactive-timeout             = 60
wait-timeout                    = 60

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

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

## InnoDB
#innodb-log-group-home-dir      = /var/lib/mysql
#innodb-data-home-dir           = /var/lib/mysql
#innodb-data-file-path          = ibdata1:2000M;ibdata2:10M:autoextend
innodb-buffer-pool-size         = 2G
#innodb-additional-mem-pool-size= 20M
innodb-log-file-size            = 256M
innodb_log_files_in_group       = 2
innodb-log-buffer-size          = 4M
#innodb-flush-method            = O_DIRECT
#innodb-file-per-table          = 1
#innodb-open-files              = 300
#innodb-thread-concurrency      = 16
#innodb-support-xa              = 0
innodb-flush-log-at-trx-commit  = 2

## Replication
server-id                       = 333901
log-bin                        = /var/lib/mysqllogs/db1_bin-log
relay-log                      = /var/lib/mysqllogs/db1_relay-log
expire-logs-days               = 14
read-only                      = 1
replicate-ignore-db            = mysql
binlog-ignore-db           = mysql
#sync-binlog                    = 1
log-slave-updates              = 1
#binlog-format                  = STATEMENT
#auto-increment-offset          = 1
#auto-increment-increment       = 2
max_binlog_size             = 100M

## Logging
#log-output                     = FILE
#slow-query-log                 = 1
#slow-query-log-file            = /var/lib/mysqllogs/slow-log
#long-query-time                = 2
#log-queries-not-using-indexes  = 1

[mysqld_safe]
log-error                       = /var/log/mysqld.log