var/my.cnf

   1 # You can copy this to one of:
   2 # /etc/mysql/my.cnf to set global options,
   3 # mysql-data-dir/my.cnf to set server-specific options (in this
   4 # installation this directory is /var/lib/mysql) or
   5 # ~/.my.cnf to set user-specific options.
   6 #
   7 # One can use all long options that the program supports.
   8 # Run the program with --help to get a list of available options
   9
  10 # This will be passed to all mysql clients
  11 [client]
  12 #password       = my_password
  13 port            = 3306
  14 socket          = /var/run/mysqld/mysqld.sock
  15
  16 # Here is entries for some specific programs
  17 # The following values assume you have at least 32M ram
  18
  19 [safe_mysqld]
  20 err-log         = /var/log/mysql/mysql.err
  21
  22 [mysqld]
  23 user            = mysql
  24 pid-file        = /var/run/mysqld/mysqld.pid
  25 socket          = /var/run/mysqld/mysqld.sock
  26 port            = 3306
  27 #
  28 # You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
  29 # for backward compatibility. Both location gets rotated by the cronjob.
  30 #log            = /var/log/mysql/mysql.log
  31 log             = /var/log/mysql.log
  32 basedir         = /usr
  33 datadir         = /var/lib/mysql
  34 tmpdir          = /tmp
  35 language        = /usr/share/mysql/english
  36 skip-locking
  37 #
  38 # The skip-networkin option will no longer be set via debconf menu.
  39 # You have to manually change it if you want networking i.e. the server
  40 # listening on port 3306. The default is "disable" - for security reasons.
  41 skip-networking
  42 set-variable    = key_buffer=16M
  43 set-variable    = max_allowed_packet=1M
  44 set-variable    = thread_stack=128K
  45 #
  46 # Here you can see queries with especially long duration
  47 #log-slow-queries       = /var/log/mysql/mysql-slow.log
  48 #
  49 # The following can be used as easy to replay backup logs or for replication
  50 #server-id              = 1
  51 #log-bin                = /var/log/mysql/mysql-bin.log
  52 #binlog-do-db           = include_database_name
  53 #binlog-ignore-db       = include_database_name
  54 #
  55
  56 #
  57 # AB HIER WICHTIGES INNO ZEUGS
  58 #
  59
  60
  61 # Read the manual if you want to enable InnoDB!
  62 # skip-innodb
  63 skip-bdb
  64
  65 # You can write your other MySQL server options here
  66 # ...
  67 #                                  Datafile(s) must be able to
  68 #                                  hold your data and indexes.
  69 #                                  Make sure you have enough
  70 #                                  free disk space.
  71 innodb_data_file_path = ibdata1:10M:autoextend
  72 #                                  Set buffer pool size to
  73 #                                  50 - 80 % of your computer's
  74 #                                  memory
  75 set-variable = innodb_buffer_pool_size=70M
  76 set-variable = innodb_additional_mem_pool_size=10M
  77 #                                  Set the log file size to about
  78 #                                  25 % of the buffer pool size
  79 set-variable = innodb_log_file_size=20M
  80 set-variable = innodb_log_buffer_size=8M
  81 #                                  Set ..flush_log_at_trx_commit
  82 #                                  to 0 if you can afford losing
  83 #                                  some last transactions
  84 innodb_flush_log_at_trx_commit=1
  85
  86 #
  87 # BIS HIER WICHTIGES INNO-ZEUGS
  88 #
  89
  90 [mysqldump]
  91 quick
  92 set-variable    = max_allowed_packet=1M
  93
  94 [mysql]
  95 #no-auto-rehash # faster start of mysql but no tab completition
  96
  97 [isamchk]
  98 set-variable    = key_buffer=16M