forked from enhancedformysql/mysql_8.0.27
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmy.cnf_slave_for_asyn_mgr_semi
141 lines (115 loc) · 3.23 KB
/
my.cnf_slave_for_asyn_mgr_semi
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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
[mysqld]
port=53306
server_id=2
report_host=127.0.0.1
default_authentication_plugin=mysql_native_password
pid-file = /yyy/data1/mysqld.pid
socket = /yyy/data1/mysqld.sock
datadir = /yyy/data1
log-error = /yyy/data1/error.log
log-bin = /yyy/data1/server-binary-log
relay-log = /yyy/data1/server-relay-log
query_prealloc_size=1048576
table_open_cache=50000
character-set-server = latin1
replication_optimize_for_static_plugin_config=ON
temptable_max_ram=42949672960
max_connections=20000
max_connect_errors=1000000
open_files_limit=65535
back_log=1500
skip_ssl
table_definition_cache=10000
thread_stack=256K
thread_cache_size=3000
sort_buffer_size=4M
join_buffer_size=4M
read_buffer_size=4M
read_rnd_buffer_size=4M
bulk_insert_buffer_size=64M
tmp_table_size=64M
max_heap_table_size=64M
net_buffer_length=16K
max_allowed_packet=1G
lock_wait_timeout=600
connect_timeout=10
interactive_timeout=31536000
wait_timeout=31536000
net_read_timeout=86400
net_write_timeout=86400
net_retry_count=10
log_output=FILE
log_timestamps=SYSTEM
log_error_verbosity=3
slow_query_log=OFF
long_query_time=0.3
log_queries_not_using_indexes=OFF
log_throttle_queries_not_using_indexes=60
log_slow_admin_statements=OFF
log_slow_slave_statements=OFF
min_examined_row_limit=0
general_log=OFF
binlog_format=ROW
sync_binlog=1
binlog_cache_size=4M
max_binlog_cache_size=4G
max_binlog_size=1G
binlog_rows_query_log_events=OFF
binlog_checksum=NONE
binlog_row_image=full
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_expire_logs_seconds=120
binlog_order_commits=OFF
innodb_log_file_size=8G
innodb_log_files_in_group=4
transaction_isolation=READ-COMMITTED
innodb_buffer_pool_size=64G
innodb_buffer_pool_instances=16
innodb_max_dirty_pages_pct=90
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1G
innodb_page_cleaners=4
innodb_buffer_pool_dump_at_shutdown=ON
innodb_buffer_pool_load_at_startup=ON
innodb_buffer_pool_dump_pct=100
innodb_checksum_algorithm=NONE
innodb_undo_log_truncate=OFF
innodb_change_buffering = none
innodb_spin_wait_delay=6
innodb_sync_spin_loops=30
innodb_open_files=65535
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_io_capacity=2000
innodb_io_capacity_max=5000
innodb_lru_scan_depth=9000
innodb_lock_wait_timeout=30
innodb_print_all_deadlocks=ON
innodb_online_alter_log_max_size=4G
innodb_thread_concurrency=0
innodb_read_io_threads=32
innodb_write_io_threads=32
innodb_doublewrite=ON
innodb_adaptive_hash_index=OFF
innodb_status_file=OFF
plugin_load_add='group_replication.so'
enforce-gtid-consistency
gtid-mode=on
loose-group_replication_member_expel_timeout=3
loose-group_replication_start_on_boot= OFF
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-baaaaaaaaaab"
loose-group_replication_local_address=127.0.0.1:53318
loose-group_replication_group_seeds= "127.0.0.1:63318,127.0.0.1:53318"
loose-group_replication_member_weight=50
loose-group_replication_applier_batch_size_threshold=10000
loose-group_replication_single_primary_fast_mode=1
loose-group_replication_flow_control_mode=disabled
loose-group_replication_broadcast_gtid_executed_period=1000
slave_parallel_workers=128
slave_parallel_type=LOGICAL_CLOCK
slave_preserve_commit_order=on
performance_schema=OFF
[mysqldump]
quick
net_buffer_length=16K