Top Diff Variable_name (MariaDB 10.1) gcp-prod-oos-sql-0001-mariadb-g01-001 (MariaDB 10.7.7)
|
1 1 alter_algorithm N/A DEFAULT
|
2 2 analyze_sample_percentage N/A 100.000000
|
3 2 aria_block_size 8 Ko 8 Ko
|
4 2 aria_checkpoint_interval 30 30
|
5 2 aria_checkpoint_log_activity 1048576 1048576
|
6 2 aria_encrypt_tables OFF OFF
|
7 2 aria_force_start_after_recovery_failures 0 0
|
8 2 aria_group_commit none none
|
9 2 aria_group_commit_interval 0 0
|
10 2 aria_log_file_size 1 Go 1 Go
|
11 2 aria_log_purge_type immediate immediate
|
12 2 aria_max_sort_file_size 8 Eo 8 Eo
|
13 2 aria_page_checksum ON ON
|
14 2 aria_pagecache_age_threshold 300 300
|
15 2 aria_pagecache_buffer_size 128 Mo 128 Mo
|
16 2 aria_pagecache_division_limit 100 100
|
17 2 aria_pagecache_file_hash_size 512 512
|
18 3 aria_recover_options N/A BACKUP,QUICK
|
19 3 aria_repair_threads 1 1
|
20 3 aria_sort_buffer_size 256 Mo 256 Mo
|
21 3 aria_stats_method nulls_unequal nulls_unequal
|
22 3 aria_sync_log_dir NEWFILE NEWFILE
|
23 3 aria_used_for_temp_tables ON ON
|
24 4 auto_increment_increment 2 1
|
25 5 auto_increment_offset 2 1
|
26 5 autocommit ON ON
|
27 5 automatic_sp_privileges ON ON
|
28 6 back_log 869 250
|
29 7 basedir /usr/ /usr
|
30 7 big_tables OFF OFF
|
31 8 bind_address N/A 0.0.0.0
|
32 9 binlog_annotate_row_events OFF ON
|
33 9 binlog_cache_size 32 Ko 32 Ko
|
34 10 binlog_checksum NONE CRC32
|
35 10 binlog_commit_wait_count 0 0
|
36 10 binlog_commit_wait_usec 100000 100000
|
37 10 binlog_direct_non_transactional_updates OFF OFF
|
38 11 binlog_expire_logs_seconds N/A 864000
|
39 12 binlog_file_cache_size N/A 16 Ko
|
40 12 binlog_format ROW ROW
|
41 12 binlog_optimize_thread_scheduling ON ON
|
42 12 binlog_row_image FULL FULL
|
43 13 binlog_row_metadata N/A NO_LOG
|
44 13 binlog_stmt_cache_size 32 Ko 32 Ko
|
45 14 bulk_insert_buffer_size 8 Mo 16 Mo
|
46 15 character_set_client latin1 utf8mb4
|
47 16 character_set_connection latin1 utf8mb4
|
48 17 character_set_database latin1 utf8mb4
|
49 17 character_set_filesystem binary binary
|
50 18 character_set_results latin1 utf8mb4
|
51 19 character_set_server latin1 utf8mb4
|
52 20 character_set_system utf8 utf8mb3
|
53 20 character_sets_dir /usr/share/mysql/charsets/ /usr/share/mysql/charsets/
|
54 21 check_constraint_checks N/A ON
|
55 22 collation_connection latin1_swedish_ci utf8mb4_general_ci
|
56 23 collation_database latin1_swedish_ci utf8mb4_general_ci
|
57 24 collation_server latin1_swedish_ci utf8mb4_general_ci
|
58 25 column_compression_threshold N/A 100
|
59 26 column_compression_zlib_level N/A 6
|
60 27 column_compression_zlib_strategy N/A DEFAULT_STRATEGY
|
61 28 column_compression_zlib_wrap N/A OFF
|
62 28 completion_type NO_CHAIN NO_CHAIN
|
63 29 concurrent_insert AUTO ALWAYS
|
64 29 connect_timeout 10 10
|
65 29 core_file OFF OFF
|
66 29 datadir /srv/mysql/data/ /srv/mysql/data/
|
67 29 date_format %Y-%m-%d %Y-%m-%d
|
68 29 datetime_format %Y-%m-%d %H:%i:%s %Y-%m-%d %H:%i:%s
|
69 29 deadlock_search_depth_long 15 15
|
70 29 deadlock_search_depth_short 4 4
|
71 29 deadlock_timeout_long 50000000 50000000
|
72 29 deadlock_timeout_short 10000 10000
|
73 29 debug_no_thread_alarm OFF OFF
|
74 30 default_password_lifetime N/A 0
|
75 30 default_regex_flags
|
76 30 default_storage_engine InnoDB InnoDB
|
77 30 default_tmp_storage_engine
|
78 30 default_week_format 0 0
|
79 30 delay_key_write ON ON
|
80 30 delayed_insert_limit 100 100
|
81 30 delayed_insert_timeout 300 300
|
82 30 delayed_queue_size 1000 1000
|
83 31 disconnect_on_expired_password N/A OFF
|
84 31 div_precision_increment 4 4
|
85 31 encrypt_binlog OFF OFF
|
86 31 encrypt_tmp_disk_tables OFF OFF
|
87 31 encrypt_tmp_files OFF OFF
|
88 31 enforce_storage_engine
|
89 32 eq_range_index_dive_limit N/A 200
|
90 32 event_scheduler OFF OFF
|
91 32 expensive_subquery_limit 100 100
|
92 33 expire_logs_days 7 10.000000
|
93 33 explicit_defaults_for_timestamp OFF OFF
|
94 33 extra_max_connections 1 1
|
95 33 extra_port 0 0
|
96 33 flush OFF OFF
|
97 33 flush_time 0 0
|
98 33 foreign_key_checks ON ON
|
99 33 ft_boolean_syntax + -><()~*:""&| + -><()~*:""&|
|
100 33 ft_max_word_len 84 84
|
101 33 ft_min_word_len 4 4
|
102 33 ft_query_expansion_limit 20 20
|
103 33 ft_stopword_file (built-in) (built-in)
|
104 33 general_log OFF OFF
|
105 34 general_log_file pc-db11-1.log /srv/mysql/log/general.log
|
106 35 group_concat_max_len 1024 1048576
|
107 36 gtid_binlog_pos 111-111-8021169341,112-112-410468766 0-4255000500-28754522,111-111-8021162042
|
108 37 gtid_binlog_state 111-111-8021169341,112-112-410468766 0-4255000500-28754522,111-111-8021162042
|
109 38 gtid_cleanup_batch_size N/A 64
|
110 39 gtid_current_pos 0-111-31146,111-111-8021169341,112-112-410468766 0-4255000500-28754522,111-111-8021169341,112-112-410468766
|
111 40 gtid_domain_id 111 0
|
112 40 gtid_ignore_duplicates OFF OFF
|
113 41 gtid_pos_auto_engines N/A
|
114 42 gtid_slave_pos 0-111-31146,111-111-8021169341,112-112-410468766 111-111-8021169341,112-112-410468766
|
115 42 gtid_strict_mode OFF OFF
|
116 42 have_compress YES YES
|
117 42 have_crypt YES YES
|
118 42 have_dynamic_loading YES YES
|
119 42 have_geometry YES YES
|
120 43 have_openssl NO YES
|
121 43 have_profiling YES YES
|
122 43 have_query_cache YES YES
|
123 43 have_rtree_keys YES YES
|
124 43 have_ssl DISABLED DISABLED
|
125 43 have_symlink YES YES
|
126 44 histogram_size 254
|
127 45 histogram_type SINGLE_PREC_HB DOUBLE_PREC_HB
|
128 46 host_cache_size 807 653
|
129 47 hostname pc-db11-1 gcp-prod-oos-sql-0001-mariadb-g01-001
|
130 48 idle_readonly_transaction_timeout N/A 0
|
131 49 idle_transaction_timeout N/A 0
|
132 50 idle_write_transaction_timeout N/A 0
|
133 50 ignore_builtin_innodb OFF OFF
|
134 50 ignore_db_dirs
|
135 51 in_predicate_conversion_threshold N/A 1000
|
136 51 init_connect
|
137 51 init_file
|
138 51 init_slave
|
139 51 innodb_adaptive_flushing ON ON
|
140 51 innodb_adaptive_flushing_lwm 10.000000 10.000000
|
141 51 innodb_adaptive_hash_index ON ON
|
142 52 innodb_adaptive_hash_index_parts N/A 8
|
143 52 innodb_autoextend_increment 1000 1000
|
144 52 innodb_autoinc_lock_mode 2 2
|
145 52 innodb_buf_dump_status_frequency 0 0
|
146 53 innodb_buffer_pool_chunk_size N/A 128 Mo
|
147 54 innodb_buffer_pool_dump_at_shutdown OFF ON
|
148 54 innodb_buffer_pool_dump_now OFF OFF
|
149 55 innodb_buffer_pool_dump_pct 100 25
|
150 55 innodb_buffer_pool_filename ib_buffer_pool ib_buffer_pool
|
151 55 innodb_buffer_pool_load_abort OFF OFF
|
152 56 innodb_buffer_pool_load_at_startup OFF ON
|
153 56 innodb_buffer_pool_load_now OFF OFF
|
154 57 innodb_buffer_pool_size 800 Go 189 Go
|
155 57 innodb_change_buffer_max_size 25 25
|
156 58 innodb_change_buffering all none
|
157 59 innodb_checksum_algorithm INNODB full_crc32
|
158 59 innodb_cmp_per_index_enabled OFF OFF
|
159 59 innodb_compression_algorithm zlib zlib
|
160 60 innodb_compression_default N/A OFF
|
161 60 innodb_compression_failure_threshold_pct 5 5
|
162 60 innodb_compression_level 6 6
|
163 60 innodb_compression_pad_pct_max 50 50
|
164 61 innodb_data_file_path ibdata1:1G:autoextend ibdata1:12M:autoextend
|
165 62 innodb_data_home_dir /srv/mysql/data
|
166 63 innodb_deadlock_detect N/A ON
|
167 64 innodb_deadlock_report N/A full
|
168 64 innodb_default_encryption_key_id 1 1
|
169 65 innodb_default_row_format compact dynamic
|
170 65 innodb_defragment OFF OFF
|
171 65 innodb_defragment_fill_factor 0.900000 0.900000
|
172 65 innodb_defragment_fill_factor_n_recs 20 20
|
173 65 innodb_defragment_frequency 40 40
|
174 65 innodb_defragment_n_pages 7 7
|
175 65 innodb_defragment_stats_accuracy 0 0
|
176 65 innodb_disable_sort_file_cache OFF OFF
|
177 65 innodb_doublewrite ON ON
|
178 65 innodb_encrypt_log OFF OFF
|
179 65 innodb_encrypt_tables OFF OFF
|
180 66 innodb_encrypt_temporary_tables N/A OFF
|
181 66 innodb_encryption_rotate_key_age 1 1
|
182 66 innodb_encryption_rotation_iops 100 100
|
183 66 innodb_encryption_threads 0 0
|
184 66 innodb_fast_shutdown 1 1
|
185 66 innodb_fatal_semaphore_wait_threshold 600 600
|
186 66 innodb_file_per_table ON ON
|
187 67 innodb_fill_factor N/A 100
|
188 67 innodb_flush_log_at_timeout 1 1
|
189 68 innodb_flush_log_at_trx_commit 1 2
|
190 68 innodb_flush_method O_DIRECT O_DIRECT
|
191 69 innodb_flush_neighbors 0 1
|
192 70 innodb_flush_sync N/A ON
|
193 70 innodb_flushing_avg_loops 30 30
|
194 70 innodb_force_primary_key OFF OFF
|
195 70 innodb_force_recovery 0 0
|
196 70 innodb_ft_aux_table
|
197 70 innodb_ft_cache_size 8 Mo 8 Mo
|
198 70 innodb_ft_enable_diag_print OFF OFF
|
199 70 innodb_ft_enable_stopword ON ON
|
200 70 innodb_ft_max_token_size 84 84
|
201 70 innodb_ft_min_token_size 3 3
|
202 70 innodb_ft_num_word_optimize 2000 2000
|
203 70 innodb_ft_result_cache_limit 2000000000 2000000000
|
204 70 innodb_ft_server_stopword_table
|
205 70 innodb_ft_sort_pll_degree 2 2
|
206 70 innodb_ft_total_cache_size 610 Mo 610 Mo
|
207 70 innodb_ft_user_stopword_table
|
208 70 innodb_immediate_scrub_data_uncompressed OFF OFF
|
209 71 innodb_instant_alter_column_allowed N/A add_drop_reorder
|
210 72 innodb_io_capacity 200 2000
|
211 73 innodb_io_capacity_max 2000 4000
|
212 74 innodb_lock_wait_timeout 10 50
|
213 75 innodb_log_buffer_size 128 Mo 8 Mo
|
214 75 innodb_log_file_size 2 Go 2 Go
|
215 75 innodb_log_group_home_dir ./ ./
|
216 76 innodb_log_write_ahead_size N/A 8 Ko
|
217 77 innodb_lru_flush_size N/A 32
|
218 78 innodb_lru_scan_depth 100 1536
|
219 79 innodb_max_dirty_pages_pct 75.000000 90.000000
|
220 80 innodb_max_dirty_pages_pct_lwm 0.001000 0.000000
|
221 80 innodb_max_purge_lag 0 0
|
222 80 innodb_max_purge_lag_delay 0 0
|
223 81 innodb_max_purge_lag_wait N/A 4294967295
|
224 82 innodb_max_undo_log_size N/A 10 Mo
|
225 82 innodb_monitor_disable
|
226 82 innodb_monitor_enable
|
227 82 innodb_monitor_reset
|
228 82 innodb_monitor_reset_all
|
229 82 innodb_old_blocks_pct 37 37
|
230 82 innodb_old_blocks_time 1000 1000
|
231 82 innodb_online_alter_log_max_size 128 Mo 128 Mo
|
232 83 innodb_open_files 1024 400
|
233 83 innodb_optimize_fulltext_only OFF OFF
|
234 83 innodb_page_size 16 Ko 16 Ko
|
235 83 innodb_prefix_index_cluster_optimization OFF OFF
|
236 83 innodb_print_all_deadlocks OFF OFF
|
237 83 innodb_purge_batch_size 300 300
|
238 84 innodb_purge_rseg_truncate_frequency N/A 128
|
239 85 innodb_purge_threads 1 4
|
240 85 innodb_random_read_ahead OFF OFF
|
241 85 innodb_read_ahead_threshold 56 56
|
242 85 innodb_read_io_threads 4 4
|
243 85 innodb_read_only OFF OFF
|
244 86 innodb_read_only_compressed N/A OFF
|
245 86 innodb_rollback_on_timeout ON ON
|
246 86 innodb_sort_buffer_size 1 Mo 1 Mo
|
247 87 innodb_spin_wait_delay 6 4
|
248 87 innodb_stats_auto_recalc ON ON
|
249 87 innodb_stats_include_delete_marked OFF OFF
|
250 87 innodb_stats_method nulls_equal nulls_equal
|
251 87 innodb_stats_modified_counter 0 0
|
252 87 innodb_stats_on_metadata OFF OFF
|
253 87 innodb_stats_persistent ON ON
|
254 87 innodb_stats_persistent_sample_pages 20 20
|
255 87 innodb_stats_traditional ON ON
|
256 87 innodb_stats_transient_sample_pages 8 8
|
257 87 innodb_status_output OFF OFF
|
258 87 innodb_status_output_locks OFF OFF
|
259 87 innodb_strict_mode OFF OFF
|
260 87 innodb_sync_spin_loops 30 30
|
261 87 innodb_table_locks ON ON
|
262 88 innodb_temp_data_file_path N/A ibtmp1:12M:autoextend
|
263 88 innodb_tmpdir
|
264 89 innodb_undo_directory . ./
|
265 90 innodb_undo_log_truncate N/A OFF
|
266 90 innodb_undo_tablespaces 0 0
|
267 91 innodb_use_atomic_writes OFF ON
|
268 91 innodb_use_native_aio ON ON
|
269 92 innodb_version 5.6.49-89.0 10.7.4
|
270 92 innodb_write_io_threads 4 4
|
271 92 interactive_timeout 28800 28800
|
272 93 join_buffer_size 1 Mo 6 Mo
|
273 93 join_buffer_space_limit 2 Mo 2 Mo
|
274 93 join_cache_level 2 2
|
275 93 keep_files_on_create OFF OFF
|
276 93 key_buffer_size 128 Mo 128 Mo
|
277 93 key_cache_age_threshold 300 300
|
278 93 key_cache_block_size 1 Ko 1 Ko
|
279 93 key_cache_division_limit 100 100
|
280 93 key_cache_file_hash_size 512 512
|
281 94 key_cache_segments 0 64
|
282 94 large_files_support ON ON
|
283 94 large_page_size
|
284 94 large_pages OFF OFF
|
285 94 lc_messages en_US en_US
|
286 95 lc_messages_dir /usr/share/mysql
|
287 95 lc_time_names en_US en_US
|
288 95 license GPL GPL
|
289 95 local_infile ON ON
|
290 96 lock_wait_timeout 31536000 86400
|
291 96 locked_in_memory OFF OFF
|
292 96 log_bin ON ON
|
293 97 log_bin_basename /srv/mysql/binlog/mysql-bin /srv/mysql/binlog/mariadb-bin
|
294 98 log_bin_compress N/A OFF
|
295 99 log_bin_compress_min_len N/A 256
|
296 100 log_bin_index /srv/mysql/binlog/mysql-bin.index /srv/mysql/binlog/mariadb-bin.index
|
297 100 log_bin_trust_function_creators OFF OFF
|
298 101 log_disabled_statements N/A sp
|
299 101 log_error /srv/mysql/log/error.log /srv/mysql/log/error.log
|
300 101 log_output FILE FILE
|
301 101 log_queries_not_using_indexes OFF OFF
|
302 101 log_slave_updates ON ON
|
303 102 log_slow_admin_statements OFF ON
|
304 103 log_slow_disabled_statements N/A sp
|
305 104 log_slow_filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on... admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_mis...
|
306 104 log_slow_rate_limit 1 1
|
307 105 log_slow_slave_statements OFF ON
|
308 106 log_slow_verbosity query_plan
|
309 106 log_tc_size 24 Ko 24 Ko
|
310 107 log_warnings 1 2
|
311 108 long_query_time 2.000000 1.000000
|
312 108 low_priority_updates OFF OFF
|
313 108 lower_case_file_system OFF OFF
|
314 108 lower_case_table_names 0 0
|
315 108 master_verify_checksum OFF OFF
|
316 108 max_allowed_packet 268435456 268435456
|
317 108 max_binlog_cache_size 16 Eo 16 Eo
|
318 108 max_binlog_size 1 Go 1 Go
|
319 108 max_binlog_stmt_cache_size 16 Eo 16 Eo
|
320 109 max_connect_errors 10 100
|
321 110 max_connections 4096 2000
|
322 110 max_delayed_threads 20 20
|
323 110 max_digest_length 1024 1024
|
324 110 max_error_count 64 64
|
325 111 max_heap_table_size 16 Mo 256 Mo
|
326 111 max_insert_delayed_threads 20 20
|
327 111 max_join_size 16 Eo 16 Eo
|
328 111 max_length_for_sort_data 1024 1024
|
329 112 max_password_errors N/A 4294967295
|
330 112 max_prepared_stmt_count 16382 16382
|
331 113 max_recursive_iterations N/A 1000
|
332 113 max_relay_log_size 1 Go 1 Go
|
333 114 max_rowid_filter_size N/A 128 Ko
|
334 114 max_seeks_for_key 4294967295 4294967295
|
335 114 max_session_mem_used 9,22337203685478E+018 9,22337203685478E+018
|
336 114 max_sort_length 1024 1024
|
337 114 max_sp_recursion_depth 0 0
|
338 114 max_statement_time 0.000000 0.000000
|
339 114 max_tmp_tables 32 32
|
340 114 max_user_connections 0 0
|
341 114 max_write_lock_count 4294967295 4294967295
|
342 114 metadata_locks_cache_size 1 Ko 1 Ko
|
343 114 metadata_locks_hash_instances 8 8
|
344 114 min_examined_row_limit 0 0
|
345 115 mrr_buffer_size 256 Ko 6 Mo
|
346 115 myisam_block_size 1 Ko 1 Ko
|
347 115 myisam_data_pointer_size 6 6
|
348 115 myisam_max_sort_file_size 8 Eo 8 Eo
|
349 115 myisam_mmap_size 16 Eo 16 Eo
|
350 116 myisam_recover_options DEFAULT BACKUP
|
351 116 myisam_repair_threads 1 1
|
352 117 myisam_sort_buffer_size 128 Mo 512 Mo
|
353 117 myisam_stats_method NULLS_UNEQUAL NULLS_UNEQUAL
|
354 117 myisam_use_mmap OFF OFF
|
355 117 mysql56_temporal_format ON ON
|
356 117 net_buffer_length 16384 16384
|
357 117 net_read_timeout 30 30
|
358 117 net_retry_count 10 10
|
359 117 net_write_timeout 60 60
|
360 117 old OFF OFF
|
361 118 old_alter_table OFF DEFAULT
|
362 119 old_mode UTF8_IS_UTF8MB3
|
363 119 old_passwords OFF OFF
|
364 120 open_files_limit 16384 7463
|
365 121 optimizer_max_sel_arg_weight N/A 32000
|
366 121 optimizer_prune_level 1 1
|
367 121 optimizer_search_depth 62 62
|
368 121 optimizer_selectivity_sampling_limit 100 100
|
369 121 optimizer_switch__index_merge ON ON
|
370 121 optimizer_switch__index_merge_union ON ON
|
371 121 optimizer_switch__index_merge_sort_union ON ON
|
372 121 optimizer_switch__index_merge_intersection ON ON
|
373 121 optimizer_switch__index_merge_sort_intersection OFF OFF
|
374 121 optimizer_switch__engine_condition_pushdown OFF OFF
|
375 121 optimizer_switch__index_condition_pushdown ON ON
|
376 121 optimizer_switch__derived_merge ON ON
|
377 121 optimizer_switch__derived_with_keys ON ON
|
378 121 optimizer_switch__firstmatch ON ON
|
379 121 optimizer_switch__loosescan ON ON
|
380 121 optimizer_switch__materialization ON ON
|
381 121 optimizer_switch__in_to_exists ON ON
|
382 121 optimizer_switch__semijoin ON ON
|
383 121 optimizer_switch__partial_match_rowid_merge ON ON
|
384 121 optimizer_switch__partial_match_table_scan ON ON
|
385 121 optimizer_switch__subquery_cache ON ON
|
386 121 optimizer_switch__mrr OFF OFF
|
387 121 optimizer_switch__mrr_cost_based OFF OFF
|
388 121 optimizer_switch__mrr_sort_keys OFF OFF
|
389 121 optimizer_switch__outer_join_with_cache ON ON
|
390 121 optimizer_switch__semijoin_with_cache ON ON
|
391 121 optimizer_switch__join_cache_incremental ON ON
|
392 121 optimizer_switch__join_cache_hashed ON ON
|
393 121 optimizer_switch__join_cache_bka ON ON
|
394 122 optimizer_switch__optimize_join_buffer_size OFF ON
|
395 122 optimizer_switch__table_elimination ON ON
|
396 122 optimizer_switch__extended_keys ON ON
|
397 122 optimizer_switch__exists_to_in ON ON
|
398 123 optimizer_switch__orderby_uses_equalities N/A ON
|
399 124 optimizer_switch__condition_pushdown_for_derived N/A ON
|
400 125 optimizer_switch__split_materialized N/A ON
|
401 126 optimizer_switch__condition_pushdown_for_subquery N/A ON
|
402 127 optimizer_switch__rowid_filter N/A ON
|
403 128 optimizer_switch__condition_pushdown_from_having N/A ON
|
404 129 optimizer_trace N/A enabled=off
|
405 130 optimizer_trace_max_mem_size N/A 1 Mo
|
406 131 optimizer_use_condition_selectivity 1 4
|
407 132 performance_schema OFF ON
|
408 132 performance_schema_accounts_size -1 -1
|
409 133 performance_schema_digests_size -1 10000
|
410 134 performance_schema_events_stages_history_long_size -1 10000
|
411 135 performance_schema_events_stages_history_size -1 10
|
412 136 performance_schema_events_statements_history_long_size -1 10000
|
413 137 performance_schema_events_statements_history_size -1 10
|
414 138 performance_schema_events_transactions_history_long_size N/A 10000
|
415 139 performance_schema_events_transactions_history_size N/A 10
|
416 140 performance_schema_events_waits_history_long_size -1 10000
|
417 141 performance_schema_events_waits_history_size -1 10
|
418 141 performance_schema_hosts_size -1 -1
|
419 142 performance_schema_max_cond_classes 80 90
|
420 142 performance_schema_max_cond_instances -1 -1
|
421 142 performance_schema_max_digest_length 1024 1024
|
422 143 performance_schema_max_file_classes 50 80
|
423 143 performance_schema_max_file_handles 32768 32768
|
424 143 performance_schema_max_file_instances -1 -1
|
425 144 performance_schema_max_index_stat N/A -1
|
426 145 performance_schema_max_memory_classes N/A 320
|
427 146 performance_schema_max_metadata_locks N/A -1
|
428 147 performance_schema_max_mutex_classes 200 210
|
429 147 performance_schema_max_mutex_instances -1 -1
|
430 148 performance_schema_max_prepared_statements_instances N/A -1
|
431 149 performance_schema_max_program_instances N/A -1
|
432 150 performance_schema_max_rwlock_classes 40 50
|
433 150 performance_schema_max_rwlock_instances -1 -1
|
434 150 performance_schema_max_socket_classes 10 10
|
435 150 performance_schema_max_socket_instances -1 -1
|
436 151 performance_schema_max_sql_text_length N/A 1024
|
437 152 performance_schema_max_stage_classes 150 160
|
438 153 performance_schema_max_statement_classes 178 221
|
439 154 performance_schema_max_statement_stack N/A 10
|
440 154 performance_schema_max_table_handles -1 -1
|
441 154 performance_schema_max_table_instances -1 -1
|
442 155 performance_schema_max_table_lock_stat N/A -1
|
443 155 performance_schema_max_thread_classes 50 50
|
444 155 performance_schema_max_thread_instances -1 -1
|
445 156 performance_schema_session_connect_attrs_size -1 512
|
446 157 performance_schema_setup_actors_size 100 -1
|
447 158 performance_schema_setup_objects_size 100 -1
|
448 158 performance_schema_users_size -1 -1
|
449 158 pid_file /var/run/mysqld/mysqld.pid /var/run/mysqld/mysqld.pid
|
450 159 plugin_dir /usr/lib/x86_64-linux-gnu/mariadb18/plugin/ /usr/lib/mysql/plugin/
|
451 160 plugin_maturity unknown gamma
|
452 160 port 3306 3306
|
453 160 preload_buffer_size 32 Ko 32 Ko
|
454 160 profiling OFF OFF
|
455 160 profiling_history_size 15 15
|
456 160 progress_report_time 5 5
|
457 160 protocol_version 10 10
|
458 161 proxy_protocol_networks N/A
|
459 161 query_alloc_block_size 16 Ko 16 Ko
|
460 162 query_cache_limit 67108864 131072
|
461 162 query_cache_min_res_unit 4096 4096
|
462 163 query_cache_size 32 Mo
|
463 163 query_cache_strip_comments OFF OFF
|
464 163 query_cache_type OFF OFF
|
465 163 query_cache_wlock_invalidate OFF OFF
|
466 163 query_prealloc_size 24 Ko 24 Ko
|
467 164 query_response_time_flush N/A OFF
|
468 165 query_response_time_range_base N/A 10
|
469 166 query_response_time_stats N/A ON
|
470 166 range_alloc_block_size 4 Ko 4 Ko
|
471 167 read_binlog_speed_limit N/A 0
|
472 167 read_buffer_size 2 Mo 2 Mo
|
473 167 read_only OFF OFF
|
474 168 read_rnd_buffer_size 256 Ko 6 Mo
|
475 169 relay_log /srv/mysql/relaylog/relay-bin.log /srv/mysql/relaylog/relay-bin
|
476 169 relay_log_basename /srv/mysql/relaylog/relay-bin /srv/mysql/relaylog/relay-bin
|
477 169 relay_log_index /srv/mysql/relaylog/relay-bin.index /srv/mysql/relaylog/relay-bin.index
|
478 170 relay_log_info_file relay-log.info /srv/mysql/relaylog/relay-bin.info
|
479 170 relay_log_purge ON ON
|
480 170 relay_log_recovery OFF OFF
|
481 170 relay_log_space_limit 0 0
|
482 171 replicate_annotate_row_events OFF ON
|
483 172 replicate_do_db pc_aggregation
|
484 172 replicate_do_table
|
485 172 replicate_events_marked_for_skip REPLICATE REPLICATE
|
486 172 replicate_ignore_db
|
487 172 replicate_ignore_table
|
488 172 replicate_wild_do_table
|
489 172 replicate_wild_ignore_table
|
490 173 report_host gcp-prod-oos-sql-0001-mariadb-g01-001
|
491 173 report_password
|
492 173 report_port 3306 3306
|
493 173 report_user
|
494 174 require_secure_transport N/A OFF
|
495 174 rowid_merge_buff_size 8 Mo 8 Mo
|
496 175 rpl_semi_sync_master_enabled N/A OFF
|
497 176 rpl_semi_sync_master_timeout N/A 10000
|
498 177 rpl_semi_sync_master_trace_level N/A 32
|
499 178 rpl_semi_sync_master_wait_no_slave N/A ON
|
500 179 rpl_semi_sync_master_wait_point N/A AFTER_COMMIT
|
501 180 rpl_semi_sync_slave_delay_master N/A OFF
|
502 181 rpl_semi_sync_slave_enabled N/A OFF
|
503 182 rpl_semi_sync_slave_kill_conn_timeout N/A 5
|
504 183 rpl_semi_sync_slave_trace_level N/A 32
|
505 183 secure_auth ON ON
|
506 183 secure_file_priv
|
507 184 secure_timestamp N/A NO
|
508 184 server_audit_events CONNECT,QUERY_DDL CONNECT,QUERY_DDL
|
509 184 server_audit_excl_users
|
510 184 server_audit_file_path /srv/mysql/log/audit.log /srv/mysql/log/audit.log
|
511 184 server_audit_file_rotate_now OFF OFF
|
512 184 server_audit_file_rotate_size 977 Ko 977 Ko
|
513 184 server_audit_file_rotations 9 9
|
514 184 server_audit_incl_users
|
515 184 server_audit_logging ON ON
|
516 184 server_audit_mode 0 0
|
517 184 server_audit_output_type file file
|
518 184 server_audit_query_log_limit 1024 1024
|
519 184 server_audit_syslog_facility LOG_USER LOG_USER
|
520 184 server_audit_syslog_ident mysql-server_auditing mysql-server_auditing
|
521 184 server_audit_syslog_info
|
522 184 server_audit_syslog_priority LOG_INFO LOG_INFO
|
523 185 server_id 111 4255000500
|
524 186 session_track_schema N/A ON
|
525 187 session_track_state_change N/A OFF
|
526 188 session_track_system_variables N/A autocommit,character_set_client,character_set_connection,character_set_results,time_zone
|
527 189 session_track_transaction_info N/A OFF
|
528 189 skip_external_locking ON ON
|
529 189 skip_name_resolve ON ON
|
530 189 skip_networking OFF OFF
|
531 189 skip_show_database OFF OFF
|
532 189 slave_compressed_protocol OFF OFF
|
533 189 slave_ddl_exec_mode IDEMPOTENT IDEMPOTENT
|
534 189 slave_domain_parallel_threads 0 0
|
535 189 slave_exec_mode STRICT STRICT
|
536 189 slave_load_tmpdir /srv/mysql/tmp /srv/mysql/tmp
|
537 189 slave_max_allowed_packet 1073741824 1073741824
|
538 190 slave_net_timeout 3600 60
|
539 190 slave_parallel_max_queued 131072 131072
|
540 191 slave_parallel_mode conservative optimistic
|
541 191 slave_parallel_threads 0 0
|
542 192 slave_parallel_workers N/A 0
|
543 192 slave_run_triggers_for_rbr NO NO
|
544 192 slave_skip_errors OFF OFF
|
545 192 slave_sql_verify_checksum ON ON
|
546 192 slave_transaction_retries 10 10
|
547 193 slave_transaction_retry_errors N/A 1158,1159,1160,1161,1205,1213,1429,2013,12701
|
548 194 slave_transaction_retry_interval N/A 0
|
549 194 slave_type_conversions
|
550 194 slow_launch_time 2 2
|
551 194 slow_query_log ON ON
|
552 195 slow_query_log_file /srv/mysql/log/mysql-slow.log /srv/mysql/log/mariadb-slow.log
|
553 195 socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
|
554 196 sort_buffer_size 2 Mo 4 Mo
|
555 196 sql_auto_is_null OFF OFF
|
556 196 sql_big_selects ON ON
|
557 196 sql_buffer_result OFF OFF
|
558 197 sql_if_exists N/A OFF
|
559 197 sql_log_bin ON ON
|
560 197 sql_log_off OFF OFF
|
561 197 sql_mode NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
|
562 197 sql_notes ON ON
|
563 197 sql_quote_show_create ON ON
|
564 197 sql_safe_updates OFF OFF
|
565 197 sql_select_limit 1,84467440737096E+019 1,84467440737096E+019
|
566 197 sql_slave_skip_counter 0 0
|
567 197 sql_warnings OFF OFF
|
568 197 ssl_ca
|
569 197 ssl_capath
|
570 197 ssl_cert
|
571 197 ssl_cipher
|
572 197 ssl_crl
|
573 197 ssl_crlpath
|
574 197 ssl_key
|
575 198 standard_compliant_cte N/A ON
|
576 198 storage_engine InnoDB InnoDB
|
577 198 stored_program_cache 256 256
|
578 198 strict_password_validation ON ON
|
579 198 sync_binlog 0 0
|
580 198 sync_frm ON ON
|
581 198 sync_master_info 10000 10000
|
582 198 sync_relay_log 10000 10000
|
583 198 sync_relay_log_info 10000 10000
|
584 199 system_time_zone CEST UTC
|
585 200 system_versioning_alter_history N/A ERROR
|
586 201 system_versioning_asof N/A DEFAULT
|
587 202 table_definition_cache 1024 400
|
588 203 table_open_cache 1024 400
|
589 204 table_open_cache_instances N/A 8
|
590 205 tcp_keepalive_interval N/A 0
|
591 206 tcp_keepalive_probes N/A 0
|
592 207 tcp_keepalive_time N/A 0
|
593 208 tcp_nodelay N/A ON
|
594 209 thread_cache_size 200 128
|
595 209 thread_handling one-thread-per-connection one-thread-per-connection
|
596 210 thread_pool_dedicated_listener N/A OFF
|
597 211 thread_pool_exact_stats N/A OFF
|
598 211 thread_pool_idle_timeout 60 60
|
599 212 thread_pool_max_threads 1000 65536
|
600 212 thread_pool_oversubscribe 3 3
|
601 213 thread_pool_prio_kickup_timer N/A 1000
|
602 214 thread_pool_priority N/A auto
|
603 214 thread_pool_size 32 32
|
604 214 thread_pool_stall_limit 500 500
|
605 214 thread_stack 299008 299008
|
606 214 time_format %H:%i:%s %H:%i:%s
|
607 215 time_zone utc SYSTEM
|
608 216 tls_version N/A TLSv1.1,TLSv1.2,TLSv1.3
|
609 217 tmp_disk_table_size N/A 16 Eo
|
610 218 tmp_memory_table_size N/A 256 Mo
|
611 219 tmp_table_size 512 Mo 256 Mo
|
612 219 tmpdir /srv/mysql/tmp /srv/mysql/tmp
|
613 219 transaction_alloc_block_size 8 Ko 8 Ko
|
614 219 transaction_prealloc_size 4 Ko 4 Ko
|
615 219 tx_isolation REPEATABLE-READ REPEATABLE-READ
|
616 219 tx_read_only OFF OFF
|
617 219 unique_checks ON ON
|
618 219 updatable_views_with_limit YES YES
|
619 220 use_stat_tables NEVER PREFERABLY_FOR_QUERIES
|
620 221 userstat OFF ON
|
621 222 version 10.1.48-MariaDB-0+deb9u2 10.7.4-MariaDB-1:10.7.4+maria~bullseye-log
|
622 223 version_comment Debian 9.13 mariadb.org binary distribution
|
623 223 version_compile_machine x86_64 x86_64
|
624 223 version_compile_os debian-linux-gnu debian-linux-gnu
|
625 224 version_malloc_library system jemalloc system
|
626 225 version_source_revision N/A 99a433ed1cc2cebad93d6ece2b65691f2f49d3ea
|
627 226 version_ssl_library YaSSL 2.4.4 OpenSSL 1.1.1n 15 Mar 2022
|
628 226 wait_timeout 18000 18000
|
629 226 wsrep_osu_method TOI TOI
|
630 227 wsrep_sr_store N/A table
|
631 227 wsrep_auto_increment_control ON ON
|
632 227 wsrep_causal_reads OFF OFF
|
633 227 wsrep_certification_rules strict strict
|
634 227 wsrep_certify_nonpk ON ON
|
635 228 wsrep_cluster_address gcomm://
|
636 229 wsrep_cluster_name my_wsrep_cluster 68Koncept
|
637 229 wsrep_convert_lock_to_trx OFF OFF
|
638 229 wsrep_data_home_dir /srv/mysql/data/ /srv/mysql/data/
|
639 229 wsrep_dbug_option
|
640 230 wsrep_debug OFF NONE
|
641 230 wsrep_desync OFF OFF
|
642 230 wsrep_dirty_reads OFF OFF
|
643 230 wsrep_drupal_282555_workaround OFF OFF
|
644 230 wsrep_forced_binlog_format NONE NONE
|
645 230 wsrep_gtid_domain_id 0 0
|
646 231 wsrep_gtid_mode OFF ON
|
647 232 wsrep_ignore_apply_errors N/A 7
|
648 233 wsrep_load_data_splitting ON OFF
|
649 234 wsrep_log_conflicts OFF ON
|
650 235 wsrep_max_ws_rows 0 131072
|
651 236 wsrep_max_ws_size 2 Go 1 Go
|
652 237 wsrep_mode N/A
|
653 237 wsrep_mysql_replication_bundle 0 0
|
654 238 wsrep_node_address 10.122.5.14
|
655 238 wsrep_node_incoming_address AUTO AUTO
|
656 239 wsrep_node_name pc-db11-1 gcp-prod-oos-sql-0001-mariadb-g01-001
|
657 239 wsrep_notify_cmd
|
658 239 wsrep_on OFF OFF
|
659 240 wsrep_patch_version wsrep_25.24 wsrep_26.22
|
660 241 wsrep_provider none /usr/lib/galera/libgalera_smm.so
|
661 241 wsrep_recover OFF OFF
|
662 241 wsrep_reject_queries NONE NONE
|
663 241 wsrep_restart_slave OFF OFF
|
664 241 wsrep_retry_autocommit 1 1
|
665 241 wsrep_slave_fk_checks ON ON
|
666 241 wsrep_slave_uk_checks OFF OFF
|
667 242 wsrep_slave_threads 1 4
|
668 243 wsrep_sst_auth sst:QSEDWGRg133
|
669 243 wsrep_sst_donor
|
670 243 wsrep_sst_donor_rejects_queries OFF OFF
|
671 244 wsrep_sst_method rsync xtrabackup-v2
|
672 244 wsrep_sst_receive_address AUTO AUTO
|
673 244 wsrep_start_position 00000000-0000-0000-0000-000000000000:-1 00000000-0000-0000-0000-000000000000:-1
|
674 244 wsrep_sync_wait 0 0
|
675 245 wsrep_trx_fragment_size N/A
|
676 246 wsrep_trx_fragment_unit N/A bytes
|
677 247 aria_recover NORMAL N/A
|
678 248 innodb_adaptive_hash_index_partitions 13 N/A
|
679 249 innodb_adaptive_max_sleep_delay 150000 N/A
|
680 250 innodb_additional_mem_pool_size 256 Mo N/A
|
681 251 innodb_api_bk_commit_interval 5 N/A
|
682 252 innodb_api_disable_rowlock OFF N/A
|
683 253 innodb_api_enable_binlog OFF N/A
|
684 254 innodb_api_enable_mdl OFF N/A
|
685 255 innodb_api_trx_level 0 N/A
|
686 256 innodb_background_scrub_data_check_interval 3600 N/A
|
687 257 innodb_background_scrub_data_compressed OFF N/A
|
688 258 innodb_background_scrub_data_interval 604800 N/A
|
689 259 innodb_background_scrub_data_uncompressed OFF N/A
|
690 260 innodb_buffer_pool_instances 64 N/A
|
691 261 innodb_buffer_pool_populate OFF N/A
|
692 262 innodb_checksums ON N/A
|
693 263 innodb_cleaner_lsn_age_factor HIGH_CHECKPOINT N/A
|
694 264 innodb_commit_concurrency 0 N/A
|
695 265 innodb_concurrency_tickets 5000 N/A
|
696 266 innodb_corrupt_table_action assert N/A
|
697 267 innodb_disallow_writes OFF N/A
|
698 268 innodb_empty_free_list_algorithm BACKOFF N/A
|
699 269 innodb_fake_changes OFF N/A
|
700 270 innodb_file_format Barracuda N/A
|
701 271 innodb_file_format_check ON N/A
|
702 272 innodb_file_format_max Barracuda N/A
|
703 273 innodb_force_load_corrupted OFF N/A
|
704 274 innodb_foreground_preflush EXPONENTIAL_BACKOFF N/A
|
705 275 innodb_idle_flush_pct 100 N/A
|
706 276 innodb_instrument_semaphores OFF N/A
|
707 277 innodb_kill_idle_transaction 0 N/A
|
708 278 innodb_large_prefix OFF N/A
|
709 279 innodb_lock_schedule_algorithm fcfs N/A
|
710 280 innodb_locking_fake_changes ON N/A
|
711 281 innodb_locks_unsafe_for_binlog OFF N/A
|
712 282 innodb_log_arch_dir ./ N/A
|
713 283 innodb_log_arch_expire_sec 0 N/A
|
714 284 innodb_log_archive OFF N/A
|
715 285 innodb_log_block_size 512 N/A
|
716 286 innodb_log_checksum_algorithm INNODB N/A
|
717 287 innodb_log_compressed_pages ON N/A
|
718 288 innodb_log_files_in_group 2 N/A
|
719 289 innodb_max_bitmap_file_size 100 Mo N/A
|
720 290 innodb_max_changed_pages 1000000 N/A
|
721 291 innodb_mirrored_log_groups 1 N/A
|
722 292 innodb_mtflush_threads 8 N/A
|
723 293 innodb_print_lock_wait_timeout_info OFF N/A
|
724 294 innodb_replication_delay 0 N/A
|
725 295 innodb_rollback_segments 128 N/A
|
726 296 innodb_sched_priority_cleaner 19 N/A
|
727 297 innodb_scrub_log OFF N/A
|
728 298 innodb_scrub_log_speed 256 N/A
|
729 299 innodb_show_locks_held 10 N/A
|
730 300 innodb_show_verbose_locks 0 N/A
|
731 301 innodb_simulate_comp_failures 0 N/A
|
732 302 innodb_stats_sample_pages 8 N/A
|
733 303 innodb_support_xa ON N/A
|
734 304 innodb_sync_array_size 1 N/A
|
735 305 innodb_thread_concurrency 32 N/A
|
736 306 innodb_thread_sleep_delay 0 N/A
|
737 307 innodb_track_changed_pages OFF N/A
|
738 308 innodb_undo_logs 128 N/A
|
739 309 innodb_use_fallocate OFF N/A
|
740 310 innodb_use_global_flush_log_at_trx_commit ON N/A
|
741 311 innodb_use_mtflush OFF N/A
|
742 312 innodb_use_stacktrace OFF N/A
|
743 313 innodb_use_sys_malloc ON N/A
|
744 314 innodb_use_trim OFF N/A
|
745 315 max_long_data_size 16 Mo N/A
|
746 316 multi_range_count 256 N/A
|
747 317 thread_concurrency 10 N/A
|
748 318 timed_mutexes OFF N/A
|
749 319 wsrep_replicate_myisam OFF N/A
|