]>
Commit | Line | Data |
---|---|---|
27a83527 JP |
1 | [client] |
2 | socket=/srv/mysql/mysql.sock | |
27a83527 JP |
3 | |
4 | [mysql] | |
5 | socket=/srv/mysql/mysql.sock | |
713482da | 6 | ssl_ca=/etc/pki/tls/certs/ca.pem |
27a83527 JP |
7 | |
8 | [mysqld] | |
9 | datadir=/srv/mysql | |
10 | log_slow_queries | |
11 | long_query_time=4 | |
d824f16b | 12 | max_connections=512 |
27a83527 | 13 | max_connect_errors=0 |
a7f56b30 QS |
14 | wait_timeout=300 |
15 | interactive_timeout=300 | |
27a83527 JP |
16 | connect_timeout=10 |
17 | local_infile=0 | |
18 | ft_min_word_len=3 | |
19 | expire_logs_days=7 | |
20 | ||
21 | # Bump the max open files (*grumble* esp) | |
22 | # 2008-09-24 -- quentin | |
23 | open_files_limit=8192 | |
24 | ||
25 | log-bin=sql-bin | |
26 | log-bin-index=sql-bin.index | |
27 | relay-log=kitchen-sink-relay-bin | |
28 | relay-log-index=kitchen-sink-relay-bin.index | |
29 | ||
30 | query_cache_limit=1M | |
31 | query_cache_size=128M | |
32 | query_cache_type=1 | |
33 | thread_cache_size=8 | |
34 | table_cache=512 | |
35 | key_buffer=384M | |
36 | join_buffer=1M | |
37 | record_buffer=1M | |
38 | max_allowed_packet=16M | |
39 | sort_buffer_size=2M | |
40 | read_buffer_size=2M | |
41 | read_rnd_buffer_size=8M | |
42 | tmp_table_size=32M | |
43 | thread_concurrency=4 | |
44 | myisam_sort_buffer_size=64M | |
45 | ||
46 | innodb_buffer_pool_size=512M | |
47 | innodb_additional_mem_pool_size=20M | |
713482da | 48 | innodb_log_file_size=128M |
27a83527 JP |
49 | innodb_log_buffer_size=8M |
50 | innodb_lock_wait_timeout=50 | |
51 | innodb_thread_concurrency=4 | |
27a83527 JP |
52 | innodb_file_per_table |
53 | ||
54 | old_passwords=1 | |
55 | server-id=1 | |
56 | ||
57 | ssl_ca=/etc/pki/tls/certs/ca.pem | |
58 | ssl_cert=/etc/pki/tls/certs/sql.pem | |
59 | ssl_key=/etc/pki/tls/private/sql.pem | |
60 | ||
27a83527 JP |
61 | skip-name-resolve |
62 | ||
63 | # Disable the "data directory" option: | |
64 | # <quentin> 2008-07-14 | |
65 | skip-symbolic-links | |
66 | ||
67 | [mysqldump] | |
68 | quick | |
69 | quote-names | |
70 | max_allowed_packet = 16M |