1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/mysql/my.cnf Tue Aug 28 18:28:40 2012 +0200
1.3 @@ -0,0 +1,55 @@
1.4 +##
1.5 +## my.cnf -- MySQL configuration
1.6 +##
1.7 +
1.8 +[client]
1.9 +
1.10 +socket = @l_prefix@/var/mysql/mysql.sock
1.11 +port = 3306
1.12 +
1.13 +[mysqld]
1.14 +
1.15 +bind-address = 127.0.0.1
1.16 +port = 3306
1.17 +#skip-networking
1.18 +
1.19 +tmpdir = @l_prefix@/var/mysql/tmp
1.20 +log = @l_prefix@/var/mysql/common.log
1.21 +#log-bin = @l_prefix@/var/mysql/binary.log
1.22 +#server-id = 1
1.23 +
1.24 +key_buffer_size = 64M
1.25 +table_cache = 256
1.26 +join_buffer_size = 1M
1.27 +max_connections = 1000
1.28 +max_connect_errors = 10
1.29 +max_delayed_threads = 20
1.30 +max_heap_table_size = 16777216
1.31 +max_sort_length = 1024
1.32 +max_user_connections = 1000
1.33 +record_buffer = 131072
1.34 +sort_buffer = 4M
1.35 +key_buffer = 1M
1.36 +tmp_table_size = 32M
1.37 +query_cache_type = 1
1.38 +query_cache_limit = 1M
1.39 +query_cache_size = 32M
1.40 +ft_min_word_len = 3
1.41 +
1.42 +<with_innobase>
1.43 +innodb_buffer_pool_size = 70M
1.44 +innodb_additional_mem_pool_size = 2M
1.45 +innodb_log_files_in_group = 3
1.46 +innodb_log_file_size = 20M
1.47 +innodb_log_buffer_size = 8M
1.48 +innodb_lock_wait_timeout = 50
1.49 +
1.50 +</with_innobase>
1.51 +[mysqld_safe]
1.52 +
1.53 +datadir = @l_prefix@/var/mysql
1.54 +socket = @l_prefix@/var/mysql/mysql.sock
1.55 +pid_file = @l_prefix@/var/mysql/mysqld.pid
1.56 +user = @l_rusr@
1.57 +basedir = @l_prefix@
1.58 +
