MariaDB Version 11.4.10-MariaDB-ubu2404
allow_suspicious_udfsOFF
alter_algorithmDEFAULT
analyze_max_length4294967295
analyze_sample_percentage100.000000
aria_block_size8192
aria_checkpoint_interval30
aria_checkpoint_log_activity1048576
aria_encrypt_tablesOFF
aria_force_start_after_recovery_failures0
aria_group_commitnone
aria_group_commit_interval0
aria_log_dir_path/var/lib/mysql/
aria_log_file_size1073741824
aria_log_purge_typeimmediate
aria_max_sort_file_size9223372036853727232
aria_page_checksumON
aria_pagecache_age_threshold300
aria_pagecache_buffer_size134217728
aria_pagecache_division_limit100
aria_pagecache_file_hash_size512
aria_recover_optionsBACKUP,QUICK
aria_repair_threads1
aria_sort_buffer_size268434432
aria_stats_methodnulls_unequal
aria_sync_log_dirNEWFILE
aria_used_for_temp_tablesON
auto_increment_increment1
auto_increment_offset1
autocommitON
automatic_sp_privilegesON
back_log64
basedir/usr
big_tablesOFF
bind_address127.0.0.1
binlog_alter_two_phaseOFF
binlog_annotate_row_eventsON
binlog_cache_size32768
binlog_checksumCRC32
binlog_commit_wait_count0
binlog_commit_wait_usec100000
binlog_direct_non_transactional_updatesOFF
binlog_do_db
binlog_expire_logs_seconds864000
binlog_file_cache_size16384
binlog_formatMIXED
binlog_gtid_indexON
binlog_gtid_index_page_size4096
binlog_gtid_index_span_min65536
binlog_ignore_db
binlog_legacy_event_posOFF
binlog_optimize_thread_schedulingON
binlog_row_event_max_size8192
binlog_row_imageFULL
binlog_row_metadataNO_LOG
binlog_space_limit0
binlog_stmt_cache_size32768
block_encryption_modeaes-128-ecb
bulk_insert_buffer_size8388608
character_set_clientutf8mb4
character_set_collationsutf8mb4=utf8mb4_uca1400_ai_ci
character_set_connectionutf8mb4
character_set_databaseutf8mb4
character_set_filesystembinary
character_set_resultsutf8mb4
character_set_serverutf8mb4
character_set_systemutf8mb3
character_sets_dir/usr/share/mariadb/charsets/
check_constraint_checksON
collation_connectionutf8mb4_uca1400_ai_ci
collation_databaseutf8mb4_unicode_520_ci
collation_serverutf8mb4_unicode_520_ci
column_compression_threshold100
column_compression_zlib_level6
column_compression_zlib_strategyDEFAULT_STRATEGY
column_compression_zlib_wrapOFF
completion_typeNO_CHAIN
concurrent_insertAUTO
connect_timeout10
core_fileOFF
datadir/var/lib/mysql/
deadlock_search_depth_long15
deadlock_search_depth_short4
deadlock_timeout_long50000000
deadlock_timeout_short10000
default_master_connection
default_password_lifetime0
default_regex_flags
default_storage_engineInnoDB
default_tmp_storage_engine
default_week_format0
delay_key_writeON
delayed_insert_limit100
delayed_insert_timeout300
delayed_queue_size1000
disconnect_on_expired_passwordOFF
div_precision_increment4
encrypt_binlogOFF
encrypt_tmp_disk_tablesOFF
encrypt_tmp_filesOFF
enforce_storage_engine
eq_range_index_dive_limit200
error_count0
event_schedulerOFF
expensive_subquery_limit100
expire_logs_days10.000000
explicit_defaults_for_timestampON
external_user
extra_max_connections1
extra_port0
flushOFF
flush_time0
foreign_key_checksON
ft_boolean_syntax+ -><()~*:""&|
ft_max_word_len84
ft_min_word_len4
ft_query_expansion_limit20
ft_stopword_file(built-in)
general_logOFF
general_log_fileunlim24.log
group_concat_max_len1048576
gtid_binlog_pos
gtid_binlog_state
gtid_cleanup_batch_size64
gtid_current_pos
gtid_domain_id0
gtid_ignore_duplicatesOFF
gtid_pos_auto_engines
gtid_seq_no0
gtid_slave_pos
gtid_strict_modeOFF
have_compressYES
have_cryptYES
have_dynamic_loadingYES
have_geometryYES
have_opensslYES
have_profilingYES
have_query_cacheYES
have_rtree_keysYES
have_sslYES
have_symlinkDISABLED
histogram_size254
histogram_typeJSON_HB
host_cache_size198
hostnameunlim24.com
identity0
idle_readonly_transaction_timeout0
idle_transaction_timeout0
idle_write_transaction_timeout0
ignore_builtin_innodbOFF
ignore_db_dirs
in_predicate_conversion_threshold1000
in_transaction0
init_connectSET NAMES utf8mb4
init_file
init_slave
innodb_adaptive_flushingON
innodb_adaptive_flushing_lwm10.000000
innodb_adaptive_hash_indexOFF
innodb_adaptive_hash_index_parts8
innodb_alter_copy_bulkON
innodb_autoextend_increment64
innodb_autoinc_lock_mode1
innodb_buf_dump_status_frequency0
innodb_buffer_pool_chunk_size0
innodb_buffer_pool_dump_at_shutdownON
innodb_buffer_pool_dump_nowOFF
innodb_buffer_pool_dump_pct25
innodb_buffer_pool_filenameib_buffer_pool
innodb_buffer_pool_load_abortOFF
innodb_buffer_pool_load_at_startupON
innodb_buffer_pool_load_nowOFF
innodb_buffer_pool_size134217728
innodb_buffer_pool_size_auto_min134217728
innodb_buffer_pool_size_max134217728
innodb_checksum_algorithmfull_crc32
innodb_cmp_per_index_enabledOFF
innodb_compression_algorithmzlib
innodb_compression_defaultOFF
innodb_compression_failure_threshold_pct5
innodb_compression_level6
innodb_compression_pad_pct_max50
innodb_data_file_bufferingOFF
innodb_data_file_pathibdata1:12M:autoextend
innodb_data_file_write_throughOFF
innodb_data_home_dir
innodb_deadlock_detectON
innodb_deadlock_reportfull
innodb_default_encryption_key_id1
innodb_default_row_formatdynamic
innodb_disable_sort_file_cacheOFF
innodb_doublewriteON
innodb_encrypt_logOFF
innodb_encrypt_tablesOFF
innodb_encrypt_temporary_tablesOFF
innodb_encryption_rotate_key_age1
innodb_encryption_rotation_iops100
innodb_encryption_threads0
innodb_fast_shutdown1
innodb_fatal_semaphore_wait_threshold600
innodb_file_per_tableON
innodb_fill_factor100
innodb_flush_log_at_timeout1
innodb_flush_log_at_trx_commit1
innodb_flush_methodO_DIRECT
innodb_flush_neighbors1
innodb_flush_syncON
innodb_flushing_avg_loops30
innodb_force_primary_keyOFF
innodb_force_recovery0
innodb_ft_aux_table
innodb_ft_cache_size8000000
innodb_ft_enable_diag_printOFF
innodb_ft_enable_stopwordON
innodb_ft_max_token_size84
innodb_ft_min_token_size3
innodb_ft_num_word_optimize2000
innodb_ft_result_cache_limit2000000000
innodb_ft_server_stopword_table
innodb_ft_sort_pll_degree2
innodb_ft_total_cache_size640000000
innodb_ft_user_stopword_table
innodb_immediate_scrub_data_uncompressedOFF
innodb_instant_alter_column_allowedadd_drop_reorder
innodb_io_capacity200
innodb_io_capacity_max2000
innodb_linux_aioauto
innodb_lock_wait_timeout50
innodb_log_buffer_size16777216
innodb_log_checkpoint_nowOFF
innodb_log_file_bufferingOFF
innodb_log_file_mmapOFF
innodb_log_file_size100663296
innodb_log_file_write_throughOFF
innodb_log_group_home_dir./
innodb_log_spin_wait_delay0
innodb_log_write_ahead_size512
innodb_lru_flush_size0
innodb_lru_scan_depth1536
innodb_max_dirty_pages_pct90.000000
innodb_max_dirty_pages_pct_lwm0.000000
innodb_max_purge_lag0
innodb_max_purge_lag_delay0
innodb_max_purge_lag_wait4294967295
innodb_max_undo_log_size10485760
innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_old_blocks_pct37
innodb_old_blocks_time1000
innodb_online_alter_log_max_size134217728
innodb_open_files300
innodb_optimize_fulltext_onlyOFF
innodb_page_size16384
innodb_prefix_index_cluster_optimizationON
innodb_print_all_deadlocksOFF
innodb_purge_batch_size127
innodb_purge_rseg_truncate_frequency128
innodb_purge_threads4
innodb_random_read_aheadOFF
innodb_read_ahead_threshold56
innodb_read_io_threads4
innodb_read_onlyOFF
innodb_read_only_compressedOFF
innodb_rollback_on_timeoutOFF
innodb_snapshot_isolationOFF
innodb_sort_buffer_size1048576
innodb_spin_wait_delay4
innodb_stats_auto_recalcON
innodb_stats_include_delete_markedOFF
innodb_stats_methodnulls_equal
innodb_stats_modified_counter0
innodb_stats_on_metadataOFF
innodb_stats_persistentON
innodb_stats_persistent_sample_pages20
innodb_stats_traditionalON
innodb_stats_transient_sample_pages8
innodb_status_outputOFF
innodb_status_output_locksOFF
innodb_strict_modeON
innodb_sync_spin_loops30
innodb_table_locksON
innodb_temp_data_file_pathibtmp1:12M:autoextend
innodb_tmpdir
innodb_truncate_temporary_tablespace_nowOFF
innodb_undo_directory./
innodb_undo_log_truncateOFF
innodb_undo_tablespaces3
innodb_use_atomic_writesON
innodb_use_native_aioON
innodb_write_io_threads4
insert_id0
interactive_timeout50
join_buffer_size262144
join_buffer_space_limit2097152
join_cache_level2
keep_files_on_createOFF
key_buffer_size16777216
key_cache_age_threshold300
key_cache_block_size1024
key_cache_division_limit100
key_cache_file_hash_size512
key_cache_segments0
large_files_supportON
large_page_size0
large_pagesOFF
last_gtid
last_insert_id0
lc_messagesen_US
lc_messages_dir/usr/share/mariadb
lc_time_namesen_US
licenseGPL
local_infileOFF
lock_wait_timeout86400
locked_in_memoryOFF
log_binOFF
log_bin_basename
log_bin_compressOFF
log_bin_compress_min_len256
log_bin_index
log_bin_trust_function_creatorsOFF
log_disabled_statementssp
log_error/var/log/mysql/error.log
log_outputFILE
log_queries_not_using_indexesOFF
log_slave_updatesOFF
log_slow_admin_statementsON
log_slow_disabled_statementssp
log_slow_filteradmin,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_warnings10
log_slow_min_examined_row_limit0
log_slow_queryOFF
log_slow_query_fileunlim24-slow.log
log_slow_query_time5.000000
log_slow_rate_limit1
log_slow_slave_statementsON
log_slow_verbosity
log_tc_size24576
log_warnings2
long_query_time5.000000
low_priority_updatesOFF
lower_case_file_systemOFF
lower_case_table_names0
master_verify_checksumOFF
max_allowed_packet16777216
max_binlog_cache_size18446744073709547520
max_binlog_size1073741824
max_binlog_stmt_cache_size18446744073709547520
max_binlog_total_size0
max_connect_errors100
max_connections70
max_delayed_threads20
max_digest_length1024
max_error_count64
max_heap_table_size16777216
max_insert_delayed_threads20
max_join_size18446744073709551615
max_length_for_sort_data1024
max_password_errors4294967295
max_prepared_stmt_count16382
max_recursive_iterations1000
max_relay_log_size1073741824
max_rowid_filter_size131072
max_seeks_for_key4294967295
max_session_mem_used9223372036854775807
max_sort_length1024
max_sp_recursion_depth0
max_statement_time0.000000
max_user_connections30
max_write_lock_count4294967295
metadata_locks_cache_size1024
metadata_locks_hash_instances8
min_examined_row_limit0
mrr_buffer_size262144
myisam_block_size1024
myisam_data_pointer_size6
myisam_max_sort_file_size9223372036853727232
myisam_mmap_size18446744073709551615
myisam_recover_optionsBACKUP,QUICK
myisam_repair_threads1
myisam_sort_buffer_size8388608
myisam_stats_methodNULLS_UNEQUAL
myisam_use_mmapOFF
mysql56_temporal_formatON
net_buffer_length8192
net_read_timeout30
net_retry_count10
net_write_timeout60
new_mode
note_verbositybasic,explain
oldOFF
old_modeUTF8_IS_UTF8MB3
old_passwordsOFF
open_files_limit1127
optimizer_adjust_secondary_key_costs0
optimizer_disk_read_cost10.240000
optimizer_disk_read_ratio0.020000
optimizer_extra_pruning_depth8
optimizer_index_block_copy_cost0.035600
optimizer_join_limit_pref_ratio0
optimizer_key_compare_cost0.011361
optimizer_key_copy_cost0.015685
optimizer_key_lookup_cost0.435777
optimizer_key_next_find_cost0.082347
optimizer_max_sel_arg_weight32000
optimizer_max_sel_args16000
optimizer_prune_level2
optimizer_row_copy_cost0.060866
optimizer_row_lookup_cost0.130839
optimizer_row_next_find_cost0.045916
optimizer_rowid_compare_cost0.002653
optimizer_rowid_copy_cost0.002653
optimizer_scan_setup_cost10.000000
optimizer_search_depth62
optimizer_selectivity_sampling_limit100
optimizer_switchindex_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,cset_narrowing=off,sargable_casefold=on
optimizer_traceenabled=off
optimizer_trace_max_mem_size1048576
optimizer_use_condition_selectivity4
optimizer_where_cost0.032000
performance_schemaOFF
performance_schema_accounts_size-1
performance_schema_digests_size-1
performance_schema_events_stages_history_long_size-1
performance_schema_events_stages_history_size-1
performance_schema_events_statements_history_long_size-1
performance_schema_events_statements_history_size-1
performance_schema_events_transactions_history_long_size-1
performance_schema_events_transactions_history_size-1
performance_schema_events_waits_history_long_size-1
performance_schema_events_waits_history_size-1
performance_schema_hosts_size-1
performance_schema_max_cond_classes90
performance_schema_max_cond_instances-1
performance_schema_max_digest_length1024
performance_schema_max_file_classes80
performance_schema_max_file_handles32768
performance_schema_max_file_instances-1
performance_schema_max_index_stat-1
performance_schema_max_memory_classes320
performance_schema_max_metadata_locks-1
performance_schema_max_mutex_classes210
performance_schema_max_mutex_instances-1
performance_schema_max_prepared_statements_instances-1
performance_schema_max_program_instances-1
performance_schema_max_rwlock_classes50
performance_schema_max_rwlock_instances-1
performance_schema_max_socket_classes10
performance_schema_max_socket_instances-1
performance_schema_max_sql_text_length1024
performance_schema_max_stage_classes160
performance_schema_max_statement_classes222
performance_schema_max_statement_stack10
performance_schema_max_table_handles-1
performance_schema_max_table_instances-1
performance_schema_max_table_lock_stat-1
performance_schema_max_thread_classes50
performance_schema_max_thread_instances-1
performance_schema_session_connect_attrs_size-1
performance_schema_setup_actors_size-1
performance_schema_setup_objects_size-1
performance_schema_users_size-1
pid_file/run/mysqld/mysqld.pid
plugin_dir/usr/lib/mysql/plugin/
plugin_maturitygamma
port3306
preload_buffer_size32768
profilingOFF
profiling_history_size15
progress_report_time5
protocol_version10
proxy_protocol_networks
proxy_user
pseudo_slave_modeOFF
pseudo_thread_id13194
query_alloc_block_size32768
query_cache_limit1048576
query_cache_min_res_unit4096
query_cache_size1048576
query_cache_strip_commentsOFF
query_cache_typeOFF
query_cache_wlock_invalidateOFF
query_prealloc_size32768
rand_seed1634556310
rand_seed250827545
range_alloc_block_size4096
read_binlog_speed_limit0
read_buffer_size262144
read_onlyOFF
read_rnd_buffer_size524288
redirect_url
relay_log
relay_log_basename
relay_log_index
relay_log_info_filerelay-log.info
relay_log_purgeON
relay_log_recoveryOFF
relay_log_space_limit0
replicate_annotate_row_eventsON
replicate_do_db
replicate_do_table
replicate_events_marked_for_skipREPLICATE
replicate_ignore_db
replicate_ignore_table
replicate_rewrite_db
replicate_wild_do_table
replicate_wild_ignore_table
report_host
report_password
report_port3306
report_user
require_secure_transportOFF
rowid_merge_buff_size8388608
rpl_semi_sync_master_enabledOFF
rpl_semi_sync_master_timeout10000
rpl_semi_sync_master_trace_level32
rpl_semi_sync_master_wait_no_slaveON
rpl_semi_sync_master_wait_pointAFTER_COMMIT
rpl_semi_sync_slave_delay_masterOFF
rpl_semi_sync_slave_enabledOFF
rpl_semi_sync_slave_kill_conn_timeout5
rpl_semi_sync_slave_trace_level32
secure_authON
secure_file_priv
secure_timestampNO
server_id1
server_uidtSJgGji/Yqs4JJ3wfTbCSbm1qkk=
session_track_schemaON
session_track_state_changeOFF
session_track_system_variablesautocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
session_track_transaction_infoOFF
skip_external_lockingON
skip_grant_tablesOFF
skip_name_resolveOFF
skip_networkingOFF
skip_parallel_replicationOFF
skip_replicationOFF
skip_show_databaseOFF
slave_compressed_protocolOFF
slave_connections_needed_for_purge1
slave_ddl_exec_modeIDEMPOTENT
slave_domain_parallel_threads0
slave_exec_modeSTRICT
slave_load_tmpdir/tmp
slave_max_allowed_packet1073741824
slave_max_statement_time0.000000
slave_net_timeout60
slave_parallel_max_queued131072
slave_parallel_modeoptimistic
slave_parallel_threads0
slave_parallel_workers0
slave_run_triggers_for_rbrNO
slave_skip_errorsOFF
slave_sql_verify_checksumON
slave_transaction_retries10
slave_transaction_retry_errors1158,1159,1160,1161,1205,1213,1020,1429,2013,12701
slave_transaction_retry_interval0
slave_type_conversions
slow_launch_time2
slow_query_logOFF
slow_query_log_fileunlim24-slow.log
socket/run/mysqld/mysqld.sock
sort_buffer_size524288
sql_auto_is_nullOFF
sql_big_selectsON
sql_buffer_resultOFF
sql_if_existsOFF
sql_log_binON
sql_log_offOFF
sql_modeSTRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sql_notesON
sql_quote_show_createON
sql_safe_updatesOFF
sql_select_limit18446744073709551615
sql_slave_skip_counter0
sql_warningsOFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_crl
ssl_crlpath
ssl_key
standard_compliant_cteON
storage_engineInnoDB
stored_program_cache256
strict_password_validationON
sync_binlog0
sync_frmON
sync_master_info10000
sync_relay_log10000
sync_relay_log_info10000
system_time_zoneCEST
system_versioning_alter_historyERROR
system_versioning_asofDEFAULT
system_versioning_insert_historyOFF
table_definition_cache400
table_open_cache64
table_open_cache_instances8
tcp_keepalive_interval0
tcp_keepalive_probes0
tcp_keepalive_time0
tcp_nodelayON
thread_cache_size70
thread_handlingone-thread-per-connection
thread_pool_dedicated_listenerOFF
thread_pool_exact_statsOFF
thread_pool_idle_timeout60
thread_pool_max_threads65536
thread_pool_oversubscribe3
thread_pool_prio_kickup_timer1000
thread_pool_priorityauto
thread_pool_size2
thread_pool_stall_limit500
thread_stack299008
time_zoneSYSTEM
timestamp1775477206.784303
tls_versionTLSv1.2,TLSv1.3
tmp_disk_table_size18446744073709551615
tmp_memory_table_size16777216
tmp_table_size16777216
tmpdir/tmp
transaction_alloc_block_size8192
transaction_isolationREPEATABLE-READ
transaction_prealloc_size4096
transaction_read_onlyOFF
tx_isolationREPEATABLE-READ
tx_read_onlyOFF
unique_checksON
updatable_views_with_limitYES
use_stat_tablesPREFERABLY_FOR_QUERIES
userstatOFF
version11.4.10-MariaDB-ubu2404
version_commentmariadb.org binary distribution
version_compile_machinex86_64
version_compile_osdebian-linux-gnu
version_malloc_librarysystem
version_source_revision054a893f1645b77e52a329a7fc8cf614eebd1fad
version_ssl_libraryOpenSSL 3.0.13 30 Jan 2024
wait_timeout10
warning_count0
wsrep_osu_methodTOI
wsrep_sr_storetable
wsrep_allowlist
wsrep_auto_increment_controlON
wsrep_certification_rulesstrict
wsrep_certify_nonpkON
wsrep_cluster_address
wsrep_cluster_namemy_wsrep_cluster
wsrep_convert_lock_to_trxOFF
wsrep_data_home_dir/var/lib/mysql/
wsrep_dbug_option
wsrep_debugNONE
wsrep_desyncOFF
wsrep_dirty_readsOFF
wsrep_drupal_282555_workaroundOFF
wsrep_forced_binlog_formatNONE
wsrep_gtid_domain_id0
wsrep_gtid_modeOFF
wsrep_gtid_seq_no0
wsrep_ignore_apply_errors7
wsrep_load_data_splittingOFF
wsrep_log_conflictsOFF
wsrep_max_ws_rows0
wsrep_max_ws_size2147483647
wsrep_mode
wsrep_mysql_replication_bundle0
wsrep_node_address
wsrep_node_incoming_addressAUTO
wsrep_node_nameunlim24.com
wsrep_notify_cmd
wsrep_onOFF
wsrep_patch_versionwsrep_26.22
wsrep_providernone
wsrep_provider_options
wsrep_recoverOFF
wsrep_reject_queriesNONE
wsrep_restart_slaveOFF
wsrep_retry_autocommit1
wsrep_slave_fk_checksON
wsrep_slave_uk_checksOFF
wsrep_slave_threads1
wsrep_sst_auth
wsrep_sst_donor
wsrep_sst_donor_rejects_queriesOFF
wsrep_sst_methodrsync
wsrep_sst_receive_addressAUTO
wsrep_start_position00000000-0000-0000-0000-000000000000:-1
wsrep_status_file
wsrep_sync_wait0
wsrep_trx_fragment_size0
wsrep_trx_fragment_unitbytes