+--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | variable_name | variable_value | +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ARIA_PAGECACHE_AGE_THRESHOLD | 300 | | PERFORMANCE_SCHEMA | OFF | | SQL_MODE | STRICT_TRANS_TABLES | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | -1 | | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | -1 | | PERFORMANCE_SCHEMA_MAX_COND_CLASSES | 80 | | PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE | -1 | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | -1 | | PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES | 40 | | INNODB_FLUSH_LOG_AT_TIMEOUT | 1 | | SLAVE_PARALLEL_THREADS | 4 | | INNODB_ENCRYPT_TEMPORARY_TABLES | OFF | | ARIA_PAGE_CHECKSUM | ON | | SLAVE_EXEC_MODE | STRICT | | PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES | -1 | | INNODB_DEFRAGMENT | OFF | | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | -1 | | FT_MIN_WORD_LEN | 4 | | PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES | 200 | | INNODB_STATS_TRANSIENT_SAMPLE_PAGES | 32 | | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE | -1 | | SLOW_LAUNCH_TIME | 2 | | PERFORMANCE_SCHEMA_ACCOUNTS_SIZE | -1 | | PERFORMANCE_SCHEMA_HOSTS_SIZE | -1 | | MAX_STATEMENT_TIME | 0.000000 | | INNODB_ADAPTIVE_HASH_INDEX_PARTS | 8 | | TX_ISOLATION | READ-COMMITTED | | THREAD_POOL_OVERSUBSCRIBE | 3 | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | -1 | | STORAGE_ENGINE | InnoDB | | PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE | -1 | | INNODB_FT_NUM_WORD_OPTIMIZE | 2000 | | INNODB_LOG_CHECKSUMS | ON | | WSREP_DRUPAL_282555_WORKAROUND | OFF | | PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES | 160 | | TMP_MEMORY_TABLE_SIZE | 33554432 | | PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE | 100 | | REPORT_HOST | | | ARIA_PAGECACHE_DIVISION_LIMIT | 100 | | INNODB_SORT_BUFFER_SIZE | 1048576 | | CHARACTER_SET_RESULTS | utf8mb4 | | INNODB_ROLLBACK_SEGMENTS | 128 | | PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE | 100 | | LARGE_FILES_SUPPORT | ON | | NET_READ_TIMEOUT | 30 | | VERSION_MALLOC_LIBRARY | system | | BIND_ADDRESS | 10.56.198.20 | | WSREP_AUTO_INCREMENT_CONTROL | ON | | COLUMN_COMPRESSION_ZLIB_WRAP | OFF | | INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED | OFF | | GTID_BINLOG_STATE | 1-1-5151306696,1-2-5374508360 | | GROUP_CONCAT_MAX_LEN | 1048576 | | SYSTEM_VERSIONING_ALTER_HISTORY | ERROR | | RANGE_ALLOC_BLOCK_SIZE | 4096 | | BINLOG_STMT_CACHE_SIZE | 131072 | | SERVER_AUDIT_INCL_USERS | | | GTID_CURRENT_POS | 1-2-5374508360 | | SIMPLE_PASSWORD_CHECK_DIGITS | 1 | | BINLOG_COMMIT_WAIT_USEC | 100000 | | INNODB_ENCRYPTION_THREADS | 0 | | GTID_STRICT_MODE | ON | | MYISAM_RECOVER_OPTIONS | BACKUP,FORCE | | WSREP_PATCH_VERSION | wsrep_25.24 | | RPL_SEMI_SYNC_MASTER_TIMEOUT | 10000 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | -1 | | LOW_PRIORITY_UPDATES | OFF | | CHARACTER_SET_CONNECTION | utf8mb4 | | REPORT_PASSWORD | | | WSREP_DBUG_OPTION | | | SQL_BIG_SELECTS | ON | | EVENT_SCHEDULER | OFF | | TRANSACTION_ALLOC_BLOCK_SIZE | 8192 | | SYSTEM_VERSIONING_ASOF | DEFAULT | | SERVER_AUDIT_SYSLOG_IDENT | mysql-server_auditing | | SECURE_FILE_PRIV | | | SYNC_FRM | ON | | COLUMN_COMPRESSION_ZLIB_LEVEL | 6 | | COMPLETION_TYPE | NO_CHAIN | | MAX_DIGEST_LENGTH | 1024 | | INNODB_SCRUB_LOG | OFF | | BINLOG_CACHE_SIZE | 262144 | | SERVER_AUDIT_FILE_ROTATE_SIZE | 50000000 | | MAX_BINLOG_SIZE | 268435456 | | INNODB_IO_CAPACITY | 200 | | PERFORMANCE_SCHEMA_DIGESTS_SIZE | -1 | | WSREP_CLUSTER_ADDRESS | | | FT_QUERY_EXPANSION_LIMIT | 20 | | INNODB_PAGE_CLEANERS | 4 | | KEY_CACHE_FILE_HASH_SIZE | 512 | | PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE | -1 | | DELAYED_INSERT_LIMIT | 100 | | INNODB_COMPRESSION_DEFAULT | OFF | | MAX_SP_RECURSION_DEPTH | 0 | | INNODB_AUTOEXTEND_INCREMENT | 64 | | MAX_INSERT_DELAYED_THREADS | 20 | | MYISAM_DATA_POINTER_SIZE | 6 | | AUTOMATIC_SP_PRIVILEGES | ON | | RPL_SEMI_SYNC_SLAVE_DELAY_MASTER | OFF | | CONCURRENT_INSERT | AUTO | | SQL_AUTO_IS_NULL | OFF | | AUTO_INCREMENT_OFFSET | 1 | | ARIA_USED_FOR_TEMP_TABLES | ON | | LOG_QUERIES_NOT_USING_INDEXES | OFF | | 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=on,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=on,mrr_cost_based=on,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 | | JOIN_BUFFER_SIZE | 4194304 | | WSREP_RETRY_AUTOCOMMIT | 1 | | CONNECT_TIMEOUT | 10 | | INNODB_STATUS_OUTPUT_LOCKS | OFF | | LC_MESSAGES_DIR | | | QUERY_PREALLOC_SIZE | 24576 | | TCP_KEEPALIVE_INTERVAL | 0 | | SORT_BUFFER_SIZE | 2097152 | | LARGE_PAGES | OFF | | INNODB_ROLLBACK_ON_TIMEOUT | OFF | | SOCKET | /var/lib/mysql/mysql.sock | | STANDARD_COMPLIANT_CTE | ON | | INIT_SLAVE | | | ARIA_REPAIR_THREADS | 1 | | MAX_CONNECT_ERRORS | 100000 | | JOIN_BUFFER_SPACE_LIMIT | 4194304 | | CHARACTER_SETS_DIR | /var/lib/mysql/share/mysql/charsets/ | | INNODB_FILE_FORMAT | | | IN_PREDICATE_CONVERSION_THRESHOLD | 1000 | | PROGRESS_REPORT_TIME | 5 | | MAX_CONNECTIONS | 15000 | | REPLICATE_WILD_DO_TABLE | | | CHARACTER_SET_SYSTEM | utf8 | | INNODB_COMPRESSION_LEVEL | 6 | | GTID_SLAVE_POS | 1-1-5151306696 | | CHARACTER_SET_SERVER | utf8mb4 | | VERSION_SOURCE_REVISION | 0d55b020e16fb0ab88547a28a22cb58eaa7fb229 | | QUERY_CACHE_WLOCK_INVALIDATE | OFF | | HOST_CACHE_SIZE | 1353 | | CHARACTER_SET_CLIENT | utf8mb4 | | REPLICATE_IGNORE_TABLE | | | OPTIMIZER_USE_CONDITION_SELECTIVITY | 1 | | BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES | OFF | | CHARACTER_SET_FILESYSTEM | binary | | INNODB_STRICT_MODE | ON | | GENERAL_LOG_FILE | /mariadb/bin/logs/db_logs/general_mariadb.log | | INNODB_OPTIMIZE_FULLTEXT_ONLY | OFF | | SYNC_BINLOG | 1 | | WSREP_REJECT_QUERIES | NONE | | MAX_LENGTH_FOR_SORT_DATA | 1024 | | STORED_PROGRAM_CACHE | 256 | | PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES | 50 | | LOG_SLOW_VERBOSITY | innodb,query_plan | | BULK_INSERT_BUFFER_SIZE | 8388608 | | THREAD_POOL_IDLE_TIMEOUT | 60 | | LOWER_CASE_FILE_SYSTEM | OFF | | INNODB_LOCK_SCHEDULE_ALGORITHM | fcfs | | MAX_LONG_DATA_SIZE | 67108864 | | MAX_JOIN_SIZE | 18446744073709551615 | | DEADLOCK_TIMEOUT_LONG | 50000000 | | TABLE_OPEN_CACHE_INSTANCES | 1 | | METADATA_LOCKS_HASH_INSTANCES | 8 | | RELAY_LOG_INFO_FILE | relay-log.info | | DEFAULT_STORAGE_ENGINE | InnoDB | | INNODB_AUTOINC_LOCK_MODE | 2 | | NET_RETRY_COUNT | 10 | | LC_MESSAGES | en_US | | QUERY_CACHE_SIZE | 0 | | INNODB_MAX_PURGE_LAG_WAIT | 4294967295 | | SLAVE_MAX_ALLOWED_PACKET | 1073741824 | | INNODB_BUFFER_POOL_FILENAME | ib_buffer_pool | | INNODB_MAX_PURGE_LAG_DELAY | 0 | | LOG_BIN_COMPRESS_MIN_LEN | 256 | | INNODB_BUFFER_POOL_DUMP_NOW | OFF | | LOCK_WAIT_TIMEOUT | 86400 | | INNODB_BACKGROUND_SCRUB_DATA_INTERVAL | 604800 | | EXPLICIT_DEFAULTS_FOR_TIMESTAMP | OFF | | INNODB_STATUS_OUTPUT | OFF | | LOG_BIN_COMPRESS | OFF | | INNODB_UNDO_LOG_TRUNCATE | OFF | | INNODB_TMPDIR | | | INNODB_ADAPTIVE_HASH_INDEX | ON | | FLUSH | OFF | | INNODB_ENCRYPT_LOG | OFF | | SYNC_MASTER_INFO | 1 | | INNODB_LOG_FILE_SIZE | 536870912 | | COLUMN_COMPRESSION_ZLIB_STRATEGY | DEFAULT_STRATEGY | | SERVER_AUDIT_SYSLOG_PRIORITY | LOG_INFO | | MAX_BINLOG_CACHE_SIZE | 18446744073709547520 | | SSL_CRL | | | PERFORMANCE_SCHEMA_MAX_FILE_CLASSES | 50 | | LOG_WARNINGS | 2 | | MAX_SORT_LENGTH | 1024 | | MAX_SESSION_MEM_USED | 9223372036854775807 | | PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES | 200 | | WSREP_DATA_HOME_DIR | /mariadb/data/ | | ARIA_SORT_BUFFER_SIZE | 268434432 | | INNODB_LOG_COMPRESSED_PAGES | ON | | OLD_PASSWORDS | OFF | | INNODB_DISABLE_SORT_FILE_CACHE | OFF | | NET_WRITE_TIMEOUT | 60 | | INNODB_ENCRYPTION_ROTATION_IOPS | 100 | | DELAY_KEY_WRITE | ON | | HAVE_DYNAMIC_LOADING | YES | | INNODB_TABLE_LOCKS | ON | | WSREP_SST_METHOD | rsync | | QUERY_CACHE_LIMIT | 1048576 | | INNODB_PRINT_ALL_DEADLOCKS | ON | | MAX_DELAYED_THREADS | 20 | | INNODB_STATS_TRADITIONAL | ON | | MAX_USER_CONNECTIONS | 0 | | LOG_SLOW_DISABLED_STATEMENTS | sp | | MULTI_RANGE_COUNT | 256 | | INNODB_MAX_DIRTY_PAGES_PCT | 50.000000 | | LOG_SLOW_SLAVE_STATEMENTS | ON | | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | -1 | | PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES | 10 | | KEY_BUFFER_SIZE | 67108864 | | COLLATION_CONNECTION | utf8mb4_general_ci | | INNODB_INSTANT_ALTER_COLUMN_ALLOWED | add_last | | EXPIRE_LOGS_DAYS | 8 | | RELAY_LOG_RECOVERY | ON | | SYNC_RELAY_LOG | 10000 | | RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE | ON | | INNODB_DEFAULT_ENCRYPTION_KEY_ID | 1 | | BACK_LOG | 128 | | SERVER_AUDIT_OUTPUT_TYPE | file | | FT_MAX_WORD_LEN | 84 | | SKIP_EXTERNAL_LOCKING | ON | | RPL_SEMI_SYNC_SLAVE_KILL_CONN_TIMEOUT | 5 | | SLAVE_NET_TIMEOUT | 10 | | DELAYED_QUEUE_SIZE | 1000 | | INNODB_STATS_SAMPLE_PAGES | 32 | | WSREP_LOAD_DATA_SPLITTING | ON | | THREAD_POOL_PRIORITY | auto | | WSREP_FORCED_BINLOG_FORMAT | NONE | | HAVE_RTREE_KEYS | YES | | PID_FILE | /var/lib/mysql/mariadb.pid | | INNODB_ADAPTIVE_FLUSHING_LWM | 10.000000 | | READ_BUFFER_SIZE | 131072 | | INNODB_DEFRAGMENT_FREQUENCY | 40 | | MIN_EXAMINED_ROW_LIMIT | 0 | | SQL_WARNINGS | OFF | | TMPDIR | /mariadb/tmp | | STRICT_PASSWORD_VALIDATION | OFF | | FLUSH_TIME | 0 | | INNODB_SYNC_ARRAY_SIZE | 1 | | BINLOG_FILE_CACHE_SIZE | 16384 | | WSREP_GTID_DOMAIN_ID | 0 | | THREAD_POOL_MAX_THREADS | 65536 | | THREAD_POOL_STALL_LIMIT | 500 | | WSREP_DESYNC | OFF | | PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES | -1 | | OLD_ALTER_TABLE | DEFAULT | | TX_READ_ONLY | OFF | | SSL_CAPATH | | | INNODB_RANDOM_READ_AHEAD | OFF | | VERSION_COMMENT | MariaDB Server | | SERVER_AUDIT_SYSLOG_INFO | | | MASTER_VERIFY_CHECKSUM | ON | | PORT | 6603 | | RPL_SEMI_SYNC_MASTER_ENABLED | ON | | CHECK_CONSTRAINT_CHECKS | ON | | OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT | 100 | | LOG_BIN_TRUST_FUNCTION_CREATORS | ON | | KEY_CACHE_AGE_THRESHOLD | 300 | | INNODB_MONITOR_DISABLE | | | BINLOG_COMMIT_WAIT_COUNT | 0 | | MYISAM_BLOCK_SIZE | 1024 | | MAX_BINLOG_STMT_CACHE_SIZE | 18446744073709547520 | | PRELOAD_BUFFER_SIZE | 32768 | | ENCRYPT_TMP_FILES | OFF | | OPTIMIZER_PRUNE_LEVEL | 1 | | INNODB_SPIN_WAIT_DELAY | 4 | | HAVE_SSL | DISABLED | | INNODB_STATS_INCLUDE_DELETE_MARKED | OFF | | INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF | | INNODB_DEFRAGMENT_STATS_ACCURACY | 0 | | THREAD_POOL_SIZE | 32 | | INNODB_LOCK_WAIT_TIMEOUT | 180 | | MAX_RELAY_LOG_SIZE | 268435456 | | INNODB_OLD_BLOCKS_TIME | 1000 | | SKIP_NETWORKING | OFF | | WSREP_SST_AUTH | | | PERFORMANCE_SCHEMA_MAX_FILE_HANDLES | 32768 | | VERSION_COMPILE_MACHINE | x86_64 | | INIT_CONNECT | | | INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT | 5 | | TABLE_DEFINITION_CACHE | 16384 | | LOCKED_IN_MEMORY | OFF | | INNODB_STATS_PERSISTENT_SAMPLE_PAGES | 20 | | QUERY_ALLOC_BLOCK_SIZE | 16384 | | DEBUG_NO_THREAD_ALARM | OFF | | INNODB_DISALLOW_WRITES | OFF | | SLAVE_PARALLEL_WORKERS | 4 | | INNODB_PREFIX_INDEX_CLUSTER_OPTIMIZATION | OFF | | INNODB_FLUSHING_AVG_LOOPS | 30 | | THREAD_HANDLING | one-thread-per-connection | | METADATA_LOCKS_CACHE_SIZE | 1024 | | SLAVE_SKIP_ERRORS | OFF | | INNODB_BUFFER_POOL_DUMP_PCT | 25 | | HOSTNAME | x01gppsgdb2a | | INNODB_ENCRYPT_TABLES | OFF | | REPLICATE_DO_TABLE | | | COLLATION_DATABASE | utf8mb4_general_ci | | DATADIR | /mariadb/data/ | | INNODB_MONITOR_ENABLE | | | THREAD_CACHE_SIZE | 8 | | INNODB_LOG_BUFFER_SIZE | 67108864 | | SYSTEM_TIME_ZONE | SGT | | SERVER_AUDIT_EXCL_USERS | | | ARIA_RECOVER_OPTIONS | BACKUP,QUICK | | INNODB_MAX_PURGE_LAG | 0 | | QUERY_CACHE_TYPE | OFF | | MYISAM_MAX_SORT_FILE_SIZE | 9223372036853727232 | | BINLOG_FORMAT | ROW | | INNODB_LRU_SCAN_DEPTH | 1024 | | KEY_CACHE_DIVISION_LIMIT | 100 | | WSREP_LOG_CONFLICTS | OFF | | KEEP_FILES_ON_CREATE | OFF | | OLD_MODE | | | FT_BOOLEAN_SYNTAX | + -><()~*:""&| | | DEFAULT_REGEX_FLAGS | | | SLAVE_DDL_EXEC_MODE | IDEMPOTENT | | HISTOGRAM_TYPE | SINGLE_PREC_HB | | CHARACTER_SET_DATABASE | utf8mb4 | | HAVE_COMPRESS | YES | | DATE_FORMAT | %Y-%m-%d | | INNODB_USE_ATOMIC_WRITES | ON | | MAX_HEAP_TABLE_SIZE | 33554432 | | PROXY_PROTOCOL_NETWORKS | | | INNODB_DOUBLEWRITE | ON | | SLAVE_COMPRESSED_PROTOCOL | OFF | | INNODB_STATS_PERSISTENT | ON | | WSREP_MAX_WS_SIZE | 2147483647 | | DEFAULT_WEEK_FORMAT | 0 | | IGNORE_BUILTIN_INNODB | OFF | | INNODB_CHANGE_BUFFER_MAX_SIZE | 25 | | REPORT_USER | | | INNODB_DEFAULT_ROW_FORMAT | dynamic | | INNODB_DEFRAGMENT_FILL_FACTOR_N_RECS | 20 | | INNODB_USE_NATIVE_AIO | ON | | VERSION_SSL_LIBRARY | OpenSSL 1.0.2k-fips 26 Jan 2017 | | INNODB_IO_CAPACITY_MAX | 2000 | | LOG_ERROR | /mariadb/bin/logs/db_logs/error_mariadb.log | | INNODB_UNDO_TABLESPACES | 0 | | CORE_FILE | ON | | INNODB_BUF_DUMP_STATUS_FREQUENCY | 0 | | NET_BUFFER_LENGTH | 16384 | | DEADLOCK_SEARCH_DEPTH_SHORT | 4 | | TMP_DISK_TABLE_SIZE | 18446744073709551615 | | INNODB_FT_MIN_TOKEN_SIZE | 3 | | OPEN_FILES_LIMIT | 65536 | | INNODB_FT_USER_STOPWORD_TABLE | | | RPL_SEMI_SYNC_MASTER_TRACE_LEVEL | 32 | | SERVER_ID | 2 | | TIME_FORMAT | %H:%i:%s | | ARIA_MAX_SORT_FILE_SIZE | 9223372036853727232 | | PROTOCOL_VERSION | 10 | | INNODB_TEMP_DATA_FILE_PATH | ibtmp1:12M:autoextend | | LOG_SLOW_ADMIN_STATEMENTS | ON | | INNODB_SCRUB_LOG_SPEED | 256 | | RELAY_LOG | /mariadb/bin/logs/relay_logs/relay_log | | ARIA_SYNC_LOG_DIR | NEWFILE | | GENERAL_LOG | OFF | | INNODB_FT_ENABLE_STOPWORD | ON | | WSREP_DEBUG | OFF | | INNODB_BACKGROUND_SCRUB_DATA_CHECK_INTERVAL | 3600 | | SQL_SAFE_UPDATES | OFF | | ARIA_GROUP_COMMIT_INTERVAL | 0 | | SLAVE_TRANSACTION_RETRY_INTERVAL | 0 | | PROFILING_HISTORY_SIZE | 15 | | HAVE_CRYPT | YES | | INNODB_CHANGE_BUFFERING | all | | WSREP_SLAVE_THREADS | 1 | | INNODB_STATS_MODIFIED_COUNTER | 0 | | HAVE_OPENSSL | YES | | BINLOG_OPTIMIZE_THREAD_SCHEDULING | ON | | WSREP_ON | OFF | | ENCRYPT_BINLOG | OFF | | WAIT_TIMEOUT | 600 | | SQL_SELECT_LIMIT | 18446744073709551615 | | HAVE_QUERY_CACHE | YES | | SERVER_AUDIT_FILE_PATH | /mariadb/bin/logs/audit_logs/audit_mariadb.log | | SSL_CA | /etc/mysql/cacert.pem | | SERVER_AUDIT_EVENTS | CONNECT,QUERY_DDL,QUERY_DCL | | WSREP_SST_DONOR_REJECTS_QUERIES | OFF | | INNODB_COMPRESSION_ALGORITHM | zlib | | RELAY_LOG_INDEX | /mariadb/bin/logs/relay_logs/slave_relay_bin.index | | SERVER_AUDIT_QUERY_LOG_LIMIT | 1024 | | GTID_IGNORE_DUPLICATES | OFF | | INNODB_PURGE_THREADS | 4 | | WSREP_NOTIFY_CMD | | | PROFILING | OFF | | WSREP_MAX_WS_ROWS | 0 | | ARIA_PAGECACHE_BUFFER_SIZE | 134217728 | | EXPENSIVE_SUBQUERY_LIMIT | 100 | | SLAVE_TRANSACTION_RETRIES | 10 | | INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN | ON | | RELAY_LOG_BASENAME | /mariadb/bin/logs/relay_logs/relay_log | | SSL_CRLPATH | | | WSREP_CLUSTER_NAME | my_wsrep_cluster | | DEADLOCK_SEARCH_DEPTH_LONG | 15 | | THREAD_CONCURRENCY | 10 | | MRR_BUFFER_SIZE | 262144 | | MAX_RECURSIVE_ITERATIONS | 4294967295 | | INNODB_MAX_DIRTY_PAGES_PCT_LWM | 0.000000 | | RELAY_LOG_SPACE_LIMIT | 0 | | IDLE_WRITE_TRANSACTION_TIMEOUT | 0 | | FOREIGN_KEY_CHECKS | ON | | PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH | 1024 | | SIMPLE_PASSWORD_CHECK_LETTERS_SAME_CASE | 1 | | OLD | OFF | | INNODB_STATS_AUTO_RECALC | ON | | WSREP_NODE_INCOMING_ADDRESS | AUTO | | INNODB_COMMIT_CONCURRENCY | 0 | | AUTO_INCREMENT_INCREMENT | 1 | | INNODB_CONCURRENCY_TICKETS | 5000 | | REPLICATE_DO_DB | | | INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD | 600 | | WSREP_NODE_NAME | x01gppsgdb2a | | INNODB_IDLE_FLUSH_PCT | 100 | | REPLICATE_IGNORE_DB | | | INNODB_FT_SORT_PLL_DEGREE | 2 | | BIG_TABLES | OFF | | SESSION_TRACK_TRANSACTION_INFO | OFF | | RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL | 32 | | INNODB_FILL_FACTOR | 100 | | SLOW_QUERY_LOG | ON | | INNODB_ADAPTIVE_FLUSHING | ON | | WSREP_START_POSITION | 00000000-0000-0000-0000-000000000000:-1 | | INNODB_FILE_PER_TABLE | ON | | GTID_BINLOG_POS | 1-2-5374508360 | | EXTRA_PORT | 0 | | MAX_WRITE_LOCK_COUNT | 4294967295 | | ARIA_BLOCK_SIZE | 8192 | | LOG_OUTPUT | FILE | | THREAD_POOL_PRIO_KICKUP_TIMER | 1000 | | EXTRA_MAX_CONNECTIONS | 1 | | INNODB_DATA_HOME_DIR | | | SQL_SLAVE_SKIP_COUNTER | 0 | | SIMPLE_PASSWORD_CHECK_OTHER_CHARACTERS | 1 | | WSREP_RESTART_SLAVE | OFF | | INNODB_WRITE_IO_THREADS | 8 | | TABLE_OPEN_CACHE | 16384 | | INNODB_BUFFER_POOL_INSTANCES | 8 | | LC_TIME_NAMES | en_US | | INNODB_UNDO_DIRECTORY | ./ | | GTID_DOMAIN_ID | 1 | | COLLATION_SERVER | utf8mb4_general_ci | | JOIN_CACHE_LEVEL | 6 | | INNODB_FT_RESULT_CACHE_LIMIT | 2000000000 | | TMP_TABLE_SIZE | 33554432 | | WSREP_SYNC_WAIT | 0 | | COLUMN_COMPRESSION_THRESHOLD | 100 | | WSREP_CONVERT_LOCK_TO_TRX | OFF | | LOG_DISABLED_STATEMENTS | sp | | INNODB_ENCRYPTION_ROTATE_KEY_AGE | 1 | | DIV_PRECISION_INCREMENT | 4 | | LICENSE | GPL | | DATETIME_FORMAT | %Y-%m-%d %H:%i:%s | | FT_STOPWORD_FILE | (built-in) | | TIMED_MUTEXES | OFF | | INNODB_READ_AHEAD_THRESHOLD | 56 | | QUERY_CACHE_STRIP_COMMENTS | OFF | | INNODB_READ_ONLY | OFF | | SQL_BUFFER_RESULT | OFF | | INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED | OFF | | DEFAULT_TMP_STORAGE_ENGINE | | | INNODB_MONITOR_RESET_ALL | | | BINLOG_ANNOTATE_ROW_EVENTS | ON | | SERVER_AUDIT_MODE | 0 | | LOG_BIN_INDEX | /mariadb/bin/logs/bin_logs/master_bin_log.index | | INNODB_STATS_METHOD | nulls_equal | | REPLICATE_WILD_IGNORE_TABLE | | | SSL_CIPHER | | | SSL_CERT | /etc/mysql/server-cert.pem | | LOG_SLOW_RATE_LIMIT | 1 | | WSREP_SST_RECEIVE_ADDRESS | AUTO | | INNODB_THREAD_CONCURRENCY | 0 | | UNIQUE_CHECKS | ON | | INNODB_BACKGROUND_SCRUB_DATA_UNCOMPRESSED | OFF | | WSREP_PROVIDER | none | | INNODB_BUFFER_POOL_SIZE | 103079215104 | | SESSION_TRACK_SCHEMA | ON | | LOCAL_INFILE | ON | | INNODB_BUFFER_POOL_LOAD_NOW | OFF | | IDLE_TRANSACTION_TIMEOUT | 0 | | SIMPLE_PASSWORD_CHECK_MINIMAL_LENGTH | 10 | | ROWID_MERGE_BUFF_SIZE | 8388608 | | BINLOG_CHECKSUM | CRC32 | | WSREP_CAUSAL_READS | OFF | | INNODB_PAGE_SIZE | 16384 | | ARIA_ENCRYPT_TABLES | OFF | | SLAVE_TYPE_CONVERSIONS | | | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE | -1 | | REPORT_PORT | 6603 | | RPL_SEMI_SYNC_MASTER_WAIT_POINT | AFTER_COMMIT | | KEY_CACHE_BLOCK_SIZE | 1024 | | SERVER_AUDIT_SYSLOG_FACILITY | LOG_USER | | MAX_TMP_TABLES | 32 | | INNODB_FLUSH_LOG_AT_TRX_COMMIT | 1 | | SQL_NOTES | ON | | WSREP_PROVIDER_OPTIONS | | | SQL_LOG_OFF | OFF | | MAX_PREPARED_STMT_COUNT | 16382 | | INNODB_BUFFER_POOL_CHUNK_SIZE | 134217728 | | WSREP_SST_DONOR | | | SLOW_QUERY_LOG_FILE | /mariadb/bin/logs/db_logs/slow_query_mariadb.log | | INNODB_COMPRESSION_PAD_PCT_MAX | 50 | | SYNC_RELAY_LOG_INFO | 10000 | | SLAVE_SQL_VERIFY_CHECKSUM | ON | | INNODB_BUFFER_POOL_LOAD_ABORT | OFF | | SERVER_AUDIT_FILE_ROTATE_NOW | OFF | | INIT_FILE | | | DELAYED_INSERT_TIMEOUT | 300 | | INTERACTIVE_TIMEOUT | 600 | | INNODB_BUFFER_POOL_LOAD_AT_STARTUP | ON | | INNODB_CMP_PER_INDEX_ENABLED | OFF | | SLAVE_LOAD_TMPDIR | /mariadb/tmp | | INNODB_ONLINE_ALTER_LOG_MAX_SIZE | 134217728 | | LOG_TC_SIZE | 24576 | | UPDATABLE_VIEWS_WITH_LIMIT | YES | | MYISAM_STATS_METHOD | NULLS_UNEQUAL | | ARIA_FORCE_START_AFTER_RECOVERY_FAILURES | 0 | | LOG_BIN_BASENAME | /mariadb/bin/logs/bin_logs/bin_log | | INNODB_FLUSH_METHOD | fsync | | SLAVE_RUN_TRIGGERS_FOR_RBR | NO | | WSREP_REPLICATE_MYISAM | OFF | | MYISAM_MMAP_SIZE | 18446744073709551615 | | SQL_QUOTE_SHOW_CREATE | ON | | INNODB_STATS_ON_METADATA | OFF | | WSREP_NODE_ADDRESS | | | ARIA_CHECKPOINT_INTERVAL | 30 | | WSREP_CERTIFICATION_RULES | strict | | INNODB_FORCE_RECOVERY | 0 | | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | -1 | | WSREP_CERTIFY_NONPK | ON | | RPL_SEMI_SYNC_SLAVE_ENABLED | ON | | BINLOG_ROW_IMAGE | FULL | | MYISAM_USE_MMAP | OFF | | ENCRYPT_TMP_DISK_TABLES | OFF | | MYISAM_SORT_BUFFER_SIZE | 67108864 | | INNODB_FT_CACHE_SIZE | 8000000 | | INNODB_OLD_BLOCKS_PCT | 37 | | LOWER_CASE_TABLE_NAMES | 1 | | VERSION | 10.3.28-MariaDB-log | | INNODB_LOG_OPTIMIZE_DDL | OFF | | LOG_SLAVE_UPDATES | ON | | INNODB_FLUSH_SYNC | ON | | SLAVE_PARALLEL_MODE | conservative | | WSREP_GTID_MODE | OFF | | SKIP_SHOW_DATABASE | OFF | | INNODB_OPEN_FILES | 2048 | | AUTOCOMMIT | ON | | INNODB_LOG_FILES_IN_GROUP | 2 | | EQ_RANGE_INDEX_DIVE_LIMIT | 0 | | PLUGIN_DIR | /var/lib/mysql/lib64/mysql/plugin/ | | SKIP_NAME_RESOLVE | ON | | INNODB_DEADLOCK_DETECT | ON | | INNODB_CHECKSUMS | ON | | INNODB_FT_MAX_TOKEN_SIZE | 84 | | TRANSACTION_PREALLOC_SIZE | 4096 | | INNODB_FT_SERVER_STOPWORD_TABLE | | | VERSION_COMPILE_OS | Linux | | WSREP_SLAVE_FK_CHECKS | ON | | INNODB_LOG_GROUP_HOME_DIR | /mariadb/data/ | | KEY_CACHE_SEGMENTS | 0 | | INNODB_LARGE_PREFIX | | | INNODB_DEFRAGMENT_N_PAGES | 7 | | BASEDIR | /var/lib/mysql | | 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 | | IDLE_READONLY_TRANSACTION_TIMEOUT | 0 | | LOG_BIN | ON | | REPLICATE_EVENTS_MARKED_FOR_SKIP | FILTER_ON_MASTER | | INNODB_DATA_FILE_PATH | ibdata1:12M:autoextend | | SSL_KEY | /etc/mysql/server-key.pem | | MAX_ERROR_COUNT | 64 | | WSREP_OSU_METHOD | TOI | | SECURE_AUTH | ON | | MYISAM_REPAIR_THREADS | 1 | | HAVE_GEOMETRY | YES | | INNODB_FT_AUX_TABLE | | | ARIA_PAGECACHE_FILE_HASH_SIZE | 512 | | WSREP_MYSQL_REPLICATION_BUNDLE | 0 | | INNODB_LOG_WRITE_AHEAD_SIZE | 8192 | | SLAVE_DOMAIN_PARALLEL_THREADS | 0 | | SLAVE_PARALLEL_MAX_QUEUED | 67108864 | | ENFORCE_STORAGE_ENGINE | | | SLAVE_TRANSACTION_RETRY_ERRORS | 1213,1205 | | INNODB_FT_ENABLE_DIAG_PRINT | OFF | | THREAD_STACK | 262144 | | HAVE_SYMLINK | DISABLED | | INNODB_CHECKSUM_ALGORITHM | crc32 | | INNODB_FORCE_LOAD_CORRUPTED | OFF | | ARIA_LOG_PURGE_TYPE | immediate | | INNODB_FLUSH_NEIGHBORS | 1 | | MYSQL56_TEMPORAL_FORMAT | ON | | SECURE_TIMESTAMP | NO | | GTID_POS_AUTO_ENGINES | | | SERVER_AUDIT_LOGGING | ON | | DEADLOCK_TIMEOUT_SHORT | 10000 | | INNODB_THREAD_SLEEP_DELAY | 10000 | | TCP_KEEPALIVE_PROBES | 0 | | WSREP_RECOVER | OFF | | ARIA_GROUP_COMMIT | none | | SESSION_TRACK_STATE_CHANGE | OFF | | LONG_QUERY_TIME | 1.000000 | | MAX_ALLOWED_PACKET | 67108864 | | TIME_ZONE | SYSTEM | | MAX_SEEKS_FOR_KEY | 4294967295 | | USERSTAT | ON | | INNODB_REPLICATION_DELAY | 0 | | SESSION_TRACK_SYSTEM_VARIABLES | autocommit,character_set_client,character_set_connection,character_set_results,time_zone | | QUERY_CACHE_MIN_RES_UNIT | 4096 | | INNODB_PURGE_BATCH_SIZE | 300 | | INNODB_FORCE_PRIMARY_KEY | OFF | | HISTOGRAM_SIZE | 0 | | RELAY_LOG_PURGE | ON | | READ_BINLOG_SPEED_LIMIT | 0 | | INNODB_FT_TOTAL_CACHE_SIZE | 640000000 | | REPLICATE_ANNOTATE_ROW_EVENTS | ON | | LARGE_PAGE_SIZE | 0 | | USE_STAT_TABLES | NEVER | | READ_RND_BUFFER_SIZE | 262144 | | INNODB_FAST_SHUTDOWN | 1 | | INNODB_PURGE_RSEG_TRUNCATE_FREQUENCY | 128 | | ARIA_LOG_FILE_SIZE | 1073741824 | | INNODB_SYNC_SPIN_LOOPS | 30 | | OPTIMIZER_SEARCH_DEPTH | 0 | | TCP_KEEPALIVE_TIME | 0 | | IGNORE_DB_DIRS | lost+found | | READ_ONLY | ON | | INNODB_MONITOR_RESET | | | INNODB_READ_IO_THREADS | 8 | | HAVE_PROFILING | YES | | SERVER_AUDIT_FILE_ROTATIONS | 100 | | WSREP_SLAVE_UK_CHECKS | OFF | | INNODB_MAX_UNDO_LOG_SIZE | 10485760 | | ARIA_STATS_METHOD | nulls_unequal | | WSREP_DIRTY_READS | OFF | | INNODB_ADAPTIVE_MAX_SLEEP_DELAY | 150000 | | INNODB_DEFRAGMENT_FILL_FACTOR | 0.900000 | | INNODB_VERSION | 10.3.28 | | ALTER_ALGORITHM | DEFAULT | | INNODB_UNDO_LOGS | 128 | | SQL_LOG_BIN | ON | | ARIA_CHECKPOINT_LOG_ACTIVITY | 1048576 | | PERFORMANCE_SCHEMA_USERS_SIZE | -1 | | PLUGIN_MATURITY | gamma | +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+