-
Notifications
You must be signed in to change notification settings - Fork 0
/
mariadb.cnf
126 lines (110 loc) · 3.55 KB
/
mariadb.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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
[client]
port = 3358
socket = /export/data/mariadb10119/tmp/maria.sock
default-character-set = utf8
[mysqld]
port = 3358
bind-address = 0.0.0.0
lower_case_table_names = 1
basedir = /export/server/mariadb10119
datadir = /export/data/mariadb10119/data
tmpdir = /export/data/mariadb10119/tmp
socket = /export/data/mariadb10119/tmp/maria.sock
#######################################
log-output = FILE
log-error = /export/data/mariadb10119/log/error.log
#general_log
general_log_file = /export/data/mariadb10119/log/mysql.log
pid-file = /export/data/mariadb10119/data/mysql.pid
slow-query-log
slow_query_log_file = /export/data/mariadb10119/log/slow.log
tmpdir = /export/data/mariadb10119/tmp/
long_query_time = 0.1
sync_binlog = 1
skip-external-locking
skip-name-resolve
default-storage-engine = INNODB
character-set-server = utf8
wait_timeout = 28400
back_log = 1024
#########################
thread_concurrency = 16
thread_cache_size = 512
table_open_cache = 16384
table_definition_cache = 16384
sort_buffer_size = 2M
join_buffer_size = 2M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
key_buffer_size = 64M
myisam_sort_buffer_size = 64M
tmp_table_size = 256M
max_heap_table_size = 256M
open_files_limit = 65535
##### Network ######################
max_allowed_packet = 16M
interactive_timeout = 28400
wait_timeout = 28400
max-connections = 1000
max_user_connections = 0
max_connect_errors = 100
###### Repl #####################
server-id = 180983358
log-bin = mysql-bin
binlog_format = mixed
expire_logs_days = 7
relay-log = relay-log
replicate_wild_ignore_table=miniwms_flow.%
replicate_wild_ignore_table=miniwms_log.%
replicate_wild_ignore_table=miniwms_permission.%
replicate_wild_ignore_table=miniwms_pk.%
replicate_wild_ignore_table=miniwms_task_funnel.%
replicate_wild_ignore_table=miniwms_ump.%
replicate_wild_ignore_table=mysql.%
replicate_wild_ignore_table=test.%
log_slave_updates
skip-slave-start
relay_log_recovery = 1
##### Innodb ###########
innodb_data_home_dir = /export/data/mariadb10119/data
innodb_data_file_path = ibdata1:5G;ibdata2:5G:autoextend
innodb_autoextend_increment = 500
innodb_log_group_home_dir = /export/data/mariadb10119/data
innodb_buffer_pool_size = 88G
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_instances = 8
innodb_additional_mem_pool_size = 128M
innodb_log_files_in_group = 3
innodb_log_file_size = 512M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 120
innodb_flush_method = O_DIRECT
innodb_max_dirty_pages_pct = 75
innodb_io_capacity = 1000
innodb_thread_concurrency = 0
innodb_thread_sleep_delay = 500
innodb_concurrency_tickets = 1000
innodb_open_files = 65535
innodb_file_per_table = 1
thread_handling = pool-of-threads
###### NUMA #########################
innodb_buffer_pool_populate = 1
##################################
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
default-character-set=utf8
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqld_safe]
###### CLOSED NUMA ###########
flush_caches
numa_interleave
[mysqlhotcopy]