🗄️ Database Browser © Nasirudin
Databases
›
information_schema
›
GLOBAL_VARIABLES
📋 Copy ke Clipboard (Excel Format)
VARIABLE_NAME
VARIABLE_VALUE
LICENSE
GPL
PERFORMANCE_SCHEMA
OFF
SQL_MODE
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
BINLOG_FORMAT
MIXED
GTID_BINLOG_STATE
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE
-1
DELAYED_INSERT_LIMIT
100
PERFORMANCE_SCHEMA_MAX_COND_CLASSES
90
WSREP_TRX_FRAGMENT_SIZE
0
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES
-1
INNODB_FLUSH_LOG_AT_TIMEOUT
1
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES
-1
INNODB_ENCRYPT_TEMPORARY_TABLES
OFF
PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES
-1
PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES
-1
MAX_STATEMENT_TIME
0,00
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES
-1
SSL_CERT
LONG_QUERY_TIME
10,00
INNODB_STATS_TRANSIENT_SAMPLE_PAGES
8
HAVE_OPENSSL
YES
SLOW_LAUNCH_TIME
2
PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES
50
LOG_SLOW_MAX_WARNINGS
10
COLLATION_CONNECTION
utf8mb4_general_ci
INNODB_ADAPTIVE_HASH_INDEX_PARTS
8
PERFORMANCE_SCHEMA_ACCOUNTS_SIZE
-1
THREAD_POOL_OVERSUBSCRIBE
3
LOG_QUERIES_NOT_USING_INDEXES
OFF
HAVE_RTREE_KEYS
YES
EVENT_SCHEDULER
OFF
INNODB_FT_NUM_WORD_OPTIMIZE
2.000
PERFORMANCE_SCHEMA_MAX_INDEX_STAT
-1
WSREP_DRUPAL_282555_WORKAROUND
OFF
PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES
210
TMP_MEMORY_TABLE_SIZE
16.777.216
MAX_DELAYED_THREADS
20
REPORT_HOST
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE
-1
INNODB_SORT_BUFFER_SIZE
1.048.576
PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES
160
LOG_SLOW_MIN_EXAMINED_ROW_LIMIT
0
BIND_ADDRESS
127.0.0.1
LARGE_FILES_SUPPORT
ON
PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE
-1
OPTIMIZER_PRUNE_LEVEL
2
PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH
1.024
WSREP_AUTO_INCREMENT_CONTROL
ON
ANALYZE_MAX_LENGTH
4.294.967.295
BACK_LOG
80
DELAYED_QUEUE_SIZE
1.000
GROUP_CONCAT_MAX_LEN
1.048.576
BINLOG_FILE_CACHE_SIZE
16.384
RANGE_ALLOC_BLOCK_SIZE
4.096
PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE
-1
GTID_CURRENT_POS
INNODB_FAST_SHUTDOWN
1
INNODB_TMPDIR
CHARACTER_SETS_DIR
/usr/share/mysql/charsets/
INNODB_ENCRYPTION_THREADS
0
CHARACTER_SET_RESULTS
utf8mb4
MYISAM_RECOVER_OPTIONS
BACKUP,QUICK
PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE
-1
RPL_SEMI_SYNC_MASTER_TIMEOUT
10.000
SYSTEM_VERSIONING_ALTER_HISTORY
ERROR
LOW_PRIORITY_UPDATES
OFF
EXPIRE_LOGS_DAYS
10,00
REPORT_PASSWORD
REPORT_PORT
3.306
WSREP_DBUG_OPTION
PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES
-1
SQL_BIG_SELECTS
ON
FT_MAX_WORD_LEN
84
TRANSACTION_ALLOC_BLOCK_SIZE
8.192
LOG_SLOW_QUERY_TIME
10,00
INNODB_FLUSHING_AVG_LOOPS
30
MAX_HEAP_TABLE_SIZE
16.777.216
SYNC_FRM
ON
CHARACTER_SET_CONNECTION
utf8mb4
BINLOG_ROW_METADATA
NO_LOG
MAX_DIGEST_LENGTH
1.024
ARIA_PAGE_CHECKSUM
ON
COLUMN_COMPRESSION_ZLIB_WRAP
OFF
INNODB_IO_CAPACITY_MAX
2.000
FT_QUERY_EXPANSION_LIMIT
20
INNODB_IO_CAPACITY
200
WSREP_LOAD_DATA_SPLITTING
OFF
WSREP_CLUSTER_ADDRESS
PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE
-1
INNODB_FLUSH_SYNC
ON
MAX_CONNECTIONS
151
LOG_WARNINGS
2
KEY_BUFFER_SIZE
134.217.728
INNODB_COMPRESSION_DEFAULT
OFF
LOWER_CASE_FILE_SYSTEM
OFF
INNODB_AUTOEXTEND_INCREMENT
64
SLOW_QUERY_LOG_FILE
ayam-mrothol-dev-ubuntu-s-1vcpu-512mb-10gb-sgp1-slow.log
MYISAM_DATA_POINTER_SIZE
6
COLUMN_COMPRESSION_ZLIB_LEVEL
6
RPL_SEMI_SYNC_SLAVE_DELAY_MASTER
OFF
GENERAL_LOG_FILE
ayam-mrothol-dev-ubuntu-s-1vcpu-512mb-10gb-sgp1.log
SQL_AUTO_IS_NULL
OFF
AUTOMATIC_SP_PRIVILEGES
ON
ARIA_USED_FOR_TEMP_TABLES
ON
CONCURRENT_INSERT
AUTO
SLAVE_TRANSACTION_RETRY_INTERVAL
0
PERFORMANCE_SCHEMA_DIGESTS_SIZE
-1
WSREP_RETRY_AUTOCOMMIT
1
PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES
-1
INNODB_STATUS_OUTPUT_LOCKS
OFF
KEY_CACHE_FILE_HASH_SIZE
512
QUERY_PREALLOC_SIZE
32.768
JOIN_BUFFER_SIZE
262.144
SORT_BUFFER_SIZE
2.097.152
EXPLICIT_DEFAULTS_FOR_TIMESTAMP
ON
INNODB_ROLLBACK_ON_TIMEOUT
OFF
SLAVE_MAX_ALLOWED_PACKET
1.073.741.824
STANDARD_COMPLIANT_CTE
ON
DELAY_KEY_WRITE
ON
ARIA_REPAIR_THREADS
1
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE
-1
JOIN_BUFFER_SPACE_LIMIT
2.097.152
CONNECT_TIMEOUT
10
INNODB_BUFFER_POOL_LOAD_ABORT
OFF
LC_MESSAGES_DIR
PROGRESS_REPORT_TIME
5
RELAY_LOG_SPACE_LIMIT
0
REPLICATE_WILD_DO_TABLE
LARGE_PAGES
OFF
ARIA_FORCE_START_AFTER_RECOVERY_FAILURES
0
TMP_DISK_TABLE_SIZE
9.223.372.036.854.775.807
CHARACTER_SET_SERVER
utf8mb4
MAX_USER_CONNECTIONS
0
INIT_SLAVE
THREAD_POOL_EXACT_STATS
OFF
BINLOG_ALTER_TWO_PHASE
OFF
INNODB_READ_ONLY_COMPRESSED
OFF
MAX_BINLOG_SIZE
1.073.741.824
BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
OFF
SLAVE_COMPRESSED_PROTOCOL
OFF
INNODB_STRICT_MODE
ON
CORE_FILE
OFF
TIME_ZONE
SYSTEM
WSREP_NODE_ADDRESS
WSREP_REJECT_QUERIES
NONE
WSREP_DEBUG
NONE
INNODB_TABLE_LOCKS
ON
LOCK_WAIT_TIMEOUT
86.400
LOG_SLOW_VERBOSITY
PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE
-1
THREAD_POOL_IDLE_TIMEOUT
60
BULK_INSERT_BUFFER_SIZE
8.388.608
WSREP_SLAVE_THREADS
1
CHARACTER_SET_CLIENT
utf8mb4
PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT
-1
SLAVE_PARALLEL_THREADS
0
DISCONNECT_ON_EXPIRED_PASSWORD
OFF
KEY_CACHE_DIVISION_LIMIT
100
SYSTEM_VERSIONING_ASOF
DEFAULT
INNODB_AUTOINC_LOCK_MODE
1
WSREP_CONVERT_LOCK_TO_TRX
OFF
LC_MESSAGES
en_US
WSREP_SST_DONOR_REJECTS_QUERIES
OFF
INNODB_MAX_PURGE_LAG_WAIT
4.294.967.295
LOG_SLOW_ADMIN_STATEMENTS
ON
INNODB_BUFFER_POOL_FILENAME
ib_buffer_pool
PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES
50
INNODB_MAX_PURGE_LAG_DELAY
0
RPL_SEMI_SYNC_SLAVE_KILL_CONN_TIMEOUT
5
INNODB_BUFFER_POOL_DUMP_NOW
OFF
SSL_CA
INNODB_SYNC_SPIN_LOOPS
30
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE
-1
INNODB_STATUS_OUTPUT
OFF
INNODB_BUFFER_POOL_CHUNK_SIZE
0
INNODB_UNDO_LOG_TRUNCATE
OFF
SESSION_TRACK_STATE_CHANGE
OFF
INNODB_ADAPTIVE_HASH_INDEX
OFF
SQL_SAFE_UPDATES
OFF
INNODB_ENCRYPT_LOG
OFF
MAX_PASSWORD_ERRORS
4.294.967.295
ALLOW_SUSPICIOUS_UDFS
OFF
NET_RETRY_COUNT
10
STORED_PROGRAM_CACHE
256
NET_WRITE_TIMEOUT
60
SSL_CRL
NOTE_VERBOSITY
basic,explain
INNODB_DEADLOCK_REPORT
full
OPTIMIZER_EXTRA_PRUNING_DEPTH
8
MAX_SESSION_MEM_USED
9.223.372.036.854.775.807
SECURE_FILE_PRIV
SYSTEM_VERSIONING_INSERT_HISTORY
OFF
COMPLETION_TYPE
NO_CHAIN
INNODB_FORCE_RECOVERY
0
LOG_BIN_COMPRESS
OFF
INNODB_DISABLE_SORT_FILE_CACHE
OFF
HAVE_PROFILING
YES
INNODB_ENCRYPTION_ROTATION_IOPS
100
OPTIMIZER_USE_CONDITION_SELECTIVITY
4
HAVE_DYNAMIC_LOADING
YES
THREAD_HANDLING
one-thread-per-connection
WSREP_SST_METHOD
rsync
MAX_LENGTH_FOR_SORT_DATA
1.024
INNODB_PRINT_ALL_DEADLOCKS
OFF
FLUSH
OFF
INNODB_STATS_TRADITIONAL
ON
CHARACTER_SET_FILESYSTEM
binary
LOG_SLOW_DISABLED_STATEMENTS
sp
COLUMN_COMPRESSION_ZLIB_STRATEGY
DEFAULT_STRATEGY
INNODB_MAX_DIRTY_PAGES_PCT
90,00
MAX_BINLOG_CACHE_SIZE
9.223.372.036.854.775.807
LOG_SLOW_QUERY
OFF
PERFORMANCE_SCHEMA_MAX_FILE_CLASSES
80
SKIP_GRANT_TABLES
OFF
MAX_SORT_LENGTH
1.024
INNODB_INSTANT_ALTER_COLUMN_ALLOWED
add_drop_reorder
PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS
-1
VERSION_COMPILE_MACHINE
x86_64
SYNC_RELAY_LOG
10.000
PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES
10
INNODB_DEFAULT_ENCRYPTION_KEY_ID
1
INNODB_MAX_UNDO_LOG_SIZE
10.485.760
SLAVE_EXEC_MODE
STRICT
MAX_ROWID_FILTER_SIZE
131.072
OLD
OFF
SLAVE_NET_TIMEOUT
60
QUERY_CACHE_LIMIT
1.048.576
PLUGIN_DIR
/usr/lib/mysql/plugin/
MAX_INSERT_DELAYED_THREADS
20
THREAD_POOL_PRIORITY
auto
BIG_TABLES
OFF
INNODB_BUFFER_POOL_SIZE_AUTO_MIN
134.217.728
PERFORMANCE_SCHEMA_MAX_STATEMENT_STACK
10
INNODB_ADAPTIVE_FLUSHING_LWM
10,00
COLLATION_SERVER
utf8mb4_general_ci
INNODB_DEFRAGMENT_FREQUENCY
40
PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES
-1
INNODB_LINUX_AIO
auto
FT_STOPWORD_FILE
(built-in)
STRICT_PASSWORD_VALIDATION
ON
RPL_SEMI_SYNC_MASTER_ENABLED
OFF
RELAY_LOG_RECOVERY
OFF
CHARACTER_SET_SYSTEM
utf8mb3
WSREP_GTID_DOMAIN_ID
0
HAVE_CRYPT
YES
THREAD_POOL_STALL_LIMIT
500
QUERY_CACHE_SIZE
1.048.576
PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES
-1
QUERY_ALLOC_BLOCK_SIZE
32.768
TX_READ_ONLY
OFF
SQL_NOTES
ON
INNODB_RANDOM_READ_AHEAD
OFF
METADATA_LOCKS_HASH_INSTANCES
8
TCP_KEEPALIVE_PROBES
0
BINLOG_COMMIT_WAIT_USEC
100.000
PORT
3.306
READ_BUFFER_SIZE
131.072
REPLICATE_REWRITE_DB
PERFORMANCE_SCHEMA_MAX_FILE_HANDLES
32.768
LOG_BIN_TRUST_FUNCTION_CREATORS
OFF
PID_FILE
/run/mysqld/mysqld.pid
INNODB_MONITOR_DISABLE
TLS_VERSION
TLSv1.2,TLSv1.3
MYISAM_BLOCK_SIZE
1.024
MIN_EXAMINED_ROW_LIMIT
0
MAX_BINLOG_STMT_CACHE_SIZE
9.223.372.036.854.775.807
HISTOGRAM_SIZE
254
ENCRYPT_TMP_FILES
OFF
FLUSH_TIME
0
INNODB_SPIN_WAIT_DELAY
4
INNODB_STATS_INCLUDE_DELETE_MARKED
OFF
RPL_SEMI_SYNC_MASTER_TRACE_LEVEL
32
INNODB_DEFRAGMENT_STATS_ACCURACY
0
THREAD_POOL_MAX_THREADS
65.536
INNODB_LOCK_WAIT_TIMEOUT
50
SQL_BUFFER_RESULT
OFF
INNODB_OLD_BLOCKS_TIME
1.000
OLD_ALTER_TABLE
DEFAULT
PERFORMANCE_SCHEMA_MAX_MEMORY_CLASSES
320
WSREP_ALLOWLIST
CHECK_CONSTRAINT_CHECKS
ON
INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT
5
KEY_CACHE_AGE_THRESHOLD
300
LOCKED_IN_MEMORY
OFF
MASTER_VERIFY_CHECKSUM
OFF
INNODB_LRU_FLUSH_SIZE
0
TMP_TABLE_SIZE
16.777.216
WSREP_MYSQL_REPLICATION_BUNDLE
0
RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE
ON
INNODB_PREFIX_INDEX_CLUSTER_OPTIMIZATION
ON
GTID_SLAVE_POS
THREAD_POOL_DEDICATED_LISTENER
OFF
INNODB_LOG_FILE_BUFFERING
OFF
HAVE_QUERY_CACHE
YES
INNODB_BUFFER_POOL_DUMP_PCT
25
AUTO_INCREMENT_OFFSET
1
INNODB_ENCRYPT_TABLES
OFF
INNODB_FT_ENABLE_STOPWORD
ON
COLLATION_DATABASE
utf8mb4_general_ci
INNODB_MONITOR_ENABLE
LOG_BIN
OFF
INNODB_LOG_BUFFER_SIZE
16.777.216
BINLOG_ROW_IMAGE
FULL
HOST_CACHE_SIZE
279
SKIP_NETWORKING
OFF
INNODB_MAX_PURGE_LAG
0
WSREP_ON
OFF
MYISAM_MAX_SORT_FILE_SIZE
9.223.372.036.853.727.232
INIT_CONNECT
INNODB_LRU_SCAN_DEPTH
1.536
TABLE_DEFINITION_CACHE
400
WSREP_LOG_CONFLICTS
OFF
INNODB_FT_CACHE_SIZE
8.000.000
OLD_MODE
UTF8_IS_UTF8MB3
WSREP_SLAVE_UK_CHECKS
OFF
DEFAULT_REGEX_FLAGS
SLAVE_PARALLEL_WORKERS
0
HISTOGRAM_TYPE
DOUBLE_PREC_HB
BASEDIR
/usr
HAVE_COMPRESS
YES
METADATA_LOCKS_CACHE_SIZE
1.024
INNODB_USE_ATOMIC_WRITES
ON
PROXY_PROTOCOL_NETWORKS
HOSTNAME
ayam-mrothol-dev-ubuntu-s-1vcpu-512mb-10gb-sgp1
INNODB_DOUBLEWRITE
ON
DEFAULT_PASSWORD_LIFETIME
0
INNODB_STATS_PERSISTENT
ON
PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES
222
DEFAULT_WEEK_FORMAT
0
THREAD_CACHE_SIZE
151
INNODB_CHANGE_BUFFER_MAX_SIZE
25
LOG_BIN_COMPRESS_MIN_LEN
256
INNODB_DEFAULT_ROW_FORMAT
dynamic
LOG_SLOW_SLAVE_STATEMENTS
ON
INNODB_USE_NATIVE_AIO
ON
OPTIMIZER_TRACE_MAX_MEM_SIZE
1.048.576
SESSION_TRACK_SCHEMA
ON
BINLOG_CACHE_SIZE
32.768
INNODB_UNDO_TABLESPACES
0
PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH
1.024
INNODB_BUF_DUMP_STATUS_FREQUENCY
0
PERFORMANCE_SCHEMA_HOSTS_SIZE
-1
DEADLOCK_SEARCH_DEPTH_SHORT
4
PRELOAD_BUFFER_SIZE
32.768
INNODB_FT_MIN_TOKEN_SIZE
3
PERFORMANCE_SCHEMA_USERS_SIZE
-1
INNODB_FT_USER_STOPWORD_TABLE
SLAVE_DDL_EXEC_MODE
IDEMPOTENT
SERVER_ID
1
CHARACTER_SET_DATABASE
utf8mb4
ARIA_MAX_SORT_FILE_SIZE
9.223.372.036.853.727.232
DATE_FORMAT
%Y-%m-%d
INNODB_TEMP_DATA_FILE_PATH
ibtmp1:12M:autoextend
LOG_SLOW_QUERY_FILE
ayam-mrothol-dev-ubuntu-s-1vcpu-512mb-10gb-sgp1-slow.log
USE_STAT_TABLES
PREFERABLY_FOR_QUERIES
INNODB_ALTER_COPY_BULK
ON
BINLOG_STMT_CACHE_SIZE
32.768
INNODB_LOG_FILE_MMAP
OFF
GENERAL_LOG
OFF
INNODB_STATS_PERSISTENT_SAMPLE_PAGES
20
MAX_CONNECT_ERRORS
100
ARIA_GROUP_COMMIT_INTERVAL
0
REPLICATE_DO_TABLE
PROFILING_HISTORY_SIZE
15
TX_ISOLATION
REPEATABLE-READ
INNODB_CHANGE_BUFFERING
none
HAVE_GEOMETRY
YES
INNODB_STATS_MODIFIED_COUNTER
0
RELAY_LOG
BINLOG_OPTIMIZE_THREAD_SCHEDULING
ON
SLOW_QUERY_LOG
OFF
ENCRYPT_BINLOG
OFF
OPTIMIZER_ADJUST_SECONDARY_KEY_COSTS
fix_reuse_range_for_ref,fix_card_multiplier
SQL_SELECT_LIMIT
9.223.372.036.854.775.807
INNODB_FT_SERVER_STOPWORD_TABLE
ARIA_STATS_METHOD
nulls_unequal
GTID_DOMAIN_ID
0
OPEN_FILES_LIMIT
32.183
BINLOG_EXPIRE_LOGS_SECONDS
864.000
INNODB_COMPRESSION_ALGORITHM
zlib
MAX_RELAY_LOG_SIZE
1.073.741.824
PLUGIN_MATURITY
gamma
MAX_RECURSIVE_ITERATIONS
1.000
INNODB_PURGE_THREADS
4
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=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
PROFILING
OFF
OPTIMIZER_JOIN_LIMIT_PREF_RATIO
0
ARIA_PAGECACHE_BUFFER_SIZE
134.217.728
MYISAM_MMAP_SIZE
9.223.372.036.854.775.807
EXPENSIVE_SUBQUERY_LIMIT
100
WSREP_IGNORE_APPLY_ERRORS
7
INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN
ON
NET_BUFFER_LENGTH
16.384
SSL_CRLPATH
SYNC_BINLOG
0
DEADLOCK_SEARCH_DEPTH_LONG
15
GTID_POS_AUTO_ENGINES
MRR_BUFFER_SIZE
262.144
SOCKET
/run/mysqld/mysqld.sock
INNODB_MAX_DIRTY_PAGES_PCT_LWM
0,00
VERSION_SSL_LIBRARY
OpenSSL 3.0.13 30 Jan 2024
IDLE_WRITE_TRANSACTION_TIMEOUT
0
WSREP_START_POSITION
00000000-0000-0000-0000-000000000000:-1
FOREIGN_KEY_CHECKS
ON
LOG_ERROR
INNODB_MONITOR_RESET
WAIT_TIMEOUT
28.800
INNODB_STATS_AUTO_RECALC
ON
REPLICATE_DO_DB
INNODB_DEFRAGMENT
OFF
VERSION_MALLOC_LIBRARY
system
MAX_TMP_TABLES
32
MYISAM_REPAIR_THREADS
1
INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD
600
INNODB_FT_MAX_TOKEN_SIZE
84
THREAD_STACK
299.008
GTID_IGNORE_DUPLICATES
OFF
INNODB_FT_SORT_PLL_DEGREE
2
WSREP_NOTIFY_CMD
SESSION_TRACK_TRANSACTION_INFO
OFF
WSREP_MAX_WS_ROWS
0
INNODB_FILL_FACTOR
100
QUERY_CACHE_WLOCK_INVALIDATE
OFF
INNODB_ADAPTIVE_FLUSHING
ON
WSREP_DESYNC
OFF
INNODB_FILE_PER_TABLE
ON
OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT
100
EXTRA_PORT
0
WSREP_SLAVE_FK_CHECKS
ON
INNODB_LOG_CHECKPOINT_NOW
OFF
VERSION_COMMENT
Ubuntu 24.04
THREAD_POOL_PRIO_KICKUP_TIMER
1.000
RELAY_LOG_BASENAME
INNODB_DATA_HOME_DIR
WSREP_CLUSTER_NAME
my_wsrep_cluster
INNODB_READ_IO_THREADS
4
LOG_BIN_INDEX
INNODB_WRITE_IO_THREADS
4
NET_READ_TIMEOUT
30
KEEP_FILES_ON_CREATE
OFF
LOG_BIN_BASENAME
INNODB_UNDO_DIRECTORY
./
MAX_JOIN_SIZE
9.223.372.036.854.775.807
TCP_KEEPALIVE_INTERVAL
0
INNODB_FT_RESULT_CACHE_LIMIT
2.000.000.000
SLAVE_PARALLEL_MAX_QUEUED
131.072
WSREP_SYNC_WAIT
0
SECURE_AUTH
ON
WSREP_NODE_INCOMING_ADDRESS
AUTO
WSREP_PATCH_VERSION
wsrep_26.22
INNODB_ENCRYPTION_ROTATE_KEY_AGE
1
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE
-1
OPTIMIZER_TRACE
enabled=off
REPLICATE_IGNORE_DB
REQUIRE_SECURE_TRANSPORT
OFF
IGNORE_BUILTIN_INNODB
OFF
INNODB_READ_AHEAD_THRESHOLD
56
ANALYZE_SAMPLE_PERCENTAGE
100,00
INNODB_READ_ONLY
OFF
INNODB_LOG_WRITE_AHEAD_SIZE
512
INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED
OFF
SYNC_RELAY_LOG_INFO
10.000
INNODB_MONITOR_RESET_ALL
SLAVE_MAX_STATEMENT_TIME
0,00
INNODB_OPTIMIZE_FULLTEXT_ONLY
OFF
RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL
32
INNODB_STATS_METHOD
nulls_equal
JOIN_CACHE_LEVEL
2
SSL_CIPHER
WSREP_RESTART_SLAVE
OFF
LOG_SLOW_RATE_LIMIT
1
WSREP_PROVIDER
none
ARIA_SORT_BUFFER_SIZE
268.434.432
GTID_BINLOG_POS
INNODB_PURGE_RSEG_TRUNCATE_FREQUENCY
128
EXTRA_MAX_CONNECTIONS
1
INNODB_BUFFER_POOL_SIZE
134.217.728
SQL_SLAVE_SKIP_COUNTER
0
INNODB_LOG_SPIN_WAIT_DELAY
0
SSL_CAPATH
INNODB_BUFFER_POOL_LOAD_NOW
OFF
TABLE_OPEN_CACHE
2.000
IGNORE_DB_DIRS
LOWER_CASE_TABLE_NAMES
0
BINLOG_CHECKSUM
CRC32
LC_TIME_NAMES
en_US
INNODB_PAGE_SIZE
16.384
WSREP_DATA_HOME_DIR
/var/lib/mysql/
ARIA_ENCRYPT_TABLES
OFF
FT_BOOLEAN_SYNTAX
+ -><()~*:""&|
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE
-1
MAX_ERROR_COUNT
64
RPL_SEMI_SYNC_MASTER_WAIT_POINT
AFTER_COMMIT
BINLOG_COMMIT_WAIT_COUNT
0
ARIA_CHECKPOINT_LOG_ACTIVITY
1.048.576
THREAD_POOL_SIZE
1
INNODB_FLUSH_LOG_AT_TRX_COMMIT
1
LOG_DISABLED_STATEMENTS
sp
WSREP_PROVIDER_OPTIONS
DIV_PRECISION_INCREMENT
4
MAX_PREPARED_STMT_COUNT
16.382
DATETIME_FORMAT
%Y-%m-%d %H:%i:%s
WSREP_SST_DONOR
REPORT_USER
INNODB_COMPRESSION_PAD_PCT_MAX
50
ARIA_CHECKPOINT_INTERVAL
30
QUERY_CACHE_STRIP_COMMENTS
OFF
HAVE_SSL
DISABLED
GTID_STRICT_MODE
OFF
DEFAULT_TMP_STORAGE_ENGINE
SLAVE_TRANSACTION_RETRY_ERRORS
1158,1159,1160,1161,1205,1213,1020,1429,2013,12701
DELAYED_INSERT_TIMEOUT
300
LOG_OUTPUT
FILE
QUERY_CACHE_TYPE
OFF
INNODB_FT_AUX_TABLE
INNODB_CMP_PER_INDEX_ENABLED
OFF
SYSTEM_TIME_ZONE
WIB
INNODB_ONLINE_ALTER_LOG_MAX_SIZE
134.217.728
SLAVE_TRANSACTION_RETRIES
10
UPDATABLE_VIEWS_WITH_LIMIT
YES
STORAGE_ENGINE
InnoDB
LOCAL_INFILE
ON
RPL_SEMI_SYNC_SLAVE_ENABLED
OFF
DATADIR
/var/lib/mysql/
RELAY_LOG_INDEX
WSREP_MAX_WS_SIZE
2.147.483.647
SQL_QUOTE_SHOW_CREATE
ON
WSREP_MODE
OLD_PASSWORDS
OFF
WSREP_CERTIFICATION_RULES
strict
ROWID_MERGE_BUFF_SIZE
8.388.608
PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES
-1
WSREP_CAUSAL_READS
OFF
COLUMN_COMPRESSION_THRESHOLD
100
WSREP_SST_RECEIVE_ADDRESS
AUTO
SLAVE_TYPE_CONVERSIONS
MYISAM_SORT_BUFFER_SIZE
134.216.704
ARIA_PAGECACHE_DIVISION_LIMIT
100
INNODB_OLD_BLOCKS_PCT
37
IN_PREDICATE_CONVERSION_THRESHOLD
1.000
TIME_FORMAT
%H:%i:%s
INNODB_DEFRAGMENT_FILL_FACTOR_N_RECS
20
SQL_LOG_OFF
OFF
ARIA_PAGECACHE_AGE_THRESHOLD
300
SLAVE_PARALLEL_MODE
optimistic
ARIA_RECOVER_OPTIONS
BACKUP,QUICK
SKIP_SHOW_DATABASE
OFF
WSREP_TRX_FRAGMENT_UNIT
bytes
AUTOCOMMIT
ON
SLAVE_SQL_VERIFY_CHECKSUM
ON
EQ_RANGE_INDEX_DIVE_LIMIT
200
MYISAM_STATS_METHOD
NULLS_UNEQUAL
INIT_FILE
INNODB_COMPRESSION_LEVEL
6
INTERACTIVE_TIMEOUT
28.800
TRANSACTION_PREALLOC_SIZE
4.096
VERSION_COMPILE_OS
debian-linux-gnu
SLAVE_LOAD_TMPDIR
/tmp
FT_MIN_WORD_LEN
4
LOG_TC_SIZE
24.576
WSREP_FORCED_BINLOG_FORMAT
NONE
SLAVE_RUN_TRIGGERS_FOR_RBR
NO
MAX_SP_RECURSION_DEPTH
0
MAX_WRITE_LOCK_COUNT
4.294.967.295
IDLE_READONLY_TRANSACTION_TIMEOUT
0
WSREP_SST_AUTH
REPLICATE_EVENTS_MARKED_FOR_SKIP
REPLICATE
SLAVE_SKIP_ERRORS
OFF
KEY_CACHE_BLOCK_SIZE
1.024
ARIA_LOG_DIR_PATH
/var/lib/mysql/
WSREP_OSU_METHOD
TOI
INNODB_FLUSH_METHOD
O_DIRECT
WSREP_CERTIFY_NONPK
ON
INNODB_BUFFER_POOL_SIZE_MAX
134.217.728
TCP_NODELAY
ON
MYISAM_USE_MMAP
OFF
ENCRYPT_TMP_DISK_TABLES
OFF
INNODB_BUFFER_POOL_LOAD_AT_STARTUP
ON
SLAVE_DOMAIN_PARALLEL_THREADS
0
VERSION
10.11.14-MariaDB-0ubuntu0.24.04.1
INNODB_SNAPSHOT_ISOLATION
OFF
SKIP_EXTERNAL_LOCKING
ON
INNODB_FT_ENABLE_DIAG_PRINT
OFF
LOG_SLAVE_UPDATES
OFF
HAVE_SYMLINK
YES
DEADLOCK_TIMEOUT_LONG
50.000.000
WSREP_GTID_MODE
OFF
PROTOCOL_VERSION
10
INNODB_FLUSH_NEIGHBORS
1
DEBUG_NO_THREAD_ALARM
OFF
SECURE_TIMESTAMP
NO
ENFORCE_STORAGE_ENGINE
SYNC_MASTER_INFO
10.000
SKIP_NAME_RESOLVE
OFF
INNODB_DEADLOCK_DETECT
ON
INNODB_STATS_ON_METADATA
OFF
WSREP_RECOVER
OFF
READ_BINLOG_SPEED_LIMIT
0
GTID_CLEANUP_BATCH_SIZE
64
WSREP_STATUS_FILE
UNIQUE_CHECKS
ON
INNODB_LOG_GROUP_HOME_DIR
./
MAX_SEEKS_FOR_KEY
4.294.967.295
INNODB_DEFRAGMENT_N_PAGES
7
KEY_CACHE_SEGMENTS
0
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
QUERY_CACHE_MIN_RES_UNIT
4.096
INNODB_OPEN_FILES
2.000
SSL_KEY
INNODB_LOG_FILE_SIZE
100.663.296
DEFAULT_STORAGE_ENGINE
InnoDB
VERSION_SOURCE_REVISION
053f9bcb5b147bf00edb99e1310bae9125b7f125
SQL_WARNINGS
OFF
OPTIMIZER_MAX_SEL_ARG_WEIGHT
32.000
LARGE_PAGE_SIZE
0
ARIA_PAGECACHE_FILE_HASH_SIZE
512
READ_RND_BUFFER_SIZE
262.144
WSREP_NODE_NAME
ayam-mrothol-dev-ubuntu-s-1vcpu-512mb-10gb-sgp1
REPLICATE_IGNORE_TABLE
ARIA_LOG_FILE_SIZE
1.073.741.824
INNODB_NUMA_INTERLEAVE
OFF
OPTIMIZER_SEARCH_DEPTH
62
INNODB_CHECKSUM_ALGORITHM
full_crc32
TCP_KEEPALIVE_TIME
0
ARIA_LOG_PURGE_TYPE
immediate
READ_ONLY
OFF
MYSQL56_TEMPORAL_FORMAT
ON
REPLICATE_WILD_IGNORE_TABLE
ARIA_BLOCK_SIZE
8.192
INNODB_DATA_FILE_PATH
ibdata1:12M:autoextend
WSREP_SR_STORE
table
DEADLOCK_TIMEOUT_SHORT
10.000
SQL_IF_EXISTS
OFF
WSREP_DIRTY_READS
OFF
ARIA_GROUP_COMMIT
none
INNODB_DEFRAGMENT_FILL_FACTOR
0,90
MAX_ALLOWED_PACKET
16.777.216
ALTER_ALGORITHM
DEFAULT
USERSTAT
OFF
SQL_LOG_BIN
ON
SESSION_TRACK_SYSTEM_VARIABLES
autocommit,character_set_client,character_set_connection,character_set_results,time_zone
SERVER_UID
QcZPUixbD6gFEmDGoJmlmMbCQdc=
ARIA_SYNC_LOG_DIR
NEWFILE
INNODB_PURGE_BATCH_SIZE
127
INNODB_FORCE_PRIMARY_KEY
OFF
TMPDIR
/tmp
RELAY_LOG_PURGE
ON
AUTO_INCREMENT_INCREMENT
1
INNODB_FT_TOTAL_CACHE_SIZE
640.000.000
REPLICATE_ANNOTATE_ROW_EVENTS
ON
OPTIMIZER_MAX_SEL_ARGS
16.000
TABLE_OPEN_CACHE_INSTANCES
8
IDLE_TRANSACTION_TIMEOUT
0
RELAY_LOG_INFO_FILE
relay-log.info
BINLOG_ANNOTATE_ROW_EVENTS
ON
Total Baris: 655