-
Notifications
You must be signed in to change notification settings - Fork 19
/
Copy pathmy.cnf
42 lines (36 loc) · 921 Bytes
/
my.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
[mysqld]
binlog_format = MIXED
server-id=
log-bin
read_only=1
innodb_buffer_pool_size=32MB
default-storage-engine=InnoDB
innodb_log_buffer_size=256K
query_cache_size=0
max_connections=200
key_buffer_size=8
thread_cache_size=0
host_cache_size=0
innodb_ft_cache_size=1600000
innodb_ft_total_cache_size=32000000
log_slave_updates
master_info_repository=TABLE
# per thread or per operation settings
thread_stack=131072
sort_buffer_size=32K
read_buffer_size=8200
read_rnd_buffer_size=8200
max_heap_table_size=16K
tmp_table_size=1K
bulk_insert_buffer_size=0
join_buffer_size=128
net_buffer_length=1K
innodb_sort_buffer_size=64K
#settings that relate to the binary log (if enabled)
binlog_cache_size=4K
binlog_stmt_cache_size=4K
performance_schema=OFF
#log=/var/log/mysql/mysql.log
#log_error=/var/log/mysql/mysql.err
#general_log_file=/var/log/mysql/mysql_general.log
#slow_query_log_file= /var/log/mysql/mysql_slow.log