forked from seokjeongeum/OpAdviserPrivate
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmysql.cnf
233 lines (232 loc) · 7.03 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 = 23272
binlog-format = ROW
server_id = 406590050
innodb_log_checksums = OFF
expire_logs_days = 41
innodb_force_load_corrupted = OFF
autocommit = ON
automatic_sp_privileges = OFF
back_log = 63884
binlog_cache_size = 2970152244
binlog_direct_non_transactional_updates = ON
binlog_error_action = ABORT_SERVER
binlog_format = ROW
binlog_group_commit_sync_delay = 680228
binlog_group_commit_sync_no_delay_count = 24344
binlog_order_commits = ON
binlog_row_image = full
binlog_rows_query_log_events = OFF
binlog_stmt_cache_size = 1797015791
bulk_insert_buffer_size = 17077384
check_proxy_users = ON
completion_type = CHAIN
concurrent_insert = NEVER
connect_timeout = 31536000
default_week_format = 2
delay_key_write = ON
div_precision_increment = 29
end_markers_in_json = ON
eq_range_index_dive_limit = 4291366655
explicit_defaults_for_timestamp = ON
flush = OFF
flush_time = 1
ft_min_word_len = 8
ft_query_expansion_limit = 157
general_log = OFF
group_concat_max_len = 6844440749148071000
host_cache_size = 64727
innodb_adaptive_flushing = OFF
innodb_adaptive_flushing_lwm = 38
innodb_adaptive_hash_index_parts = 264
innodb_adaptive_max_sleep_delay = 792281
innodb_api_bk_commit_interval = 31562046
innodb_api_disable_rowlock = OFF
innodb_api_enable_binlog = OFF
innodb_api_enable_mdl = OFF
innodb_autoextend_increment = 799
innodb_buffer_pool_size = 11172201170
innodb_change_buffer_max_size = 21
innodb_change_buffering = changes
innodb_cmp_per_index_enabled = ON
innodb_commit_concurrency = 31
innodb_compression_failure_threshold_pct = 39
innodb_compression_level = 8
innodb_compression_pad_pct_max = 73
innodb_concurrency_tickets = 380072403
innodb_deadlock_detect = OFF
innodb_default_row_format = REDUNDANT
innodb_disable_sort_file_cache = ON
innodb_doublewrite = ON
innodb_file_per_table = OFF
innodb_fill_factor = 51
innodb_flush_log_at_timeout = 1343
innodb_flush_log_at_trx_commit = 2
innodb_flush_neighbors = 2
innodb_flush_sync = ON
innodb_flushing_avg_loops = 994
innodb_ft_cache_size = 63791347
innodb_ft_enable_diag_print = OFF
innodb_ft_enable_stopword = ON
innodb_ft_max_token_size = 69
innodb_ft_min_token_size = 5
innodb_ft_num_word_optimize = 8497
innodb_ft_result_cache_limit = 3590748345
innodb_ft_sort_pll_degree = 14
innodb_ft_total_cache_size = 848668120
innodb_io_capacity = 985941
innodb_io_capacity_max = 23415
innodb_log_buffer_size = 1740949875
innodb_log_compressed_pages = OFF
innodb_log_file_size = 586103299
innodb_log_files_in_group = 9
innodb_log_write_ahead_size = 16297
innodb_lru_scan_depth = 9950
innodb_max_dirty_pages_pct = 18
innodb_max_dirty_pages_pct_lwm = 86
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 = 11645946860863850000
innodb_open_files = 290437
innodb_optimize_fulltext_only = OFF
innodb_page_cleaners = 2
innodb_print_all_deadlocks = ON
innodb_purge_batch_size = 2575
innodb_purge_rseg_truncate_frequency = 44
innodb_purge_threads = 26
innodb_random_read_ahead = ON
innodb_read_ahead_threshold = 47
innodb_read_io_threads = 18
innodb_replication_delay = 643
innodb_rollback_on_timeout = ON
innodb_rollback_segments = 57
innodb_sort_buffer_size = 26720087
innodb_spin_wait_delay = 3547
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 = 44
innodb_strict_mode = ON
innodb_sync_array_size = 377
innodb_sync_spin_loops = 4848
innodb_table_locks = OFF
innodb_thread_concurrency = 665
innodb_thread_sleep_delay = 914688
innodb_undo_log_truncate = OFF
innodb_use_native_aio = OFF
innodb_write_io_threads = 8
join_buffer_size = 805085087
keep_files_on_create = OFF
key_buffer_size = 16654376884
key_cache_age_threshold = 8311
key_cache_block_size = 1695
key_cache_division_limit = 66
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 = NONE
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 = 7
low_priority_updates = OFF
lower_case_table_names = 1
master_verify_checksum = ON
max_allowed_packet = 457202380
max_binlog_cache_size = 12752309837013100000
max_binlog_size = 318298751
max_binlog_stmt_cache_size = 6216611347655110000
max_delayed_threads = 40
max_digest_length = 457551
max_error_count = 23802
max_heap_table_size = 953679344
max_join_size = 12667240473797614000
max_length_for_sort_data = 1406095
max_points_in_geometry = 499766
max_prepared_stmt_count = 495995
max_seeks_for_key = 14953647309311706000
max_sort_length = 4444276
max_user_connections = 3587044230
max_write_lock_count = 259726886228365000
multi_range_count = 2514077852
mysql_native_password_proxy_users = ON
net_buffer_length = 910584
net_read_timeout = 60
net_write_timeout = 120
ngram_token_size = 8
offline_mode = OFF
old_alter_table = OFF
old_passwords = 0
open_files_limit = 80589
optimizer_prune_level = 0
optimizer_search_depth = 3
preload_buffer_size = 687198322
query_alloc_block_size = 30159675
query_cache_limit = 10143545
query_cache_min_res_unit = 6270
query_cache_size = 427010811
query_cache_wlock_invalidate = ON
query_prealloc_size = 57463787
range_alloc_block_size = 52645
read_buffer_size = 1579948139
read_rnd_buffer_size = 99397
require_secure_transport = OFF
session_track_gtids = OWN_GTID
session_track_schema = ON
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 = 35436278
stored_program_cache = 119506
sync_binlog = 3728127231
sync_frm = ON
table_definition_cache = 88956
table_open_cache = 65170
table_open_cache_instances = 59
thread_cache_size = 8548
tmp_table_size = 591007541
transaction_alloc_block_size = 124261
transaction_prealloc_size = 73214
updatable_views_with_limit = YES