Variable_name = Value alter_algorithm = DEFAULT analyze_sample_percentage = 100.000000 aria_block_size = 8192 aria_checkpoint_interval = 30 aria_checkpoint_log_activity = 1048576 aria_encrypt_tables = OFF aria_force_start_after_recovery_failures = 0 aria_group_commit = none aria_group_commit_interval = 0 aria_log_dir_path = /lib/mysql/ aria_log_file_size = 1073741824 aria_log_purge_type = immediate aria_max_sort_file_size = 9223372036853727232 aria_page_checksum = ON aria_pagecache_age_threshold = 300 aria_pagecache_buffer_size = 134217728 aria_pagecache_division_limit = 100 aria_pagecache_file_hash_size = 512 aria_recover_options = BACKUP,QUICK aria_repair_threads = 1 aria_sort_buffer_size = 268434432 aria_stats_method = nulls_unequal aria_sync_log_dir = NEWFILE aria_used_for_temp_tables = ON auto_increment_increment = 1 auto_increment_offset = 1 autocommit = ON automatic_sp_privileges = ON back_log = 200 basedir = /usr/ big_tables = OFF bind_address = binlog_annotate_row_events = ON binlog_cache_size = 32768 binlog_checksum = CRC32 binlog_commit_wait_count = 0 binlog_commit_wait_usec = 100000 binlog_direct_non_transactional_updates = OFF binlog_expire_logs_seconds = 345600 binlog_file_cache_size = 16384 binlog_format = MIXED binlog_optimize_thread_scheduling = ON binlog_row_image = FULL binlog_row_metadata = NO_LOG binlog_stmt_cache_size = 32768 bulk_insert_buffer_size = 8388608 character_set_client = latin1 character_set_connection = latin1 character_set_database = latin1 character_set_filesystem = binary character_set_results = latin1 character_set_server = latin1 character_set_system = utf8mb3 character_sets_dir = /usr/share/mysql/charsets/ check_constraint_checks = ON collation_connection = latin1_swedish_ci collation_database = latin1_swedish_ci collation_server = latin1_swedish_ci column_compression_threshold = 100 column_compression_zlib_level = 6 column_compression_zlib_strategy = DEFAULT_STRATEGY column_compression_zlib_wrap = OFF completion_type = NO_CHAIN concurrent_insert = AUTO connect_timeout = 10 core_file = ON datadir = /lib/mysql/ date_format = %Y-%m-%d datetime_format = %Y-%m-%d %H:%i:%s deadlock_search_depth_long = 15 deadlock_search_depth_short = 4 deadlock_timeout_long = 50000000 deadlock_timeout_short = 10000 debug_no_thread_alarm = OFF default_password_lifetime = 0 default_regex_flags = default_storage_engine = InnoDB default_tmp_storage_engine = Aria default_week_format = 0 delay_key_write = ON delayed_insert_limit = 100 delayed_insert_timeout = 300 delayed_queue_size = 1000 disconnect_on_expired_password = OFF div_precision_increment = 4 encrypt_binlog = OFF encrypt_tmp_disk_tables = OFF encrypt_tmp_files = OFF enforce_storage_engine = eq_range_index_dive_limit = 200 event_scheduler = ON expensive_subquery_limit = 100 expire_logs_days = 4.000000 explicit_defaults_for_timestamp = OFF extra_max_connections = 1 extra_port = 0 flush = OFF flush_time = 0 foreign_key_checks = ON ft_boolean_syntax = + -><()~*:""&| ft_max_word_len = 84 ft_min_word_len = 4 ft_query_expansion_limit = 20 ft_stopword_file = (built-in) general_log = OFF general_log_file = node-3.log group_concat_max_len = 1024 gtid_binlog_pos = 0-210854902-182501 gtid_binlog_state = 0-210854901-40130,0-210854902-182501 gtid_cleanup_batch_size = 64 gtid_current_pos = 0-210854902-182501 gtid_domain_id = 0 gtid_ignore_duplicates = OFF gtid_pos_auto_engines = gtid_slave_pos = 0-210854901-40130 gtid_strict_mode = ON have_compress = YES have_crypt = YES have_dynamic_loading = YES have_geometry = YES have_openssl = YES have_profiling = YES have_query_cache = YES have_rtree_keys = YES have_ssl = YES have_symlink = DISABLED histogram_size = 254 histogram_type = DOUBLE_PREC_HB host_cache_size = 640 hostname = node-3.saas.appiancloud.com idle_readonly_transaction_timeout = 300 idle_transaction_timeout = 0 idle_write_transaction_timeout = 0 ignore_builtin_innodb = OFF ignore_db_dirs = in_predicate_conversion_threshold = 1000 init_connect = init_file = init_slave = innodb_adaptive_flushing = ON innodb_adaptive_flushing_lwm = 10.000000 innodb_adaptive_hash_index = OFF innodb_adaptive_hash_index_parts = 8 innodb_autoextend_increment = 64 innodb_autoinc_lock_mode = 1 innodb_buf_dump_status_frequency = 0 innodb_buffer_pool_chunk_size = 134217728 innodb_buffer_pool_dump_at_shutdown = ON innodb_buffer_pool_dump_now = OFF innodb_buffer_pool_dump_pct = 100 innodb_buffer_pool_filename = ib_buffer_pool innodb_buffer_pool_load_abort = OFF innodb_buffer_pool_load_at_startup = ON innodb_buffer_pool_load_now = OFF innodb_buffer_pool_size = 1073741824 innodb_change_buffer_max_size = 25 innodb_change_buffering = none innodb_checksum_algorithm = full_crc32 innodb_cmp_per_index_enabled = OFF innodb_compression_algorithm = zlib innodb_compression_default = OFF innodb_compression_failure_threshold_pct = 5 innodb_compression_level = 6 innodb_compression_pad_pct_max = 50 innodb_data_file_path = ibdata1:12M:autoextend innodb_data_home_dir = innodb_deadlock_detect = ON innodb_deadlock_report = full innodb_default_encryption_key_id = 1 innodb_default_row_format = dynamic innodb_defragment = OFF innodb_defragment_fill_factor = 0.900000 innodb_defragment_fill_factor_n_recs = 20 innodb_defragment_frequency = 40 innodb_defragment_n_pages = 7 innodb_defragment_stats_accuracy = 0 innodb_disable_sort_file_cache = OFF innodb_doublewrite = ON innodb_encrypt_log = OFF innodb_encrypt_tables = OFF innodb_encrypt_temporary_tables = OFF innodb_encryption_rotate_key_age = 1 innodb_encryption_rotation_iops = 100 innodb_encryption_threads = 0 innodb_fast_shutdown = 0 innodb_fatal_semaphore_wait_threshold = 600 innodb_file_per_table = ON innodb_fill_factor = 90 innodb_flush_log_at_timeout = 1 innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT innodb_flush_neighbors = 1 innodb_flush_sync = ON innodb_flushing_avg_loops = 30 innodb_force_primary_key = ON innodb_force_recovery = 0 innodb_ft_aux_table = innodb_ft_cache_size = 8000000 innodb_ft_enable_diag_print = OFF innodb_ft_enable_stopword = ON innodb_ft_max_token_size = 84 innodb_ft_min_token_size = 3 innodb_ft_num_word_optimize = 2000 innodb_ft_result_cache_limit = 2000000000 innodb_ft_server_stopword_table = innodb_ft_sort_pll_degree = 2 innodb_ft_total_cache_size = 640000000 innodb_ft_user_stopword_table = innodb_immediate_scrub_data_uncompressed = OFF innodb_instant_alter_column_allowed = add_drop_reorder innodb_io_capacity = 200 innodb_io_capacity_max = 2000 innodb_lock_wait_timeout = 50 innodb_log_buffer_size = 16777216 innodb_log_file_size = 1073741824 innodb_log_group_home_dir = ./ innodb_log_write_ahead_size = 8192 innodb_lru_flush_size = 32 innodb_lru_scan_depth = 1536 innodb_max_dirty_pages_pct = 90.000000 innodb_max_dirty_pages_pct_lwm = 0.000000 innodb_max_purge_lag = 0 innodb_max_purge_lag_delay = 0 innodb_max_purge_lag_wait = 4294967295 innodb_max_undo_log_size = 10485760 innodb_monitor_disable = innodb_monitor_enable = innodb_monitor_reset = innodb_monitor_reset_all = innodb_old_blocks_pct = 37 innodb_old_blocks_time = 1000 innodb_online_alter_log_max_size = 134217728 innodb_open_files = 2000 innodb_optimize_fulltext_only = OFF innodb_page_size = 16384 innodb_prefix_index_cluster_optimization = OFF innodb_print_all_deadlocks = OFF innodb_purge_batch_size = 1000 innodb_purge_rseg_truncate_frequency = 128 innodb_purge_threads = 4 innodb_random_read_ahead = OFF innodb_read_ahead_threshold = 56 innodb_read_io_threads = 4 innodb_read_only = OFF innodb_read_only_compressed = OFF innodb_rollback_on_timeout = OFF innodb_snapshot_isolation = OFF innodb_sort_buffer_size = 1048576 innodb_spin_wait_delay = 4 innodb_stats_auto_recalc = ON innodb_stats_include_delete_marked = OFF innodb_stats_method = nulls_equal innodb_stats_modified_counter = 0 innodb_stats_on_metadata = OFF innodb_stats_persistent = ON innodb_stats_persistent_sample_pages = 20 innodb_stats_traditional = ON innodb_stats_transient_sample_pages = 8 innodb_status_output = OFF innodb_status_output_locks = OFF innodb_strict_mode = ON innodb_sync_spin_loops = 30 innodb_table_locks = ON innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:6431M innodb_tmpdir = /temp innodb_undo_directory = ./ innodb_undo_log_truncate = OFF innodb_undo_tablespaces = 0 innodb_use_atomic_writes = ON innodb_use_native_aio = ON innodb_version = 10.6.18 innodb_write_io_threads = 4 interactive_timeout = 28800 join_buffer_size = 262144 join_buffer_space_limit = 2097152 join_cache_level = 2 keep_files_on_create = OFF key_buffer_size = 134217728 key_cache_age_threshold = 300 key_cache_block_size = 1024 key_cache_division_limit = 100 key_cache_file_hash_size = 512 key_cache_segments = 0 large_files_support = ON large_page_size = 0 large_pages = OFF lc_messages = en_US lc_messages_dir = lc_time_names = en_US license = GPL local_infile = OFF lock_wait_timeout = 86400 locked_in_memory = OFF log_bin = ON log_bin_basename = /bin-log/mysql-bin log_bin_compress = OFF log_bin_compress_min_len = 256 log_bin_index = /bin-log/mysql-bin.index log_bin_trust_function_creators = ON log_disabled_statements = sp log_error = /lib/mysql/node-3.err log_output = TABLE log_queries_not_using_indexes = OFF log_slave_updates = ON log_slow_admin_statements = ON log_slow_disabled_statements = sp log_slow_filter = admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk log_slow_max_warnings = 10 log_slow_rate_limit = 1 log_slow_slave_statements = ON log_slow_verbosity = log_tc_size = 24576 log_warnings = 2 long_query_time = 7.000000 low_priority_updates = OFF lower_case_file_system = OFF lower_case_table_names = 0 master_verify_checksum = OFF max_allowed_packet = 16777216 max_binlog_cache_size = 18446744073709547520 max_binlog_size = 268435456 max_binlog_stmt_cache_size = 18446744073709547520 max_connect_errors = 100 max_connections = 750 max_delayed_threads = 20 max_digest_length = 1024 max_error_count = 64 max_heap_table_size = 16777216 max_insert_delayed_threads = 20 max_join_size = 18446744073709551615 max_length_for_sort_data = 1024 max_password_errors = 4294967295 max_prepared_stmt_count = 16382 max_recursive_iterations = 255 max_relay_log_size = 268435456 max_rowid_filter_size = 131072 max_seeks_for_key = 4294967295 max_session_mem_used = 9223372036854775807 max_sort_length = 1024 max_sp_recursion_depth = 0 max_statement_time = 0.000000 max_tmp_tables = 32 max_user_connections = 0 max_write_lock_count = 4294967295 metadata_locks_cache_size = 1024 metadata_locks_hash_instances = 8 min_examined_row_limit = 0 mrr_buffer_size = 262144 myisam_block_size = 1024 myisam_data_pointer_size = 6 myisam_max_sort_file_size = 9223372036853727232 myisam_mmap_size = 18446744073709551615 myisam_recover_options = BACKUP,QUICK myisam_repair_threads = 1 myisam_sort_buffer_size = 134216704 myisam_stats_method = NULLS_UNEQUAL myisam_use_mmap = OFF mysql56_temporal_format = ON net_buffer_length = 16384 net_read_timeout = 30 net_retry_count = 10 net_write_timeout = 60 note_verbosity = basic,explain old = OFF old_alter_table = DEFAULT old_mode = UTF8_IS_UTF8MB3 old_passwords = OFF open_files_limit = 32783 optimizer_adjust_secondary_key_costs = optimizer_max_sel_arg_weight = 32000 optimizer_max_sel_args = 16000 optimizer_prune_level = 1 optimizer_search_depth = 62 optimizer_selectivity_sampling_limit = 100 optimizer_switch = index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=off,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off optimizer_trace = enabled=off optimizer_trace_max_mem_size = 1048576 optimizer_use_condition_selectivity = 4 performance_schema = ON performance_schema_accounts_size = -1 performance_schema_digests_size = 10000 performance_schema_events_stages_history_long_size = 10000 performance_schema_events_stages_history_size = 10 performance_schema_events_statements_history_long_size = 10000 performance_schema_events_statements_history_size = 10 performance_schema_events_transactions_history_long_size = 10000 performance_schema_events_transactions_history_size = 10 performance_schema_events_waits_history_long_size = 10000 performance_schema_events_waits_history_size = 10 performance_schema_hosts_size = -1 performance_schema_max_cond_classes = 90 performance_schema_max_cond_instances = -1 performance_schema_max_digest_length = 1024 performance_schema_max_file_classes = 80 performance_schema_max_file_handles = 32768 performance_schema_max_file_instances = -1 performance_schema_max_index_stat = -1 performance_schema_max_memory_classes = 320 performance_schema_max_metadata_locks = -1 performance_schema_max_mutex_classes = 210 performance_schema_max_mutex_instances = -1 performance_schema_max_prepared_statements_instances = -1 performance_schema_max_program_instances = -1 performance_schema_max_rwlock_classes = 50 performance_schema_max_rwlock_instances = -1 performance_schema_max_socket_classes = 10 performance_schema_max_socket_instances = -1 performance_schema_max_sql_text_length = 1024 performance_schema_max_stage_classes = 160 performance_schema_max_statement_classes = 222 performance_schema_max_statement_stack = 10 performance_schema_max_table_handles = -1 performance_schema_max_table_instances = -1 performance_schema_max_table_lock_stat = -1 performance_schema_max_thread_classes = 50 performance_schema_max_thread_instances = -1 performance_schema_session_connect_attrs_size = 512 performance_schema_setup_actors_size = -1 performance_schema_setup_objects_size = -1 performance_schema_users_size = -1 pid_file = /lib/mysql/node-3.pid plugin_dir = /usr/lib64/mysql/plugin/ plugin_maturity = gamma port = 3307 preload_buffer_size = 32768 profiling = OFF profiling_history_size = 15 progress_report_time = 5 protocol_version = 10 proxy_protocol_networks = query_alloc_block_size = 16384 query_cache_limit = 1048576 query_cache_min_res_unit = 4096 query_cache_size = 0 query_cache_strip_comments = OFF query_cache_type = OFF query_cache_wlock_invalidate = OFF query_prealloc_size = 24576 range_alloc_block_size = 4096 read_binlog_speed_limit = 0 read_buffer_size = 131072 read_only = OFF read_rnd_buffer_size = 262144 relay_log = /bin-log/relay-bin relay_log_basename = /bin-log/relay-bin relay_log_index = /bin-log/relay-bin.index relay_log_info_file = relay-log.info relay_log_purge = ON relay_log_recovery = OFF relay_log_space_limit = 0 replicate_annotate_row_events = ON replicate_do_db = replicate_do_table = replicate_events_marked_for_skip = REPLICATE replicate_ignore_db = replicate_ignore_table = replicate_wild_do_table = replicate_wild_ignore_table = report_host = node-3 report_password = report_port = 3307 report_user = require_secure_transport = OFF rowid_merge_buff_size = 8388608 rpl_semi_sync_master_enabled = ON rpl_semi_sync_master_timeout = 604800000 rpl_semi_sync_master_trace_level = 32 rpl_semi_sync_master_wait_no_slave = ON rpl_semi_sync_master_wait_point = AFTER_SYNC rpl_semi_sync_slave_delay_master = OFF rpl_semi_sync_slave_enabled = ON rpl_semi_sync_slave_kill_conn_timeout = 5 rpl_semi_sync_slave_trace_level = 32 secure_auth = ON secure_file_priv = /secure_file_priv/ secure_timestamp = NO server_audit_events = QUERY_DDL,QUERY_DML,QUERY_DCL server_audit_excl_users = server_audit_file_path = /audit-logs/audit.log server_audit_file_rotate_now = OFF server_audit_file_rotate_size = 104857600 server_audit_file_rotations = 999 server_audit_incl_users = server_audit_logging = ON server_audit_mode = 0 server_audit_output_type = file server_audit_query_log_limit = 1024 server_audit_syslog_facility = LOG_USER server_audit_syslog_ident = mysql-server_auditing server_audit_syslog_info = server_audit_syslog_priority = LOG_INFO server_id = 210854902 session_track_schema = ON session_track_state_change = OFF session_track_system_variables = autocommit,character_set_client,character_set_connection,character_set_results,time_zone session_track_transaction_info = OFF simple_password_check_digits = 1 simple_password_check_letters_same_case = 1 simple_password_check_minimal_length = 14 simple_password_check_other_characters = 1 skip_external_locking = ON skip_name_resolve = ON skip_networking = OFF skip_show_database = OFF slave_compressed_protocol = OFF slave_ddl_exec_mode = IDEMPOTENT slave_domain_parallel_threads = 0 slave_exec_mode = STRICT slave_load_tmpdir = slave_max_allowed_packet = 1073741824 slave_net_timeout = 60 slave_parallel_max_queued = 524288 slave_parallel_mode = conservative slave_parallel_threads = 3 slave_parallel_workers = 3 slave_run_triggers_for_rbr = NO slave_skip_errors = OFF slave_sql_verify_checksum = ON slave_transaction_retries = 10 slave_transaction_retry_errors = 1158,1159,1160,1161,1205,1213,1020,1429,2013,12701 slave_transaction_retry_interval = 0 slave_type_conversions = slow_launch_time = 2 slow_query_log = ON slow_query_log_file = slow.log socket = /mysql.sock sort_buffer_size = 2097152 sql_auto_is_null = OFF sql_big_selects = ON sql_buffer_result = OFF sql_if_exists = OFF sql_log_bin = ON sql_log_off = OFF sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sql_notes = ON sql_quote_show_create = ON sql_safe_updates = OFF sql_select_limit = 18446744073709551615 sql_slave_skip_counter = 0 sql_warnings = OFF ssl_ca = //ca.crt ssl_capath = ssl_cert = //server.crt ssl_cipher = AES256-SHA ssl_crl = ssl_crlpath = ssl_key = //server.key standard_compliant_cte = ON storage_engine = InnoDB stored_program_cache = 256 strict_password_validation = OFF sync_binlog = 1 sync_frm = ON sync_master_info = 10000 sync_relay_log = 10000 sync_relay_log_info = 10000 system_time_zone = UTC system_versioning_alter_history = ERROR system_versioning_asof = DEFAULT table_definition_cache = 2000 table_open_cache = 2000 table_open_cache_instances = 8 tcp_keepalive_interval = 0 tcp_keepalive_probes = 0 tcp_keepalive_time = 0 tcp_nodelay = ON thread_cache_size = 256 thread_handling = one-thread-per-connection thread_pool_dedicated_listener = OFF thread_pool_exact_stats = OFF thread_pool_idle_timeout = 60 thread_pool_max_threads = 65536 thread_pool_oversubscribe = 3 thread_pool_prio_kickup_timer = 1000 thread_pool_priority = auto thread_pool_size = 2 thread_pool_stall_limit = 500 thread_stack = 299008 time_format = %H:%i:%s time_zone = SYSTEM tls_version = TLSv1.2,TLSv1.3 tmp_disk_table_size = 10737418240 tmp_memory_table_size = 16777216 tmp_table_size = 16777216 tmpdir = /temp transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 tx_isolation = READ-COMMITTED tx_read_only = OFF unique_checks = ON updatable_views_with_limit = YES use_stat_tables = PREFERABLY_FOR_QUERIES userstat = OFF version = 10.6.18-MariaDB-log version_comment = MariaDB Server version_compile_machine = x86_64 version_compile_os = Linux version_malloc_library = system version_source_revision = 887bb3f73555ff8a50138a580ca8308b9b5c069c version_ssl_library = OpenSSL 1.0.2k-fips 26 Jan 2017 wait_timeout = 28800 wsrep_osu_method = TOI wsrep_sr_store = table wsrep_auto_increment_control = ON wsrep_causal_reads = OFF wsrep_certification_rules = strict wsrep_certify_nonpk = ON wsrep_cluster_address = wsrep_cluster_name = my_wsrep_cluster wsrep_convert_lock_to_trx = OFF wsrep_data_home_dir = // wsrep_dbug_option = wsrep_debug = NONE wsrep_desync = OFF wsrep_dirty_reads = OFF wsrep_drupal_282555_workaround = OFF wsrep_forced_binlog_format = NONE wsrep_gtid_domain_id = 0 wsrep_gtid_mode = OFF wsrep_ignore_apply_errors = 7 wsrep_load_data_splitting = OFF wsrep_log_conflicts = OFF wsrep_max_ws_rows = 0 wsrep_max_ws_size = 2147483647 wsrep_mode = wsrep_mysql_replication_bundle = 0 wsrep_node_address = wsrep_node_incoming_address = AUTO wsrep_node_name = wsrep_notify_cmd = wsrep_on = OFF wsrep_patch_version = wsrep_26.22 wsrep_provider = none wsrep_provider_options = wsrep_recover = OFF wsrep_reject_queries = NONE wsrep_replicate_myisam = OFF wsrep_restart_slave = OFF wsrep_retry_autocommit = 1 wsrep_slave_fk_checks = ON wsrep_slave_uk_checks = OFF wsrep_slave_threads = 1 wsrep_sst_auth = wsrep_sst_donor = wsrep_sst_donor_rejects_queries = OFF wsrep_sst_method = rsync wsrep_sst_receive_address = AUTO wsrep_start_position = 00000000-0000-0000-0000-000000000000:-1 wsrep_strict_ddl = OFF wsrep_sync_wait = 0 wsrep_trx_fragment_size = 0 wsrep_trx_fragment_unit = bytes