-
Notifications
You must be signed in to change notification settings - Fork 3
/
my.cnf
50 lines (45 loc) · 1.89 KB
/
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
41
42
43
44
45
46
47
48
49
50
[client]
port = 3306
socket = /Volumes/sm/repos/mysql/mysql.sock
[mysqld]
port = 3306
key-buffer-size = 16M
max-allowed-packet = 128M
max_connections = 10000
character_set_server = utf8mb4
basedir = /Volumes/sm/servers/mysql
pid-file = /Volumes/sm/repos/mysql/mysql.pid
socket = /Volumes/sm/repos/mysql/mysql.sock
datadir = /Volumes/sm/repos/mysql/data/
log-error = /Volumes/sm/repos/mysql/logs/error.log
secure-file-priv = NULL
# symbolic-links = FALSE
# ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
# ssl = FALSE
# tls-version = ''
# admin_tls_version = ''
sql-mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
tmpdir = /Volumes/sm/repos/mysql/tmpdir
lower-case-table-names = 2
innodb_print_ddl_logs = 1
max_allowed_packet = 1024M
# eq_range_index_dive_limit = 1000
# Custom config should go here
# !includedir /etc/mysql/conf.d/
# log_output = TABLE
log_output = FILE
slow-query-log = true
slow-query-log-file = /Volumes/sm/repos/mysql/logs/ykmac-slow.log
# general_log = on
# general_log_file ='/Volumes/sm/repos/mysql/logs/ykmac-general.log'
log-bin = mysql-log
binlog-format = ROW
binlog-row-image = FULL
server-id = 1
log-bin-index = mysql-log
binlog-row-event-max-size = 1024
# expire-logs-days = 7
binlog_expire_logs_seconds = 302400
default-time-zone = '+08:00'
[mysqldump]
quick