]>
Commit | Line | Data |
---|---|---|
a677e393 JP |
1 | [client] |
2 | socket=/srv/mysql/mysql.sock | |
3 | ||
4 | [mysql] | |
5 | socket=/srv/mysql/mysql.sock | |
6 | ||
7 | [mysqld] | |
8 | datadir=/srv/mysql | |
9 | log_slow_queries | |
10 | long_query_time=2 | |
11 | max_connections=5000 | |
12 | #max_connect_errors=10 | |
13 | wait_timeout=600 | |
14 | interactive_timeout=600 | |
15 | connect_timeout=10 | |
16 | ||
17 | log-bin=sql-bin | |
18 | log-bin-index=sql-bin.index | |
19 | relay-log=kitchen-sink-relay-bin | |
20 | relay-log-index=kitchen-sink-relay-bin.index | |
21 | ||
22 | skip-locking | |
23 | #skip-external-locking | |
24 | ||
25 | query_cache_limit=1M | |
26 | query_cache_size=128M | |
27 | query_cache_type=1 | |
28 | thread_cache_size=8 | |
29 | table_cache=1024 | |
30 | key_buffer=400M | |
31 | join_buffer=1M | |
32 | record_buffer=1M | |
33 | max_allowed_packet=16M | |
34 | sort_buffer_size=2M | |
35 | read_buffer_size=2M | |
36 | read_rnd_buffer_size=8M | |
37 | tmp_table_size=35M | |
38 | thread_concurrency=4 | |
39 | myisam_sort_buffer_size=8M | |
40 | ||
41 | innodb_buffer_pool_size=512M | |
42 | innodb_additional_mem_pool_size=20M | |
43 | innodb_log_file_size=200M | |
44 | innodb_log_buffer_size=2M | |
45 | #innodb_lock_wait_timeout=50 | |
46 | ||
47 | innodb_file_per_table | |
48 | ||
49 | old_passwords=1 | |
50 | server-id=1 | |
51 | ||
52 | skip-bdb | |
53 | #skip-networking | |
54 | ||
55 | [mysqldump] | |
56 | quick | |
57 | quote-names | |
58 | max_allowed_packet = 16M |