[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_buffer_pool_size 		= 1G
innodb_buffer_pool_instances	= 3
innodb_log_file_size 			= 16M
innodb_flush_log_at_trx_commit 	= 2
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

[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