mysql/my.cnf@300d43423c2e
mysql/my.cnf
Wed, 08 Feb 2012 20:07:00 +0200
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Wed, 08 Feb 2012 20:07:00 +0200
- changeset 588
- 300d43423c2e
- child 698
- 31b10e374497
- permissions
- -rw-r--r--
Update version, adapt patch, correct PID writing, correct build on newer
FreeBSD releases, and most importantly introduce new patch to try to
avoid segfault caused by multiple network interfaces with the same (or
no) address. This is common when configuring bridges and tunnels.
1 ##
2 ## my.cnf -- MySQL configuration
3 ##
5 [client]
7 socket = @l_prefix@/var/mysql/mysql.sock
8 port = 3306
10 [mysqld]
12 bind-address = 127.0.0.1
13 port = 3306
14 #skip-networking
16 tmpdir = @l_prefix@/var/mysql/tmp
17 log = @l_prefix@/var/mysql/common.log
18 #log-bin = @l_prefix@/var/mysql/binary.log
19 #server-id = 1
21 key_buffer_size = 64M
22 table_cache = 256
23 join_buffer_size = 1M
24 max_connections = 1000
25 max_connect_errors = 10
26 max_delayed_threads = 20
27 max_heap_table_size = 16777216
28 max_sort_length = 1024
29 max_user_connections = 1000
30 record_buffer = 131072
31 sort_buffer = 4M
32 key_buffer = 1M
33 tmp_table_size = 32M
34 query_cache_type = 1
35 query_cache_limit = 1M
36 query_cache_size = 32M
37 ft_min_word_len = 3
39 <with_innobase>
40 innodb_buffer_pool_size = 70M
41 innodb_additional_mem_pool_size = 2M
42 innodb_log_files_in_group = 3
43 innodb_log_file_size = 20M
44 innodb_log_buffer_size = 8M
45 innodb_lock_wait_timeout = 50
47 </with_innobase>
48 [mysqld_safe]
50 datadir = @l_prefix@/var/mysql
51 socket = @l_prefix@/var/mysql/mysql.sock
52 pid_file = @l_prefix@/var/mysql/mysqld.pid
53 user = @l_rusr@
54 basedir = @l_prefix@
