-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathmy.cnf_base_for_test
120 lines (103 loc) · 2.63 KB
/
my.cnf_base_for_test
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
[mysqld]
port=3306
server_id=1
report_host=127.0.0.1
default_authentication_plugin=mysql_native_password
pid-file = /xxx/data/mysqld.pid
socket = /xxx/data/mysqld.sock
datadir = /xxx/data
log-error = /xxx/data/error.log
log-bin = /xxx/data/server-binary-log
relay-log = /xxx/data/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=100000
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
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_expire_logs_seconds=3600
binlog_order_commits=OFF
binlog_row_image=MINIMAL
innodb_log_file_size=8G
innodb_log_files_in_group=4
transaction_isolation=READ-COMMITTED
innodb_buffer_pool_size=92G
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=8
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_compression_level=6
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
slave_parallel_workers=1
slave_parallel_type=LOGICAL_CLOCK
slave_preserve_commit_order=on
performance_schema=OFF
[mysqldump]
quick
net_buffer_length=16K