file.txt

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[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          = /tmp
skip-external-locking
bind-address            = 127.0.0.1

#
# * Fine Tuning
#

key_buffer              = 256M
max_allowed_packet      = 16M
thread_stack            = 256K
thread_cache_size       = 8
max_connections         = 300
table_cache             = 512
thread_concurrency      = 4
tmp_table_size          = 32M
max_heap_table_size     = 32M
join_buffer_size        = 128K

query_cache_limit       = 2M
query_cache_size        = 64M

sort_buffer_size        = 32M
read_buffer_size        = 4M
read_rnd_buffer_size    = 4M
myisam_sort_buffer_size = 256M
thread_cache_size       = 8

character_set_server = utf8
collation_server = utf8_unicode_ci

myisam-recover          = BACKUP

#log            = /var/log/mysql/mysql.log
log-error               = /var/log/mysql/error.log
log_slow_queries        = /var/log/mysql/mysql-slow.log
long_query_time = 5
#log-queries-not-using-indexes

expire_logs_days        = 10
max_binlog_size         = 100M

#
# * InnoDB
#
#skip-innodb
innodb_buffer_pool_size         = 1024M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size            = 128M
innodb_log_buffer_size          = 8M
innodb_flush_log_at_trx_commit  = 1
innodb_lock_wait_timeout        = 50

#
# * Federated
#
skip-federated

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M

!includedir /etc/mysql/conf.d/