MySQL

my.conf

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

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

[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
#bind-address		= 127.0.0.1
#bind-address		= 192.168.1.103
key_buffer		= 256M
key_buffer_size         = 2048M
innodb_buffer_pool_size = 2048M
max_allowed_packet	= 128M
thread_stack		= 512K
thread_cache_size       = 32
myisam-recover         = BACKUP
#max_connections        = 100
table_cache             = 4096
#thread_concurrency     = 10
query_cache_size        = 1024M
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#server-id		= 1
#log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
# chroot = /var/lib/mysql/
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

server-id=1338828913

[mysqldump]
quick
quote-names
max_allowed_packet	= 512M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
[isamchk]
key_buffer		= 128M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/