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