/mysql/my.cnf

  1#
  2# The MySQL database server configuration file.
  3#
  4# You can copy this to one of:
  5# - "/etc/mysql/my.cnf" to set global options,
  6# - "~/.my.cnf" to set user-specific options.
  7# 
  8# One can use all long options that the program supports.
  9# Run program with --help to get a list of available options and with
 10# --print-defaults to see which it would actually understand and use.
 11#
 12# For explanations see
 13# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 14
 15# This will be passed to all mysql clients
 16# It has been reported that passwords should be enclosed with ticks/quotes
 17# escpecially if they contain "#" chars...
 18# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
 19[client]
 20port		= 3306
 21socket		= /var/run/mysqld/mysqld.sock
 22
 23# Here is entries for some specific programs
 24# The following values assume you have at least 32M ram
 25
 26# This was formally known as [safe_mysqld]. Both versions are currently parsed.
 27[mysqld_safe]
 28socket		= /var/run/mysqld/mysqld.sock
 29nice		= 0
 30
 31[mysqld]
 32#
 33# * Basic Settings
 34#
 35
 36#
 37# * IMPORTANT
 38#   If you make changes to these settings and your system uses apparmor, you may
 39#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
 40#
 41
 42user		= mysql
 43socket		= /var/run/mysqld/mysqld.sock
 44port		= 3306
 45basedir		= /usr
 46datadir		= /var/lib/mysql
 47tmpdir		= /tmp
 48skip-external-locking
 49#
 50# Instead of skip-networking the default is now to listen only on
 51# localhost which is more compatible and is not less secure.
 52bind-address		= 127.0.0.1
 53#
 54# * Fine Tuning
 55#
 56key_buffer		= 16M
 57max_allowed_packet	= 16M
 58thread_stack		= 192K
 59thread_cache_size       = 8
 60# This replaces the startup script and checks MyISAM tables if needed
 61# the first time they are touched
 62myisam-recover         = BACKUP
 63#max_connections        = 100
 64#table_cache            = 64
 65#thread_concurrency     = 10
 66#
 67# * Query Cache Configuration
 68#
 69query_cache_limit	= 1M
 70query_cache_size        = 16M
 71#
 72# * Logging and Replication
 73#
 74# Both location gets rotated by the cronjob.
 75# Be aware that this log type is a performance killer.
 76# As of 5.1 you can enable the log at runtime!
 77#general_log_file        = /var/log/mysql/mysql.log
 78#general_log             = 1
 79
 80log_error                = /var/log/mysql/error.log
 81
 82# Here you can see queries with especially long duration
 83#log_slow_queries	= /var/log/mysql/mysql-slow.log
 84#long_query_time = 2
 85#log-queries-not-using-indexes
 86#
 87# The following can be used as easy to replay backup logs or for replication.
 88# note: if you are setting up a replication slave, see README.Debian about
 89#       other settings you may need to change.
 90#server-id		= 1
 91#log_bin			= /var/log/mysql/mysql-bin.log
 92expire_logs_days	= 10
 93max_binlog_size         = 100M
 94#binlog_do_db		= include_database_name
 95#binlog_ignore_db	= include_database_name
 96#
 97# * InnoDB
 98#
 99# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
100# Read the manual for more InnoDB related options. There are many!
101#
102# * Security Features
103#
104# Read the manual, too, if you want chroot!
105# chroot = /var/lib/mysql/
106#
107# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
108#
109# ssl-ca=/etc/mysql/cacert.pem
110# ssl-cert=/etc/mysql/server-cert.pem
111# ssl-key=/etc/mysql/server-key.pem
112
113
114
115[mysqldump]
116quick
117quote-names
118max_allowed_packet	= 16M
119
120[mysql]
121#no-auto-rehash	# faster start of mysql but no tab completition
122
123[isamchk]
124key_buffer		= 16M
125
126#
127# * IMPORTANT: Additional settings that can override those from this file!
128#   The files must end with '.cnf', otherwise they'll be ignored.
129#
130!includedir /etc/mysql/conf.d/