root@host:~# cat /etc/mysql/my.cnf | grep -v "^#"

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


[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
lc-messages-dir	= /usr/share/mysql
skip-external-locking
log-error=/var/log/mysql-errors.log


key_buffer_size		= 2048M

max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
max-connect_errors = 50

max_connections		= 500
table_cache		= 1024
wait_timeout		= 120
interactive_timeout	= 100
connect_timeout		= 120
query_cache_limit	= 4M
query_cache_size        = 128M

join_buffer_size = 4M
read_buffer_size = 2M
sort_buffer_size = 8M


tmp_table_size = 512M
max_heap_table_size = 512M

table_open_cache = 36288

transaction-isolation = READ-COMMITTED
innodb_buffer_pool_size = 2048M

innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
open_files_limit = 18200

log_slow_queries	= /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
expire_logs_days	= 10
max_binlog_size         = 100M
character-set-server = utf8



[mysqldump]
quick
quote-names
max_allowed_packet	= 16M
default-character-set = utf8

[mysql]
[isamchk]
key_buffer		= 16M

!includedir /etc/mysql/conf.d/