forked from seokjeongeum/OpAdviserPrivate
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmysql.cnf
233 lines (232 loc) · 7.06 KB
/
mysql.cnf
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
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
#pid-file = /home/hong.wu/local/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3308
#basedir = /home/hong.wu/local/
datadir = /var/lib/mysql
tmpdir = /tmp
# secure_file_priv =
# skip-external-locking
# skip-grant-tables
# performance_schema
#show_compatibility_56 = ON
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
sql_mode = NO_ENGINE_SUBSTITUTION
log_error = /var/log/mysql/error.log
log_error_verbosity = 3
slow_query_log_file = /var/log/mysql/base/mysql-slow.log
log_bin = /var/lib/mysql/mysql-bin.log
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
myisam-recover-options = BACKUP
max_connections = 83041
binlog-format = ROW
server_id = 406590050
innodb_log_checksums = OFF
expire_logs_days = 50
innodb_force_load_corrupted = OFF
autocommit = OFF
automatic_sp_privileges = OFF
back_log = 6134
binlog_cache_size = 4248366562
binlog_direct_non_transactional_updates = ON
binlog_error_action = ABORT_SERVER
binlog_format = STATEMENT
binlog_group_commit_sync_delay = 482873
binlog_group_commit_sync_no_delay_count = 24513
binlog_order_commits = ON
binlog_row_image = full
binlog_rows_query_log_events = OFF
binlog_stmt_cache_size = 3116844304
bulk_insert_buffer_size = 58063934
check_proxy_users = ON
completion_type = NO_CHAIN
concurrent_insert = NEVER
connect_timeout = 15878240
default_week_format = 4
delay_key_write = OFF
div_precision_increment = 14
end_markers_in_json = ON
eq_range_index_dive_limit = 2901949956
explicit_defaults_for_timestamp = ON
flush = ON
flush_time = 2
ft_min_word_len = 6
ft_query_expansion_limit = 263
general_log = ON
group_concat_max_len = 11020416240598054000
host_cache_size = 16876
innodb_adaptive_flushing = OFF
innodb_adaptive_flushing_lwm = 20
innodb_adaptive_hash_index_parts = 351
innodb_adaptive_max_sleep_delay = 891265
innodb_api_bk_commit_interval = 699211737
innodb_api_disable_rowlock = OFF
innodb_api_enable_binlog = OFF
innodb_api_enable_mdl = OFF
innodb_autoextend_increment = 495
innodb_buffer_pool_size = 12643227156
innodb_change_buffer_max_size = 19
innodb_change_buffering = inserts
innodb_cmp_per_index_enabled = ON
innodb_commit_concurrency = 528
innodb_compression_failure_threshold_pct = 28
innodb_compression_level = 0
innodb_compression_pad_pct_max = 55
innodb_concurrency_tickets = 812025084
innodb_deadlock_detect = OFF
innodb_default_row_format = REDUNDANT
innodb_disable_sort_file_cache = OFF
innodb_doublewrite = OFF
innodb_file_per_table = OFF
innodb_fill_factor = 24
innodb_flush_log_at_timeout = 1029
innodb_flush_log_at_trx_commit = 0
innodb_flush_neighbors = 2
innodb_flush_sync = OFF
innodb_flushing_avg_loops = 709
innodb_ft_cache_size = 54250929
innodb_ft_enable_diag_print = OFF
innodb_ft_enable_stopword = ON
innodb_ft_max_token_size = 83
innodb_ft_min_token_size = 15
innodb_ft_num_word_optimize = 5298
innodb_ft_result_cache_limit = 636117708
innodb_ft_sort_pll_degree = 12
innodb_ft_total_cache_size = 167648341
innodb_io_capacity = 518308
innodb_io_capacity_max = 30532
innodb_log_buffer_size = 4031971854
innodb_log_compressed_pages = OFF
innodb_log_file_size = 49410511
innodb_log_files_in_group = 4
innodb_log_write_ahead_size = 9063
innodb_lru_scan_depth = 5035
innodb_max_dirty_pages_pct = 37
innodb_max_dirty_pages_pct_lwm = 85
innodb_max_purge_lag = 1947250176
innodb_max_purge_lag_delay = 3032887
innodb_max_undo_log_size = 7531676102000380000
innodb_old_blocks_time = 1934428406
innodb_online_alter_log_max_size = 12182191134785970000
innodb_open_files = 452269
innodb_optimize_fulltext_only = OFF
innodb_page_cleaners = 7
innodb_print_all_deadlocks = ON
innodb_purge_batch_size = 1717
innodb_purge_rseg_truncate_frequency = 78
innodb_purge_threads = 20
innodb_random_read_ahead = ON
innodb_read_ahead_threshold = 43
innodb_read_io_threads = 23
innodb_replication_delay = 6034
innodb_rollback_on_timeout = ON
innodb_rollback_segments = 32
innodb_sort_buffer_size = 30150518
innodb_spin_wait_delay = 5991
innodb_stats_auto_recalc = ON
innodb_stats_include_delete_marked = ON
innodb_stats_method = nulls_unequal
innodb_stats_on_metadata = OFF
innodb_stats_persistent = ON
innodb_stats_transient_sample_pages = 26
innodb_strict_mode = ON
innodb_sync_array_size = 61
innodb_sync_spin_loops = 10631
innodb_table_locks = OFF
innodb_thread_concurrency = 62
innodb_thread_sleep_delay = 745182
innodb_undo_log_truncate = OFF
innodb_use_native_aio = OFF
innodb_write_io_threads = 37
join_buffer_size = 438563144
keep_files_on_create = OFF
key_buffer_size = 15071244637
key_cache_age_threshold = 13421
key_cache_block_size = 7216
key_cache_division_limit = 63
local_infile = OFF
log_bin_trust_function_creators = ON
log_bin_use_v1_row_events = OFF
log_builtin_as_identified_by_password = OFF
log_output = FILE
log_queries_not_using_indexes = OFF
log_slave_updates = OFF
log_slow_admin_statements = OFF
log_statements_unsafe_for_binlog = ON
log_syslog_include_pid = ON
log_timestamps = UTC
long_query_time = 9
low_priority_updates = OFF
lower_case_table_names = 1
master_verify_checksum = ON
max_allowed_packet = 138341239
max_binlog_cache_size = 10902329232065240000
max_binlog_size = 918835750
max_binlog_stmt_cache_size = 1218577517688881000
max_delayed_threads = 16120
max_digest_length = 328397
max_error_count = 13375
max_heap_table_size = 280545190
max_join_size = 1871859804678606000
max_length_for_sort_data = 5875867
max_points_in_geometry = 1040789
max_prepared_stmt_count = 340722
max_seeks_for_key = 17607316451069684000
max_sort_length = 1567603
max_user_connections = 1562267644
max_write_lock_count = 17542426821385390000
multi_range_count = 90208154
mysql_native_password_proxy_users = ON
net_buffer_length = 609053
net_read_timeout = 14
net_write_timeout = 53
ngram_token_size = 7
offline_mode = OFF
old_alter_table = OFF
old_passwords = 0
open_files_limit = 650023
optimizer_prune_level = 0
optimizer_search_depth = 59
preload_buffer_size = 447327634
query_alloc_block_size = 20758440
query_cache_limit = 117201629
query_cache_min_res_unit = 48195
query_cache_size = 1626770551
query_cache_wlock_invalidate = ON
query_prealloc_size = 51315147
range_alloc_block_size = 9238
read_buffer_size = 1744011491
read_rnd_buffer_size = 96616055
require_secure_transport = OFF
session_track_gtids = OWN_GTID
session_track_schema = OFF
session_track_state_change = OFF
session_track_transaction_info = STATE
show_compatibility_56 = OFF
skip_external_locking = OFF
skip_name_resolve = ON
skip_networking = OFF
slow_query_log = OFF
sort_buffer_size = 28423952
stored_program_cache = 164887
sync_binlog = 281159918
sync_frm = ON
table_definition_cache = 174966
table_open_cache = 60539
table_open_cache_instances = 52
thread_cache_size = 6914
tmp_table_size = 848669808
transaction_alloc_block_size = 88968
transaction_prealloc_size = 10891
updatable_views_with_limit = YES