-
-
Save amenk/049480614ac7ff1daf6b6cadbbcdacaf to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- 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