mysql/my.cnf@6b18bb69901e
mysql/my.cnf
Tue, 28 Aug 2012 18:36:35 +0200
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Tue, 28 Aug 2012 18:36:35 +0200
- changeset 579
- 6b18bb69901e
- child 698
- 31b10e374497
- permissions
- -rw-r--r--
Correct the paths of patched scripts, refine password generation,
mitigate fdatasync(2) detection problems, correct dependencies, remove
outdated autoconf components, correct conf file paths and attributes,
complete and correct log file rotation handing, and note warnings
useful for diagnosing builds.
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@
