-
Notifications
You must be signed in to change notification settings - Fork 3
/
my.ini
43 lines (39 loc) · 1.77 KB
/
my.ini
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
[mysqld]
port = 3306
key-buffer-size = 16M
max-allowed-packet = 128M
max_connections = 10000
character_set_server = utf8mb4
basedir = C:\Users\yakir\app\mysql-8.0.31-winx64
pid-file = C:\Users\yakir\app\mysql-8.0.31-winx64\mysql.pid
socket = C:\Users\yakir\app\mysql-8.0.31-winx64\mysql.sock
datadir = C:\Users\yakir\app\mysql-8.0.31-winx64\data\
log-error = C:\Users\yakir\app\mysql-8.0.31-winx64\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 = C:\Users\yakir\app\mysql-8.0.31-winx64\tmpdir
lower-case-table-names = 2
innodb_print_ddl_logs = 1
# 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
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