etc/mysql/my.cnf

   1 [client]
   2 port            = 3306
   3 socket          = /var/run/mysqld/mysqld.sock
   4 [mysqld_safe]
   5 nice            = 0
   6 socket          = /var/run/mysqld/mysqld.sock
   7 [mysqld]
   8 # chroot = /var/lib/mysql/
   9 # ssl-ca=/etc/mysql/cacert.pem
  10 # ssl-cert=/etc/mysql/server-cert.pem
  11 # ssl-key=/etc/mysql/server-key.pem
  12 basedir         = /usr
  13 bind-address            = 127.0.0.1
  14 #binlog_do_db           = include_database_name
  15 #binlog_ignore_db       = include_database_name
  16 datadir         = /home/mysql
  17 expire_logs_days        = 10
  18 #general_log             = 1
  19 #general_log_file        = /var/log/mysql/mysql.log
  20 key_buffer              = 16M
  21 lc-messages-dir = /usr/share/mysql
  22 #log-queries-not-using-indexes
  23 #log_bin                        = /var/log/mysql/mysql-bin.log
  24 #log_slow_queries       = /var/log/mysql/mysql-slow.log
  25 #long_query_time = 2
  26 max_allowed_packet      = 16M
  27 max_binlog_size         = 100M
  28 #max_connections        = 100
  29 myisam-recover         = BACKUP
  30 pid-file        = /var/run/mysqld/mysqld.pid
  31 port            = 3306
  32 query_cache_limit       = 1M
  33 query_cache_size        = 16M
  34 #server-id              = 1
  35 skip-external-locking
  36 socket          = /var/run/mysqld/mysqld.sock
  37 #table_cache            = 64
  38 thread_cache_size       = 8
  39 #thread_concurrency     = 10
  40 thread_stack            = 192K
  41 tmpdir          = /tmp
  42 user            = mysql
  43 [mysqldump]
  44 max_allowed_packet      = 16M
  45 quick
  46 quote-names
  47 [mysql]
  48 #no-auto-rehash # faster start of mysql but no tab completition
  49 [isamchk]
  50 key_buffer              = 16M
  51 !includedir /etc/mysql/conf.d/