[mysqld]

tmp_table_size              = 1G
max_tmp_tables              = 32

skip-external-locking
bind-address            = 0.0.0.0

# * Fine Tuning
max_allowed_packet      = 1G
thread_stack            = 256K
thread_cache_size       = 256

auto-increment-increment = 1
auto-increment-offset    = 1

max_connections         = 200
max_connect_errors      = 100
wait_timeout            = 10
net_read_timeout        = 30
net_write_timeout       = 30
back_log                = 128
max_heap_table_size     = 2G
myisam_sort_buffer_size = 2G
concurrent_insert = 1
low-priority-updates = 0
myisam_max_sort_file_size= 2G

# * Query Cache Configuration
query_cache_limit       = 28M
query_cache_size        = 512M

open-files-limit = 40000

# * Logging and Replication
log-error = /var/log/mysql/error.log
read_rnd_buffer_size = 256M
log-slow-admin-statements = 1

# Here you can see queries with especially long duration
long_query_time         = 2
log-queries-not-using-indexes


server-id               = 100110
log_bin                 = /var/lib/mysql/mysql-bin
log_slave_updates       = false
expire_logs_days        = 5
max_binlog_size         = 100M
binlog_format           = ROW
sync_binlog             = 0


# * InnoDB

innodb_buffer_pool_size         = 4G
innodb_log_file_size            = 5M
innodb_data_file_path           = ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method             = O_DIRECT
innodb_log_buffer_size          = 32M
innodb_thread_concurrency       = 32

innodb_file_per_table           = 1
innodb_log_files_in_group       = 2
innodb_force_recovery           = 0
innodb_support_xa               = 0

# tuning
innodb_purge_threads            = 4
flush                           = 1
flush_time                      = 10
innodb_flush_log_at_trx_commit  = 0
innodb_max_dirty_pages_pct      = 90
innodb_max_dirty_pages_pct_lwm  = 0

innodb_log_buffer_size          = 3M # equals half of innodb_log_file_size