Skip to content

Instantly share code, notes, and snippets.

@amenk

amenk/config-variables.diff Secret

Created Oct 16, 2019
Embed
What would you like to do?
--- local.txt 2019-10-16 16:36:14.908061376 +0200
+++ prod.txt 2019-10-16 16:36:21.023949645 +0200
@@ -1,4 +1,5 @@
-MariaDB [(none)]> show variables\G;
+Variable_name: alter_algorithm
+ Value: DEFAULT
Variable_name: aria_block_size
Value: 8192
Variable_name: aria_checkpoint_interval
@@ -29,8 +30,8 @@
Value: 100
Variable_name: aria_pagecache_file_hash_size
Value: 512
-Variable_name: aria_recover
- Value: NORMAL
+Variable_name: aria_recover_options
+ Value: BACKUP,QUICK
Variable_name: aria_repair_threads
Value: 1
Variable_name: aria_sort_buffer_size
@@ -50,24 +51,28 @@
Variable_name: automatic_sp_privileges
Value: ON
Variable_name: back_log
- Value: 80
+ Value: 250
Variable_name: basedir
- Value: /usr
+ Value: /usr/
Variable_name: big_tables
Value: OFF
- Value: OFF
+Variable_name: bind_address
+ Value:
+ Value: ON
Variable_name: binlog_cache_size
Value: 32768
Variable_name: binlog_checksum
- Value: NONE
+ Value: CRC32
Variable_name: binlog_commit_wait_count
Value: 0
Variable_name: binlog_commit_wait_usec
Value: 100000
Variable_name: binlog_direct_non_transactional_updates
Value: OFF
+Variable_name: binlog_file_cache_size
+ Value: 16384
Variable_name: binlog_format
- Value: STATEMENT
+ Value: MIXED
Variable_name: binlog_optimize_thread_scheduling
Value: ON
Value: FULL
@@ -76,27 +81,37 @@
Variable_name: bulk_insert_buffer_size
Value: 8388608
Variable_name: character_set_client
- Value: utf8
+ Value: latin1
Variable_name: character_set_connection
- Value: utf8
+ Value: latin1
Variable_name: character_set_database
- Value: utf8
+ Value: latin1
Variable_name: character_set_filesystem
Value: binary
Variable_name: character_set_results
- Value: utf8
+ Value: latin1
Variable_name: character_set_server
- Value: utf8
+ Value: latin1
Variable_name: character_set_system
Value: utf8
Variable_name: character_sets_dir
Value: /usr/share/mysql/charsets/
+Variable_name: check_constraint_checks
+ Value: ON
Variable_name: collation_connection
- Value: utf8_general_ci
+ Value: latin1_swedish_ci
Variable_name: collation_database
- Value: utf8_general_ci
+ Value: latin1_swedish_ci
Variable_name: collation_server
- Value: utf8_general_ci
+ Value: latin1_swedish_ci
+Variable_name: column_compression_threshold
+ Value: 100
+Variable_name: column_compression_zlib_level
+ Value: 6
+Variable_name: column_compression_zlib_strategy
+ Value: DEFAULT_STRATEGY
+Variable_name: column_compression_zlib_wrap
+ Value: OFF
Variable_name: completion_type
Value: NO_CHAIN
Variable_name: concurrent_insert
@@ -149,6 +164,8 @@
Value: OFF
Variable_name: enforce_storage_engine
Value:
+Variable_name: eq_range_index_dive_limit
+ Value: 0
Variable_name: error_count
Value: 0
Variable_name: event_scheduler
@@ -184,9 +201,9 @@
Variable_name: general_log
Value: OFF
Variable_name: general_log_file
- Value: orange.log
+ Value: foobar.log
Variable_name: group_concat_max_len
- Value: 1024
+ Value: 320000
Variable_name: gtid_binlog_pos
Value:
Variable_name: gtid_binlog_state
@@ -197,6 +214,8 @@
Value: 0
Variable_name: gtid_ignore_duplicates
Value: OFF
+Variable_name: gtid_pos_auto_engines
+ Value:
Variable_name: gtid_seq_no
Value: 0
Variable_name: gtid_slave_pos
@@ -212,7 +231,7 @@
Variable_name: have_geometry
Value: YES
Variable_name: have_openssl
- Value: NO
+ Value: YES
Variable_name: have_profiling
Value: YES
Variable_name: have_query_cache
@@ -222,21 +241,29 @@
Variable_name: have_ssl
Value: DISABLED
Variable_name: have_symlink
- Value: YES
+ Value: DISABLED
Variable_name: histogram_size
Value: 0
Variable_name: histogram_type
Value: SINGLE_PREC_HB
Variable_name: host_cache_size
- Value: 279
+ Value: 653
Variable_name: hostname
- Value: orange
+ Value: foobar.example-cloud.de
Variable_name: identity
Value: 0
+Variable_name: idle_readonly_transaction_timeout
+ Value: 0
+Variable_name: idle_transaction_timeout
+ Value: 0
+Variable_name: idle_write_transaction_timeout
+ Value: 0
Variable_name: ignore_builtin_innodb
Value: OFF
Variable_name: ignore_db_dirs
Value:
+Variable_name: in_predicate_conversion_threshold
+ Value: 1000
Variable_name: in_transaction
Value: 0
Variable_name: init_connect
@@ -251,21 +278,10 @@
Value: 10.000000
Variable_name: innodb_adaptive_hash_index
Value: ON
-Variable_name: innodb_adaptive_hash_index_partitions
- Value: 1
+Variable_name: innodb_adaptive_hash_index_parts
+ Value: 8
Variable_name: innodb_adaptive_max_sleep_delay
Value: 150000
-Variable_name: innodb_additional_mem_pool_size
- Value: 8388608
-Variable_name: innodb_api_bk_commit_interval
- Value: 5
- Value: OFF
-Variable_name: innodb_api_enable_binlog
- Value: OFF
-Variable_name: innodb_api_enable_mdl
- Value: OFF
-Variable_name: innodb_api_trx_level
- Value: 0
Variable_name: innodb_autoextend_increment
Value: 64
Variable_name: innodb_autoinc_lock_mode
@@ -280,42 +296,42 @@
Value: OFF
Variable_name: innodb_buf_dump_status_frequency
Value: 0
+Variable_name: innodb_buffer_pool_chunk_size
+ Value: 134217728
Variable_name: innodb_buffer_pool_dump_at_shutdown
- Value: OFF
+ Value: ON
Variable_name: innodb_buffer_pool_dump_now
Value: OFF
Variable_name: innodb_buffer_pool_dump_pct
- Value: 100
+ Value: 25
Variable_name: innodb_buffer_pool_filename
Value: ib_buffer_pool
Variable_name: innodb_buffer_pool_instances
- Value: 8
+ Value: 1
Variable_name: innodb_buffer_pool_load_abort
Value: OFF
Variable_name: innodb_buffer_pool_load_at_startup
- Value: OFF
+ Value: ON
Variable_name: innodb_buffer_pool_load_now
Value: OFF
-Variable_name: innodb_buffer_pool_populate
- Value: OFF
Variable_name: innodb_buffer_pool_size
- Value: 134217728
+ Value: 536870912
Variable_name: innodb_change_buffer_max_size
Value: 25
Variable_name: innodb_change_buffering
Value: all
Variable_name: innodb_checksum_algorithm
- Value: INNODB
+ Value: crc32
Variable_name: innodb_checksums
Value: ON
-Variable_name: innodb_cleaner_lsn_age_factor
- Value: HIGH_CHECKPOINT
Variable_name: innodb_cmp_per_index_enabled
Value: OFF
Variable_name: innodb_commit_concurrency
Value: 0
Variable_name: innodb_compression_algorithm
Value: zlib
+Variable_name: innodb_compression_default
+ Value: OFF
Variable_name: innodb_compression_failure_threshold_pct
Value: 5
Variable_name: innodb_compression_level
@@ -324,15 +340,15 @@
Value: 50
Variable_name: innodb_concurrency_tickets
Value: 5000
-Variable_name: innodb_corrupt_table_action
- Value: assert
Variable_name: innodb_data_file_path
Value: ibdata1:12M:autoextend
Variable_name: innodb_data_home_dir
Value:
+Variable_name: innodb_deadlock_detect
+ Value: ON
Variable_name: innodb_default_encryption_key_id
Value: 1
- Value: compact
+ Value: dynamic
Variable_name: innodb_defragment
Value: OFF
Variable_name: innodb_defragment_fill_factor
@@ -351,40 +367,38 @@
Value: OFF
Variable_name: innodb_doublewrite
Value: ON
-Variable_name: innodb_empty_free_list_algorithm
- Value: LEGACY
Variable_name: innodb_encrypt_log
Value: OFF
Variable_name: innodb_encrypt_tables
Value: OFF
+Variable_name: innodb_encrypt_temporary_tables
+ Value: OFF
Variable_name: innodb_encryption_rotate_key_age
Value: 1
Variable_name: innodb_encryption_rotation_iops
Value: 100
Variable_name: innodb_encryption_threads
Value: 0
-Variable_name: innodb_fake_changes
- Value: OFF
Variable_name: innodb_fast_shutdown
Value: 1
Variable_name: innodb_fatal_semaphore_wait_threshold
Value: 600
Variable_name: innodb_file_format
- Value: Antelope
-Variable_name: innodb_file_format_check
- Value: ON
-Variable_name: innodb_file_format_max
- Value: Barracuda
+ Value:
Variable_name: innodb_file_per_table
Value: ON
+Variable_name: innodb_fill_factor
+ Value: 100
Variable_name: innodb_flush_log_at_timeout
Value: 1
Variable_name: innodb_flush_log_at_trx_commit
- Value: 1
+ Value: 2
Variable_name: innodb_flush_method
- Value:
+ Value: fsync
Variable_name: innodb_flush_neighbors
Value: 1
+Variable_name: innodb_flush_sync
+ Value: ON
Variable_name: innodb_flushing_avg_loops
Value: 30
Variable_name: innodb_force_load_corrupted
@@ -393,8 +407,6 @@
Value: OFF
Variable_name: innodb_force_recovery
Value: 0
-Variable_name: innodb_foreground_preflush
- Value: EXPONENTIAL_BACKOFF
Variable_name: innodb_ft_aux_table
Value:
Variable_name: innodb_ft_cache_size
@@ -423,36 +435,22 @@
Value: 100
Variable_name: innodb_immediate_scrub_data_uncompressed
Value: OFF
-Variable_name: innodb_instrument_semaphores
- Value: OFF
Variable_name: innodb_io_capacity
Value: 200
Variable_name: innodb_io_capacity_max
Value: 2000
-Variable_name: innodb_kill_idle_transaction
- Value: 0
Variable_name: innodb_large_prefix
- Value: OFF
+ Value:
Variable_name: innodb_lock_schedule_algorithm
Value: fcfs
Variable_name: innodb_lock_wait_timeout
Value: 50
-Variable_name: innodb_locking_fake_changes
- Value: ON
Variable_name: innodb_locks_unsafe_for_binlog
Value: OFF
-Variable_name: innodb_log_arch_dir
- Value: ./
-Variable_name: innodb_log_arch_expire_sec
- Value: 0
-Variable_name: innodb_log_archive
- Value: OFF
-Variable_name: innodb_log_block_size
- Value: 512
Variable_name: innodb_log_buffer_size
Value: 16777216
-Variable_name: innodb_log_checksum_algorithm
- Value: INNODB
+Variable_name: innodb_log_checksums
+ Value: ON
Variable_name: innodb_log_compressed_pages
Value: ON
Variable_name: innodb_log_file_size
@@ -461,22 +459,22 @@
Value: 2
Variable_name: innodb_log_group_home_dir
Value: ./
+Variable_name: innodb_log_optimize_ddl
+ Value: ON
+Variable_name: innodb_log_write_ahead_size
+ Value: 8192
Variable_name: innodb_lru_scan_depth
Value: 1024
-Variable_name: innodb_max_bitmap_file_size
- Value: 104857600
-Variable_name: innodb_max_changed_pages
- Value: 1000000
Variable_name: innodb_max_dirty_pages_pct
Value: 75.000000
Variable_name: innodb_max_dirty_pages_pct_lwm
- Value: 0.001000
+ Value: 0.000000
Variable_name: innodb_max_purge_lag
Value: 0
Variable_name: innodb_max_purge_lag_delay
Value: 0
-Variable_name: innodb_mirrored_log_groups
- Value: 1
+Variable_name: innodb_max_undo_log_size
+ Value: 10485760
Variable_name: innodb_monitor_disable
Value:
Variable_name: innodb_monitor_enable
@@ -485,8 +483,6 @@
Value:
Variable_name: innodb_monitor_reset_all
Value:
-Variable_name: innodb_mtflush_threads
- Value: 8
Variable_name: innodb_old_blocks_pct
Value: 37
Variable_name: innodb_old_blocks_time
@@ -494,21 +490,23 @@
Variable_name: innodb_online_alter_log_max_size
Value: 134217728
Variable_name: innodb_open_files
- Value: 2000
+ Value: 600
Variable_name: innodb_optimize_fulltext_only
Value: OFF
+Variable_name: innodb_page_cleaners
+ Value: 1
Variable_name: innodb_page_size
Value: 16384
Variable_name: innodb_prefix_index_cluster_optimization
Value: OFF
Variable_name: innodb_print_all_deadlocks
Value: OFF
-Variable_name: innodb_print_lock_wait_timeout_info
- Value: OFF
Variable_name: innodb_purge_batch_size
Value: 300
+Variable_name: innodb_purge_rseg_truncate_frequency
+ Value: 128
Variable_name: innodb_purge_threads
- Value: 1
+ Value: 4
Variable_name: innodb_random_read_ahead
Value: OFF
Variable_name: innodb_read_ahead_threshold
@@ -523,22 +521,14 @@
Value: OFF
Variable_name: innodb_rollback_segments
Value: 128
-Variable_name: innodb_sched_priority_cleaner
- Value: 19
Variable_name: innodb_scrub_log
Value: OFF
Variable_name: innodb_scrub_log_speed
Value: 256
-Variable_name: innodb_show_locks_held
- Value: 10
-Variable_name: innodb_show_verbose_locks
- Value: 0
-Variable_name: innodb_simulate_comp_failures
- Value: 0
Variable_name: innodb_sort_buffer_size
Value: 1048576
Variable_name: innodb_spin_wait_delay
- Value: 6
+ Value: 4
Variable_name: innodb_stats_auto_recalc
Value: ON
Variable_name: innodb_stats_include_delete_marked
@@ -564,8 +554,6 @@
Variable_name: innodb_status_output_locks
Value: OFF
Variable_name: innodb_strict_mode
- Value: OFF
-Variable_name: innodb_support_xa
Value: ON
Variable_name: innodb_sync_array_size
Value: 1
@@ -573,38 +561,28 @@
Value: 30
Variable_name: innodb_table_locks
Value: ON
+Variable_name: innodb_temp_data_file_path
+ Value: ibtmp1:12M:autoextend
Variable_name: innodb_thread_concurrency
Value: 0
Variable_name: innodb_thread_sleep_delay
Value: 10000
Variable_name: innodb_tmpdir
Value:
-Variable_name: innodb_track_changed_pages
- Value: OFF
Variable_name: innodb_undo_directory
- Value: .
+ Value: ./
+Variable_name: innodb_undo_log_truncate
+ Value: OFF
Variable_name: innodb_undo_logs
Value: 128
Variable_name: innodb_undo_tablespaces
Value: 0
Variable_name: innodb_use_atomic_writes
- Value: OFF
-Variable_name: innodb_use_fallocate
- Value: OFF
-Variable_name: innodb_use_global_flush_log_at_trx_commit
Value: ON
-Variable_name: innodb_use_mtflush
- Value: OFF
Variable_name: innodb_use_native_aio
Value: ON
-Variable_name: innodb_use_stacktrace
- Value: OFF
-Variable_name: innodb_use_sys_malloc
- Value: ON
-Variable_name: innodb_use_trim
- Value: OFF
Variable_name: innodb_version
- Value: 5.6.44-86.0
+ Value: 10.3.18
Variable_name: innodb_write_io_threads
Value: 4
Variable_name: insert_id
@@ -620,7 +598,7 @@
Variable_name: keep_files_on_create
Value: OFF
Variable_name: key_buffer_size
- Value: 16777216
+ Value: 134217728
Variable_name: key_cache_age_threshold
Value: 300
Variable_name: key_cache_block_size
@@ -644,27 +622,33 @@
Variable_name: lc_messages
Value: en_US
Variable_name: lc_messages_dir
- Value: /usr/share/mysql
+ Value:
Variable_name: lc_time_names
Value: en_US
Variable_name: license
Value: GPL
Variable_name: local_infile
- Value: ON
+ Value: OFF
Variable_name: lock_wait_timeout
- Value: 31536000
+ Value: 86400
Variable_name: locked_in_memory
Value: OFF
Variable_name: log_bin
Value: OFF
Variable_name: log_bin_basename
Value:
+Variable_name: log_bin_compress
+ Value: OFF
+Variable_name: log_bin_compress_min_len
+ Value: 256
Variable_name: log_bin_index
Value:
Variable_name: log_bin_trust_function_creators
Value: OFF
+Variable_name: log_disabled_statements
+ Value: sp
Variable_name: log_error
- Value: /var/log/mysql/error.log
+ Value: /var/log/mysql.err
Variable_name: log_output
Value: FILE
Variable_name: log_queries_not_using_indexes
@@ -672,19 +656,21 @@
Variable_name: log_slave_updates
Value: OFF
Variable_name: log_slow_admin_statements
- Value: OFF
+ Value: ON
+Variable_name: log_slow_disabled_statements
+ Value: sp
Variable_name: log_slow_filter
- Value: admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
+ Value: admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
Variable_name: log_slow_rate_limit
Value: 1
Variable_name: log_slow_slave_statements
- Value: OFF
+ Value: ON
Variable_name: log_slow_verbosity
Value:
Variable_name: log_tc_size
Value: 24576
Variable_name: log_warnings
- Value: 1
+ Value: 2
Variable_name: long_query_time
Value: 10.000000
Variable_name: low_priority_updates
@@ -696,17 +682,17 @@
Variable_name: master_verify_checksum
Value: OFF
Variable_name: max_allowed_packet
- Value: 16777216
+ Value: 104857600
Variable_name: max_binlog_cache_size
Value: 18446744073709547520
Variable_name: max_binlog_size
- Value: 104857600
+ Value: 1073741824
Variable_name: max_binlog_stmt_cache_size
Value: 18446744073709547520
Variable_name: max_connect_errors
Value: 100
Variable_name: max_connections
- Value: 151
+ Value: 1000
Variable_name: max_delayed_threads
Value: 20
Variable_name: max_digest_length
@@ -714,7 +700,7 @@
Variable_name: max_error_count
Value: 64
Variable_name: max_heap_table_size
- Value: 16777216
+ Value: 2147483648
Variable_name: max_insert_delayed_threads
Value: 20
Variable_name: max_join_size
@@ -722,11 +708,13 @@
Variable_name: max_length_for_sort_data
Value: 1024
Variable_name: max_long_data_size
- Value: 16777216
+ Value: 104857600
Variable_name: max_prepared_stmt_count
Value: 16382
+Variable_name: max_recursive_iterations
+ Value: 4294967295
Variable_name: max_relay_log_size
- Value: 104857600
+ Value: 1073741824
Variable_name: max_seeks_for_key
Value: 4294967295
Variable_name: max_session_mem_used
@@ -783,7 +771,7 @@
Variable_name: old
Value: OFF
Variable_name: old_alter_table
- Value: OFF
+ Value: DEFAULT
Variable_name: old_mode
Value:
Variable_name: old_passwords
@@ -793,7 +781,7 @@
Variable_name: optimizer_prune_level
Value: 1
Variable_name: optimizer_search_depth
- Value: 62
+ Value: 0
Variable_name: optimizer_selectivity_sampling_limit
Value: 100
Variable_name: optimizer_switch
@@ -844,9 +832,9 @@
Variable_name: performance_schema_max_socket_instances
Value: -1
Variable_name: performance_schema_max_stage_classes
- Value: 150
+ Value: 160
Variable_name: performance_schema_max_statement_classes
- Value: 178
+ Value: 200
Variable_name: performance_schema_max_table_handles
Value: -1
Variable_name: performance_schema_max_table_instances
@@ -864,11 +852,11 @@
Variable_name: performance_schema_users_size
Value: -1
Variable_name: pid_file
- Value: /var/run/mysqld/mysqld.pid
+ Value: /var/lib/mysql/foobar.pid
Variable_name: plugin_dir
- Value: /usr/lib/x86_64-linux-gnu/mariadb18/plugin/
+ Value: /usr/lib64/mysql/plugin/
Variable_name: plugin_maturity
- Value: unknown
+ Value: gamma
Variable_name: port
Value: 3306
Variable_name: preload_buffer_size
@@ -881,20 +869,22 @@
Value: 5
Variable_name: protocol_version
Value: 10
+Variable_name: proxy_protocol_networks
+ Value:
Variable_name: proxy_user
Value:
Variable_name: pseudo_slave_mode
Value: OFF
Variable_name: pseudo_thread_id
- Value: 1714
+ Value: 696668
Variable_name: query_alloc_block_size
Value: 16384
Variable_name: query_cache_limit
Value: 1048576
Variable_name: query_cache_min_res_unit
- Value: 4096
+ Value: 2048
Variable_name: query_cache_size
- Value: 16777216
+ Value: 134217728
Variable_name: query_cache_strip_comments
Value: OFF
Variable_name: query_cache_type
@@ -904,11 +894,13 @@
Variable_name: query_prealloc_size
Value: 24576
Variable_name: rand_seed1
- Value: 152486464
+ Value: 436094181
Variable_name: rand_seed2
- Value: 504229211
+ Value: 945303972
Variable_name: range_alloc_block_size
Value: 4096
+Variable_name: read_binlog_speed_limit
+ Value: 0
Variable_name: read_buffer_size
Value: 131072
Variable_name: read_only
@@ -929,7 +921,7 @@
Value: OFF
Variable_name: relay_log_space_limit
Value: 0
- Value: OFF
+ Value: ON
Variable_name: replicate_do_db
Value:
Variable_name: replicate_do_table
@@ -953,16 +945,44 @@
Variable_name: report_user
Value:
Value: 8388608
+Variable_name: rpl_semi_sync_master_enabled
+ Value: OFF
+Variable_name: rpl_semi_sync_master_timeout
+ Value: 10000
+Variable_name: rpl_semi_sync_master_trace_level
+ Value: 32
+Variable_name: rpl_semi_sync_master_wait_no_slave
+ Value: ON
+Variable_name: rpl_semi_sync_master_wait_point
+ Value: AFTER_COMMIT
+Variable_name: rpl_semi_sync_slave_delay_master
+ Value: OFF
+Variable_name: rpl_semi_sync_slave_enabled
+ Value: OFF
+Variable_name: rpl_semi_sync_slave_kill_conn_timeout
+ Value: 5
+Variable_name: rpl_semi_sync_slave_trace_level
+ Value: 32
Variable_name: secure_auth
Value: ON
Variable_name: secure_file_priv
Value:
+Variable_name: secure_timestamp
+ Value: NO
Variable_name: server_id
- Value: 0
+ Value: 1
+Variable_name: session_track_schema
+ Value: ON
+Variable_name: session_track_state_change
+ Value: OFF
+Variable_name: session_track_system_variables
+ Value: autocommit,character_set_client,character_set_connection,character_set_results,time_zone
+Variable_name: session_track_transaction_info
+ Value: OFF
Variable_name: skip_external_locking
Value: ON
Variable_name: skip_name_resolve
- Value: OFF
+ Value: ON
Variable_name: skip_networking
Value: OFF
Variable_name: skip_parallel_replication
@@ -984,13 +1004,15 @@
Variable_name: slave_max_allowed_packet
Value: 1073741824
Variable_name: slave_net_timeout
- Value: 3600
+ Value: 60
Variable_name: slave_parallel_max_queued
Value: 131072
Variable_name: slave_parallel_mode
Value: conservative
Variable_name: slave_parallel_threads
Value: 0
+Variable_name: slave_parallel_workers
+ Value: 0
Variable_name: slave_run_triggers_for_rbr
Value: NO
Variable_name: slave_skip_errors
@@ -999,6 +1021,10 @@
Value: ON
Variable_name: slave_transaction_retries
Value: 10
+Variable_name: slave_transaction_retry_errors
+ Value: 1213,1205
+Variable_name: slave_transaction_retry_interval
+ Value: 0
Variable_name: slave_type_conversions
Value:
Variable_name: slow_launch_time
@@ -1006,9 +1032,9 @@
Variable_name: slow_query_log
Value: OFF
Variable_name: slow_query_log_file
- Value: orange-slow.log
+ Value: foobar-slow.log
Variable_name: socket
- Value: /var/run/mysqld/mysqld.sock
+ Value: /var/lib/mysql/mysql.sock
Variable_name: sort_buffer_size
Value: 2097152
Variable_name: sql_auto_is_null
@@ -1049,6 +1075,8 @@
Value:
Variable_name: ssl_key
Value:
+Variable_name: standard_compliant_cte
+ Value: ON
Variable_name: storage_engine
Value: InnoDB
Variable_name: stored_program_cache
@@ -1056,7 +1084,7 @@
Variable_name: strict_password_validation
Value: ON
Variable_name: sync_binlog
- Value: 0
+ Value: 2
Variable_name: sync_frm
Value: ON
Variable_name: sync_master_info
@@ -1067,12 +1095,24 @@
Value: 10000
Variable_name: system_time_zone
Value: CEST
+Variable_name: system_versioning_alter_history
+ Value: ERROR
+Variable_name: system_versioning_asof
+ Value: DEFAULT
Variable_name: table_definition_cache
Value: 400
Variable_name: table_open_cache
- Value: 2000
-Variable_name: thread_cache_size
+ Value: 600
+Variable_name: table_open_cache_instances
Value: 8
+Variable_name: tcp_keepalive_interval
+ Value: 0
+Variable_name: tcp_keepalive_probes
+ Value: 0
+Variable_name: tcp_keepalive_time
+ Value: 0
+Variable_name: thread_cache_size
+ Value: 256
Variable_name: thread_concurrency
Value: 10
Variable_name: thread_handling
@@ -1080,15 +1120,19 @@
Variable_name: thread_pool_idle_timeout
Value: 60
Variable_name: thread_pool_max_threads
- Value: 1000
+ Value: 65536
Variable_name: thread_pool_oversubscribe
Value: 3
+Variable_name: thread_pool_prio_kickup_timer
+ Value: 1000
+Variable_name: thread_pool_priority
+ Value: auto
Variable_name: thread_pool_size
- Value: 4
+ Value: 8
Variable_name: thread_pool_stall_limit
Value: 500
Variable_name: thread_stack
- Value: 196608
+ Value: 299008
Variable_name: time_format
Value: %H:%i:%s
Variable_name: time_zone
@@ -1096,9 +1140,13 @@
Variable_name: timed_mutexes
Value: OFF
Variable_name: timestamp
- Value: 1571236374.562127
+ Value: 1571236426.152921
+Variable_name: tmp_disk_table_size
+ Value: 18446744073709551615
+Variable_name: tmp_memory_table_size
+ Value: 2147483648
Variable_name: tmp_table_size
- Value: 16777216
+ Value: 2147483648
Variable_name: tmpdir
Value: /tmp
Variable_name: transaction_alloc_block_size
@@ -1118,17 +1166,19 @@
Variable_name: userstat
Value: OFF
Variable_name: version
- Value: 10.1.41-MariaDB-0ubuntu0.18.04.1
+ Value: 10.3.18-MariaDB
Variable_name: version_comment
- Value: Ubuntu 18.04
+ Value: MariaDB Server
Variable_name: version_compile_machine
Value: x86_64
Variable_name: version_compile_os
- Value: debian-linux-gnu
+ Value: Linux
Variable_name: version_malloc_library
- Value: system jemalloc
+ Value: system
+Variable_name: version_source_revision
+ Value: 604f80e77c054758aa449064cdc29dfa13a71922
Variable_name: version_ssl_library
- Value: YaSSL 2.4.4
+ Value: OpenSSL 1.0.2k-fips 26 Jan 2017
Variable_name: wait_timeout
Value: 28800
Variable_name: warning_count
@@ -1181,7 +1231,7 @@
Variable_name: wsrep_node_incoming_address
Value: AUTO
Variable_name: wsrep_node_name
- Value: orange
+ Value: foobar.example-cloud.de
Variable_name: wsrep_notify_cmd
Value:
Variable_name: wsrep_on
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.