comparison: mysql/my.cnf
mysql/my.cnf
- changeset 527
- 7b145ccff1e9
- child 698
- 31b10e374497
equal
deleted
inserted
replaced
| -1:000000000000 | 0:97b6eecbb162 |
|---|---|
| 1 ## | |
| 2 ## my.cnf -- MySQL configuration | |
| 3 ## | |
| 4 | |
| 5 [client] | |
| 6 | |
| 7 socket = @l_prefix@/var/mysql/mysql.sock | |
| 8 port = 3306 | |
| 9 | |
| 10 [mysqld] | |
| 11 | |
| 12 bind-address = 127.0.0.1 | |
| 13 port = 3306 | |
| 14 #skip-networking | |
| 15 | |
| 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 | |
| 20 | |
| 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 | |
| 38 | |
| 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 | |
| 46 | |
| 47 </with_innobase> | |
| 48 [mysqld_safe] | |
| 49 | |
| 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@ | |
| 55 |
