mysql/my.cnf@300d43423c2e (annotated)
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.
| michael@527 | 1 | ## |
| michael@527 | 2 | ## my.cnf -- MySQL configuration |
| michael@527 | 3 | ## |
| michael@527 | 4 | |
| michael@527 | 5 | [client] |
| michael@527 | 6 | |
| michael@527 | 7 | socket = @l_prefix@/var/mysql/mysql.sock |
| michael@527 | 8 | port = 3306 |
| michael@527 | 9 | |
| michael@527 | 10 | [mysqld] |
| michael@527 | 11 | |
| michael@527 | 12 | bind-address = 127.0.0.1 |
| michael@527 | 13 | port = 3306 |
| michael@527 | 14 | #skip-networking |
| michael@527 | 15 | |
| michael@527 | 16 | tmpdir = @l_prefix@/var/mysql/tmp |
| michael@527 | 17 | log = @l_prefix@/var/mysql/common.log |
| michael@527 | 18 | #log-bin = @l_prefix@/var/mysql/binary.log |
| michael@527 | 19 | #server-id = 1 |
| michael@527 | 20 | |
| michael@527 | 21 | key_buffer_size = 64M |
| michael@527 | 22 | table_cache = 256 |
| michael@527 | 23 | join_buffer_size = 1M |
| michael@527 | 24 | max_connections = 1000 |
| michael@527 | 25 | max_connect_errors = 10 |
| michael@527 | 26 | max_delayed_threads = 20 |
| michael@527 | 27 | max_heap_table_size = 16777216 |
| michael@527 | 28 | max_sort_length = 1024 |
| michael@527 | 29 | max_user_connections = 1000 |
| michael@527 | 30 | record_buffer = 131072 |
| michael@527 | 31 | sort_buffer = 4M |
| michael@527 | 32 | key_buffer = 1M |
| michael@527 | 33 | tmp_table_size = 32M |
| michael@527 | 34 | query_cache_type = 1 |
| michael@527 | 35 | query_cache_limit = 1M |
| michael@527 | 36 | query_cache_size = 32M |
| michael@527 | 37 | ft_min_word_len = 3 |
| michael@527 | 38 | |
| michael@527 | 39 | <with_innobase> |
| michael@527 | 40 | innodb_buffer_pool_size = 70M |
| michael@527 | 41 | innodb_additional_mem_pool_size = 2M |
| michael@527 | 42 | innodb_log_files_in_group = 3 |
| michael@527 | 43 | innodb_log_file_size = 20M |
| michael@527 | 44 | innodb_log_buffer_size = 8M |
| michael@527 | 45 | innodb_lock_wait_timeout = 50 |
| michael@527 | 46 | |
| michael@527 | 47 | </with_innobase> |
| michael@527 | 48 | [mysqld_safe] |
| michael@527 | 49 | |
| michael@527 | 50 | datadir = @l_prefix@/var/mysql |
| michael@527 | 51 | socket = @l_prefix@/var/mysql/mysql.sock |
| michael@527 | 52 | pid_file = @l_prefix@/var/mysql/mysqld.pid |
| michael@527 | 53 | user = @l_rusr@ |
| michael@527 | 54 | basedir = @l_prefix@ |
| michael@527 | 55 |
