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.
7 # One can use all long options that the program supports.
8 # Run the program with --help to get a list of available options
10 # This will be passed to all mysql clients
12 #password = my_password
14 socket = /var/run/mysqld/mysqld.sock
16 # Here is entries for some specific programs
17 # The following values assume you have at least 32M ram
20 err-log = /var/log/mysql/mysql.err
24 pid-file = /var/run/mysqld/mysqld.pid
25 socket = /var/run/mysqld/mysqld.sock
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
33 datadir = /var/lib/mysql
35 language = /usr/share/mysql/english
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.
42 set-variable = key_buffer=16M
43 set-variable = max_allowed_packet=1M
44 set-variable = thread_stack=128K
46 # Here you can see queries with especially long duration
47 #log-slow-queries = /var/log/mysql/mysql-slow.log
49 # The following can be used as easy to replay backup logs or for replication
51 #log-bin = /var/log/mysql/mysql-bin.log
52 #binlog-do-db = include_database_name
53 #binlog-ignore-db = include_database_name
57 # AB HIER WICHTIGES INNO ZEUGS
61 # Read the manual if you want to enable InnoDB!
65 # You can write your other MySQL server options here
67 # Datafile(s) must be able to
68 # hold your data and indexes.
69 # Make sure you have enough
71 innodb_data_file_path = ibdata1:10M:autoextend
72 # Set buffer pool size to
73 # 50 - 80 % of your computer's
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
87 # BIS HIER WICHTIGES INNO-ZEUGS
92 set-variable = max_allowed_packet=1M
95 #no-auto-rehash # faster start of mysql but no tab completition
98 set-variable = key_buffer=16M