mysql/my.cnf@cbbc8daa8174
mysql/my.cnf
Wed, 22 Jan 2014 21:02:10 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Wed, 22 Jan 2014 21:02:10 +0100
- changeset 789
- cbbc8daa8174
- parent 527
- 7b145ccff1e9
- permissions
- -rw-r--r--
Import package vendor original specs for necessary manipulations.
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 read_buffer_size = 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@
