[client]
port                                                    = 3306
socket                                                  = /var/run/mysqld/mysqld.sock
default-character-set                   = utf8

[mysqld_safe]
socket                                                  = /var/run/mysqld/mysqld.sock
nice                                                    = 0
malloc-lib                                              = /usr/lib/x86_64-linux-gnu/libjemalloc.so.1

[mysqld]
user                                                    = mysql
pid-file                                                = /var/run/mysqld/mysqld.pid
socket                                                  = /var/run/mysqld/mysqld.sock
port                                                    = 3306
basedir                                                 = /usr
datadir                                                 = /var/lib/mysql
tmpdir                                                  = /var/mysql_tmpfs
open_files_limit                                = 16384

# Other
default-storage-engine                  = INNODB
character-set-server                    = utf8
#explicit_defaults_for_timestamp = TRUE
max_connections                                 = 200
wait_timeout                                    = 7200
max_allowed_packet                              = 16M
low_priority_updates                    = 1
concurrent_insert                               = 2
#expand_fast_index_creation              = On
#bind-address                                    = 127.0.0.1
skip-external-locking

# MyISAM settings
key_buffer_size                                 = 128M
myisam_sort_buffer_size                 = 512M
myisam_repair_threads                   = 1

# InnoDB settings
innodb_data_file_path = ibdata1:32M:autoextend:max:32G
innodb_file_per_table           = 1
innodb_buffer_pool_size                 = 4G
innodb_buffer_pool_instances    = 8
innodb_log_file_size                    = 16M
innodb_flush_log_at_trx_commit  = 0
innodb_log_buffer_size                  = 8M
innodb_log_files_in_group               = 2
innodb_flush_method                             = O_DIRECT
innodb_thread_concurrency               = 8

# Buffer settings
join_buffer_size                                = 2M
sort_buffer_size                                = 2M
read_buffer_size                                = 128K
read_rnd_buffer_size                    = 256K
bulk_insert_buffer_size                 = 16M

# TMP & memory settings
tmp_table_size                                  = 64M
max_heap_table_size                     = 64M

# Cache settings
query_cache_type                                = 1
thread_cache_size                               = 128
query_cache_limit                               = 128K
query_cache_size                                = 128M
table_open_cache                                = 2048
table_definition_cache                  = 2048
#table_open_cache_instances              = 2
query_cache_strip_comments              = On

# Slowlog settings
slow_query_log                                  = 1
long_query_time                                 = 10
slow_query_log_file                             = /var/log/mysql/mysql-slow.log
#log_slow_verbosity                              = microtime,query_plan,innodb
log-error=/var/log/mysql-errors.log

[mysqldump]
# Do not buffer the whole result set in memory before writing it to
# file. Required for dumping very large tables
quick

max_allowed_packet                              = 32M
default-character-set                   = utf8

[mysql]
no-auto-rehash
default-character-set                   = utf8

[isamchk]
key_buffer_size                                 = 8M
sort_buffer_size                                = 8M
read_buffer                                             = 8M
write_buffer                                    = 8M
default-character-set                   = utf8