mysql/my.cnf@9dacbd1d1aa2
mysql/my.cnf
Fri, 07 Sep 2012 19:08:07 +0200
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Fri, 07 Sep 2012 19:08:07 +0200
- changeset 667
- 9dacbd1d1aa2
- child 698
- 31b10e374497
- permissions
- -rw-r--r--
Correct build configuration in Solaris subdir, correct english grammar,
remove irrelevant strip notice, introduce custom CFLAG logic, facilitate
use of Solaris Studio compiler with needed build configuration
adjustments, conditionally build 64 bit position independent code,
and accommodate tun(7) in newer Solaris releases by renaming driver
and module from conflicting 'tun' to 'vtun'. These changes include
some nonstandard 'I give up' logic causing out of tree builds by
manipulating the PATH, for example.
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@
