mysql/my.cnf@3ee660c5bc4f (annotated)
mysql/my.cnf
Tue, 02 Apr 2013 20:44:50 +0200
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Tue, 02 Apr 2013 20:44:50 +0200
- changeset 767
- 3ee660c5bc4f
- parent 527
- 7b145ccff1e9
- permissions
- -rw-r--r--
Correct initial database generation and improve runcommand script logic.
| 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@698 | 30 | read_buffer_size = 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 |
