mysql/my.cnf@3b08e6396b45
mysql/my.cnf
Tue, 28 Aug 2012 18:28:45 +0200
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Tue, 28 Aug 2012 18:28:45 +0200
- changeset 528
- 3b08e6396b45
- child 698
- 31b10e374497
- permissions
- -rw-r--r--
Massively update from 5.1 to 5.5 release, completely changing from
autotools to cmake build configuration along with the corresponding
corrections. Correct some less important problems like typical german
english mistakes, as well as use parallel make for faster builds with
SMP and multicore architectures. Warning, the 5.5 releases of MySQL
seem to be equally bug ridden as the 5.1 are, for example building
the NDBCluster storage engine fails.
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@
