|
Lines 14-32
bind-address = 127.0.0.1
Link Here
|
| 14 |
basedir = %%PREFIX%% |
14 |
basedir = %%PREFIX%% |
| 15 |
datadir = %%MY_DBDIR%% |
15 |
datadir = %%MY_DBDIR%% |
| 16 |
tmpdir = %%MY_TMPDIR%% |
16 |
tmpdir = %%MY_TMPDIR%% |
| 17 |
slave-load-tmpdir = %%MY_TMPDIR%% |
17 |
replica-load-tmpdir = %%MY_TMPDIR%% |
| 18 |
secure-file-priv = %%MY_SECDIR%% |
18 |
secure-file-priv = %%MY_SECDIR%% |
| 19 |
log-bin = mysql-bin |
19 |
log-bin = mysql-bin |
| 20 |
log-output = TABLE |
20 |
log-output = TABLE |
| 21 |
master-info-repository = TABLE |
|
|
| 22 |
relay-log-info-repository = TABLE |
| 23 |
relay-log-recovery = 1 |
21 |
relay-log-recovery = 1 |
| 24 |
slow-query-log = 1 |
22 |
slow-query-log = 1 |
| 25 |
server-id = 1 |
23 |
server-id = 1 |
| 26 |
sync_binlog = 1 |
24 |
sync_binlog = 1 |
| 27 |
sync_relay_log = 1 |
25 |
sync_relay_log = 1 |
| 28 |
binlog_cache_size = 16M |
26 |
binlog_cache_size = 16M |
| 29 |
expire_logs_days = 30 |
27 |
binlog_expire_logs_seconds = 2592000 |
| 30 |
default_password_lifetime = 0 |
28 |
default_password_lifetime = 0 |
| 31 |
enforce-gtid-consistency = 1 |
29 |
enforce-gtid-consistency = 1 |
| 32 |
gtid-mode = ON |
30 |
gtid-mode = ON |
|
Lines 47-58
innodb_log_group_home_dir = %%MY_DBDIR%%
Link Here
|
| 47 |
innodb_data_file_path = ibdata1:128M:autoextend |
45 |
innodb_data_file_path = ibdata1:128M:autoextend |
| 48 |
innodb_temp_data_file_path = ibtmp1:128M:autoextend |
46 |
innodb_temp_data_file_path = ibtmp1:128M:autoextend |
| 49 |
innodb_flush_method = O_DIRECT |
47 |
innodb_flush_method = O_DIRECT |
| 50 |
innodb_log_file_size = 256M |
48 |
innodb_redo_log_capacity = 512M |
| 51 |
innodb_log_buffer_size = 16M |
49 |
innodb_log_buffer_size = 16M |
| 52 |
innodb_write_io_threads = 8 |
50 |
innodb_write_io_threads = 8 |
| 53 |
innodb_read_io_threads = 8 |
51 |
innodb_read_io_threads = 8 |
| 54 |
innodb_autoinc_lock_mode = 2 |
52 |
innodb_autoinc_lock_mode = 2 |
| 55 |
skip-symbolic-links |
|
|
| 56 |
|
53 |
|
| 57 |
[mysqldump] |
54 |
[mysqldump] |
| 58 |
max_allowed_packet = 256M |
55 |
max_allowed_packet = 256M |