$ cd /etc
$ vi my.cnf

# The MySQL server
[mysqld]
max_allowed_packet = 64M

sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# Typo3 Optimierungen
max_connections = 100
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1
table_cache = 256
key_buffer_size = 64M

[mysqldump]
quick
max_allowed_packet = 16M

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
[mysqld]
#
# * Basic Settings
#
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
language        = /usr/share/mysql/english
skip-external-locking

#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 48M
max_allowed_packet      = 48M
thread_stack            = 512KK
thread_cache_size       = 8
sort_buffer_size        = 4M
join_buffer_size        = 4M
net_buffer_length       = 8K
read_buffer_size        = 4M
read_rnd_buffer_size    = 4M
myisam_sort_buffer_size = 48M

# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover          = BACKUP
#max_connections        = 100
#table_cache            = 64
thread_concurrency     = 10
#
# * Query Cache Configuration
#

query_cache_limit       = 2M
query_cache_size        = 48M
max_connections         = 200
query_cache_limit       = 2M
query_cache_type        = 1
table_cache             = 512
key_buffer_size         = 32M
open_files_limit        = 2024
[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

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

[isamchk]
key_buffer              = 48M
sort_buffer_size        = 48M
read_buffer             = 4M
write_buffer            = 4M
# ndb-connectstring=127.0.0.1

[mysqlhotcopy]
interactive-timeout

#
# * 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/