-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmy80_audit.cnf
More file actions
69 lines (64 loc) · 1.84 KB
/
my80_audit.cnf
File metadata and controls
69 lines (64 loc) · 1.84 KB
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
[client]
user =root
password =Oracle20!8
socket =/opt/mysql/8018/mysql.socket
port =3380
[mysql]
no-beep
port =3380
no-auto-rehash
compress
show-warnings
prompt = \R:\m \d>\_
[mysqld_safe]
log-error =/opt/mysql/8018/mysqld_8018.log
[mysqld]
#user =mysql
port =3380
#basedir =/usr/local/mysql
datadir =/opt/mysql/8018/data
socket =/opt/mysql/8018/mysql.socket
#lc_messages_dir =/usr/local/mysql/mysql-commercial-8.0.12-linux-glibc2.12-x86_64/share
lc_messages_dir =/usr/local/mysql/mysql-commercial-8.0.18-linux-x86_64-minimal/share
default-storage-engine =INNODB
#sql-mode ="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
lower_case_table_names =1
general-log =1
general_log_file =khollman_8018.log
slow-query-log =1
slow_query_log_file =khollman_8018-slow.log
long_query_time =10
log-error =khollman_8018.err
max_connections =100
#query_cache_type =0
#query_cache_size =0
innodb_file_per_table =1
innodb_log_buffer_size =4M
innodb_buffer_pool_size =75M
innodb_log_file_size =10M
innodb_flush_log_at_trx_commit =2
innodb_data_home_dir =/opt/mysql/8018/data
innodb_data_file_path =ibdata1:10M;ibdata2:10M:autoextend
# Replication
server-id =1
log-slave-updates =TRUE
gtid-mode =ON
enforce-gtid-consistency =TRUE
master-info-repository =TABLE
relay-log-info-repository =TABLE
sync_binlog =1
sync_master_info =1
slave-parallel-workers =2
slave_transaction_retries =0
binlog-checksum =CRC32
master-verify-checksum =1
slave-sql-verify-checksum =1
binlog-rows-query-log-events =1
report-port =3380
log-bin =khollman_8018
binlog_format =ROW
report-host =khollman
#replicate-do-db =nexus
default_authentication_plugin='mysql_native_password'
performance_schema_consumer_events_statements_history_long = ON
#audit-log=FORCE_PLUS_PERMANENT