forked from seokjeongeum/OpAdviserPrivate
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmysql.cnf
233 lines (232 loc) · 7.01 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 = 3307
#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 = 54829
binlog-format = ROW
server_id = 406590050
innodb_log_checksums = OFF
expire_logs_days = 30
innodb_force_load_corrupted = OFF
autocommit = ON
automatic_sp_privileges = OFF
back_log = 35419
binlog_cache_size = 3728291142
binlog_direct_non_transactional_updates = ON
binlog_error_action = ABORT_SERVER
binlog_format = MIXED
binlog_group_commit_sync_delay = 886606
binlog_group_commit_sync_no_delay_count = 24344
binlog_order_commits = ON
binlog_row_image = minimal
binlog_rows_query_log_events = OFF
binlog_stmt_cache_size = 2561798502
bulk_insert_buffer_size = 11964873
check_proxy_users = ON
completion_type = CHAIN
concurrent_insert = ALWAYS
connect_timeout = 15896656
default_week_format = 0
delay_key_write = ALL
div_precision_increment = 5
end_markers_in_json = ON
eq_range_index_dive_limit = 1992705223
explicit_defaults_for_timestamp = OFF
flush = OFF
flush_time = 2
ft_min_word_len = 8
ft_query_expansion_limit = 157
general_log = ON
group_concat_max_len = 13945575555338124000
host_cache_size = 21618
innodb_adaptive_flushing = ON
innodb_adaptive_flushing_lwm = 62
innodb_adaptive_hash_index_parts = 275
innodb_adaptive_max_sleep_delay = 698600
innodb_api_bk_commit_interval = 194051809
innodb_api_disable_rowlock = ON
innodb_api_enable_binlog = ON
innodb_api_enable_mdl = OFF
innodb_autoextend_increment = 799
innodb_buffer_pool_size = 24414462260
innodb_change_buffer_max_size = 33
innodb_change_buffering = purges
innodb_cmp_per_index_enabled = ON
innodb_commit_concurrency = 780
innodb_compression_failure_threshold_pct = 19
innodb_compression_level = 8
innodb_compression_pad_pct_max = 11
innodb_concurrency_tickets = 2717897490
innodb_deadlock_detect = ON
innodb_default_row_format = REDUNDANT
innodb_disable_sort_file_cache = OFF
innodb_doublewrite = ON
innodb_file_per_table = ON
innodb_fill_factor = 51
innodb_flush_log_at_timeout = 2019
innodb_flush_log_at_trx_commit = 2
innodb_flush_neighbors = 1
innodb_flush_sync = OFF
innodb_flushing_avg_loops = 503
innodb_ft_cache_size = 6316544
innodb_ft_enable_diag_print = OFF
innodb_ft_enable_stopword = ON
innodb_ft_max_token_size = 69
innodb_ft_min_token_size = 10
innodb_ft_num_word_optimize = 8497
innodb_ft_result_cache_limit = 2651578607
innodb_ft_sort_pll_degree = 14
innodb_ft_total_cache_size = 167797613
innodb_io_capacity = 985941
innodb_io_capacity_max = 3457
innodb_log_buffer_size = 2272803164
innodb_log_compressed_pages = OFF
innodb_log_file_size = 177063894
innodb_log_files_in_group = 4
innodb_log_write_ahead_size = 11527
innodb_lru_scan_depth = 4036
innodb_max_dirty_pages_pct = 78
innodb_max_dirty_pages_pct_lwm = 49
innodb_max_purge_lag = 692122882
innodb_max_purge_lag_delay = 488133
innodb_max_undo_log_size = 5894479204258101000
innodb_old_blocks_time = 3518277917
innodb_online_alter_log_max_size = 7878058916119274000
innodb_open_files = 290437
innodb_optimize_fulltext_only = OFF
innodb_page_cleaners = 4
innodb_print_all_deadlocks = ON
innodb_purge_batch_size = 901
innodb_purge_rseg_truncate_frequency = 120
innodb_purge_threads = 31
innodb_random_read_ahead = OFF
innodb_read_ahead_threshold = 39
innodb_read_io_threads = 16
innodb_replication_delay = 643
innodb_rollback_on_timeout = ON
innodb_rollback_segments = 57
innodb_sort_buffer_size = 56932849
innodb_spin_wait_delay = 0
innodb_stats_auto_recalc = ON
innodb_stats_include_delete_marked = OFF
innodb_stats_method = nulls_ignored
innodb_stats_on_metadata = ON
innodb_stats_persistent = OFF
innodb_stats_transient_sample_pages = 47
innodb_strict_mode = OFF
innodb_sync_array_size = 921
innodb_sync_spin_loops = 19089
innodb_table_locks = OFF
innodb_thread_concurrency = 0
innodb_thread_sleep_delay = 914688
innodb_undo_log_truncate = OFF
innodb_use_native_aio = ON
innodb_write_io_threads = 8
join_buffer_size = 610670796
keep_files_on_create = ON
key_buffer_size = 13515035299
key_cache_age_threshold = 25296
key_cache_block_size = 3385
key_cache_division_limit = 3
local_infile = ON
log_bin_trust_function_creators = OFF
log_bin_use_v1_row_events = ON
log_builtin_as_identified_by_password = OFF
log_output = TABLE
log_queries_not_using_indexes = ON
log_slave_updates = OFF
log_slow_admin_statements = ON
log_statements_unsafe_for_binlog = OFF
log_syslog_include_pid = OFF
log_timestamps = UTC
long_query_time = 17
low_priority_updates = OFF
lower_case_table_names = 1
master_verify_checksum = OFF
max_allowed_packet = 344510987
max_binlog_cache_size = 8952337146455962000
max_binlog_size = 210602481
max_binlog_stmt_cache_size = 3238748910290804000
max_delayed_threads = 6615
max_digest_length = 24668
max_error_count = 43973
max_heap_table_size = 16384
max_join_size = 6418369892242567000
max_length_for_sort_data = 3768691
max_points_in_geometry = 259612
max_prepared_stmt_count = 86399
max_seeks_for_key = 5001948153671916000
max_sort_length = 5785675
max_user_connections = 954334623
max_write_lock_count = 9328800112987148000
multi_range_count = 814364726
mysql_native_password_proxy_users = ON
net_buffer_length = 668719
net_read_timeout = 25
net_write_timeout = 70
ngram_token_size = 8
offline_mode = OFF
old_alter_table = ON
old_passwords = 2
open_files_limit = 584805
optimizer_prune_level = 1
optimizer_search_depth = 30
preload_buffer_size = 1002778583
query_alloc_block_size = 95090052
query_cache_limit = 82234396
query_cache_min_res_unit = 42308
query_cache_size = 1175438721
query_cache_wlock_invalidate = OFF
query_prealloc_size = 8192
range_alloc_block_size = 47858
read_buffer_size = 318020633
read_rnd_buffer_size = 133914462
require_secure_transport = ON
session_track_gtids = OFF
session_track_schema = ON
session_track_state_change = OFF
session_track_transaction_info = STATE
show_compatibility_56 = ON
skip_external_locking = OFF
skip_name_resolve = ON
skip_networking = OFF
slow_query_log = OFF
sort_buffer_size = 32768
stored_program_cache = 119506
sync_binlog = 2908906895
sync_frm = ON
table_definition_cache = 29504
table_open_cache = 65170
table_open_cache_instances = 3
thread_cache_size = 7013
tmp_table_size = 1024
transaction_alloc_block_size = 79425
transaction_prealloc_size = 69588
updatable_views_with_limit = NO