All pages
Powered by GitBook
1 of 35

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

System and Status Variables Added By Major Unmaintained Release

Discover system and status variables added by major unmaintained MariaDB Server releases. This section provides insights into parameters from older versions, useful for understanding historical config

System and Status Variables Added By Major Release

Discover system and status variables added by major MariaDB Server releases. This section helps you track new configuration options and monitoring metrics introduced in different versions.

System Variables Added in MariaDB 12.0

This is a list of system variables that have been added in the MariaDB 12.0 series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 11.8

Variable
Added

For system variables added since the previous long-term release, MariaDB 11.4, see:

This page is licensed: CC BY-SA / Gnu FDL

Status Variables Added in MariaDB 11.4

This is a list of status variables that were added in the MariaDB 11.4 series.

Variable
Added

For status variables added since the previous long-term release, MariaDB 10.11, see:

See Also

This page is licensed: CC BY-SA / Gnu FDL

Status Variables Added in MariaDB 10.6

This is a list of status variables that were added in the MariaDB 10.6 series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 12.1

This is a list of that have been added in the series.

Variable
Added

System Variables Added in MariaDB 11.7

This is a list of that have been added in the series.

Variable
Added

System Variables Added in MariaDB 11.6

This is a list of that have been added in the series.

Variable
Added

MariaDB 12.1.0

caching_sha2_password_public_key_path

MariaDB 12.1.0

MariaDB 12.1.0

MariaDB 12.1.0

MariaDB 12.1.0

See Also

  • System Variables Added in MariaDB 12.0

This page is licensed: CC BY-SA / Gnu FDL

analyze_max_length

MariaDB 12.1.1

aria_pagecache_segments

MariaDB 12.1.0

caching_sha2_password_auto_generate_rsa_keys

MariaDB 12.1.0

caching_sha2_password_digest_rounds

MariaDB 12.1.0

system variables
MariaDB 12.1

caching_sha2_password_private_key_path

See Also

  • System Variables Added in MariaDB 11.6

This page is licensed: CC BY-SA / Gnu FDL

binlog_large_commit_threshold

innodb_log_file_mmap

log_slow_always_query_time

mhnsw_default_distance

system variables

See Also
  • System Variables Added in MariaDB 11.5

This page is licensed: CC BY-SA / Gnu FDL

innodb_log_file_mmap

optimizer_join_limit_pref_ratio

server_uid

system variables

replicate_same_server_id

MariaDB 12.0.1

show_slave_auth_info

MariaDB 12.0.1

ssl_passphrase

MariaDB 12.0.1

System Variables Added in MariaDB 11.8
analyze_max_length
MariaDB 12.0.2
create_tmp_table_binlog_formats
MariaDB 12.0.1
master_info_file
MariaDB 12.0.1
max_open_cursors
MariaDB 12.0.1
System Variables Added in MariaDB 11.7
System Variables Added in MariaDB 11.6
System Variables Added in MariaDB 11.5
analyze_max_length
MariaDB 11.8.3
innodb_buffer_pool_size_auto_min
MariaDB 11.8.2
innodb_buffer_pool_size_max
MariaDB 11.8.2
innodb_log_checkpoint_now
MariaDB 11.8.2
Status Variables Added in MariaDB 11.0
System variables added in MariaDB 11.4
binlog_gtid_index_hit
MariaDB 11.4.0
binlog_gtid_index_miss
MariaDB 11.4.0
System variables added in MariaDB 10.6
Status variables added in MariaDB 10.5
Status variables added in MariaDB 10.4
Innodb_buffer_pool_pages_lru_freed
MariaDB 10.6.0
resultset_metadata_skipped
MariaDB 10.6.0

System Variables Added in MariaDB 11.4

This is a list of system variables that have been added in the MariaDB 11.4 series.

Variable
Added

For system variables added since the previous long-term release, , see:

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 10.6

This is a list of that have been added in the series. The list does not include variables that are not part of the default release.

Variable
Added

For system variables that have been removed or deprecated, see Upgrading from MariaDB 10.5 to MariaDB 10.6.

See Also

  • Status Variables Added in MariaDB 10.6

  • System Variables Added in MariaDB 10.5

  • System Variables Added in MariaDB 10.4

This page is licensed: CC BY-SA / Gnu FDL

analyze_max_length

MariaDB 10.6.23

binlog_expire_logs_seconds

MariaDB 10.6.0

innodb_deadlock_report

MariaDB 10.6.0

innodb_read_only_compressed

MariaDB 10.6.0

system variables
MariaDB 10.6

binlog_legacy_event_pos

MariaDB 11.4.0

binlog_space_limit

MariaDB 11.4.0

innodb_alter_copy_bulk

MariaDB 11.4.3

innodb_buffer_pool_size_auto_min

MariaDB 11.4.6

innodb_buffer_pool_size_max

MariaDB 11.4.6

innodb_log_checkpoint_now

MariaDB 11.4.6

innodb_log_file_mmap

MariaDB 11.4.4

innodb_log_spin_wait_delay

MariaDB 11.4.2

innodb_log_write_ahead_size

MariaDB 11.4.3

innodb_snapshot_isolation

MariaDB 11.4.2

max_binlog_total_size

MariaDB 11.4.0

optimizer_join_limit_pref_ratio

MariaDB 11.4.4

server_uid

MariaDB 11.4.3

slave_connections_needed_for_purge

MariaDB 11.4.0

MariaDB 10.11
System Variables Added in MariaDB 11.3
System Variables Added in MariaDB 11.2
System Variables Added in MariaDB 11.1
System Variables Added in MariaDB 11.0
Status Variables Added in MariaDB 11.4
analyze_max_length
MariaDB 11.4.8
binlog_gtid_index
MariaDB 11.4.0
binlog_gtid_index_page_size
MariaDB 11.4.0
binlog_gtid_index_span_min
MariaDB 11.4.0
metadata_locks_instances
optimizer_record_context
mhnsw_default_m
mhnsw_ef_search
mhnsw_max_cache_size
slave_abort_blocking_timeout

System Variables Added in MariaDB 10.11

This is a list of system variables that have been added in the MariaDB 10.11 series.

Variable
Added

For system variables added since the previous long-term release, , see:

For system variables that have been removed or deprecated, see .

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 10.8

This is a list of that have been added in the series.

Variable
Added

For system variables that have been removed or deprecated, see .

Status Variables Added in MariaDB 11.0

This is a list of that were added in the series.

Variable
Added

See Also

System Variables Added in MariaDB 11.5

This is a list of that have been added in the series.

Variable
Added

innodb_log_checkpoint_now

MariaDB 10.11.12

innodb_log_file_mmap

MariaDB 10.11.10

innodb_log_spin_wait_delay

MariaDB 10.11.8

innodb_log_write_ahead_size

MariaDB 10.11.9

innodb_snapshot_isolation

MariaDB 10.11.8

log_slow_max_warnings

MariaDB 10.11.6

log_slow_min_examined_row_limit

MariaDB 10.11.0

log_slow_query

MariaDB 10.11.0

log_slow_query_file

MariaDB 10.11.1

log_slow_query_time

MariaDB 10.11.0

optimizer_join_limit_pref_ratio

MariaDB 10.11.10

optimizer_max_sel_args

MariaDB 10.11.6

replicate_rewrite_db

MariaDB 10.11.0

server_uid

MariaDB 10.11.9

system_versioning_insert_history

MariaDB 10.11.0

MariaDB 10.6
System Variables Added in MariaDB 10.10
System Variables Added in MariaDB 10.9
System Variables Added in MariaDB 10.8
Upgrading from MariaDB 10.6 to MariaDB 10.11
analyze_max_length
MariaDB 10.11.14
innodb_alter_copy_bulk
MariaDB 10.11.9
innodb_buffer_pool_size_auto_min
MariaDB 10.11.12
innodb_buffer_pool_size_max
MariaDB 10.11.12
See Also
  • System Variables Added in MariaDB 10.6

This page is licensed: CC BY-SA / Gnu FDL

binlog_alter_two_phase

innodb_log_file_buffering

system variables
Upgrading from MariaDB 10.7 to MariaDB 10.8

System variables added in MariaDB 11.0

This page is licensed: CC BY-SA / Gnu FDL

max_used_connections_time

status variables

See Also

  • Status Variables Added in MariaDB 11.5

  • System Variables Added in MariaDB 11.4

This page is licensed: CC BY-SA / Gnu FDL

innodb_alter_copy_bulk

innodb_log_spin_wait_delay

innodb_log_write_ahead_size

max_tmp_session_space_usage

system variables

innodb_snapshot_isolation
MariaDB 10.6.18
log_slow_max_warnings
MariaDB 10.6.16
note_verbosity
MariaDB 10.6.16
optimizer_adjust_secondary_key_costs
MariaDB 10.6.17
optimizer_join_limit_pref_ratio
MariaDB 10.6.20
optimizer_max_sel_args
MariaDB 10.6.16
server_uid
MariaDB 10.6.19
MariaDB 10.6.0

System Variables Added in MariaDB 10.9

This is a list of system variables that have been added in the series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 11.2

This is a list of that have been added in the series.

Variable
Added

System Variables Added in MariaDB 10.10

This is a list of that have been added in the series.

Variable
Added

System Variables Added in MariaDB 11.0

This is a list of that have been added in the series.

Variable
Added

Status Variables Added in MariaDB 10.4

This is a list of that were added in the series.

Variable
Added

See Also

  • System Variables Added in MariaDB 11.1

This page is licensed: CC BY-SA / Gnu FDL

binlog_do_db

binlog_ignore_db

binlog_row_event_max_size

block_encryption_mode

system variables

See Also

  • System Variables Added in MariaDB 10.9

This page is licensed: CC BY-SA / Gnu FDL

allow_suspicious_udfs

optimizer_extra_pruning_depth

log_slow_max_warnings

optimizer_max_sel_args

system variables

For system variables that have been removed or deprecated, see Upgrading from MariaDB 10.11 to MariaDB 11.0.

See Also

  • Status Variables Added in MariaDB 11.0

  • System Variables Added in MariaDB 10.11

This page is licensed: CC BY-SA / Gnu FDL

innodb_data_file_buffering

innodb_data_file_write_through

innodb_log_file_write_through

log_slow_max_warnings

system variables

See Also

  • System Variables Added in MariaDB 10.4

  • Status Variables Added in MariaDB 10.5

  • Status Variables Added in MariaDB 10.3

  • Status Variables Added in MariaDB 10.2

This page is licensed: CC BY-SA / Gnu FDL

Aborted_connects_preauth

Com_backup

Com_backup_lock

Feature_application_time_periods

status variables

System Variables Added in MariaDB 10.8
System Variables Added in MariaDB 10.6
rocksdb_log_dir
max_tmp_total_space_usage
server_uid

System Variables Added in MariaDB 10.4

This is a list of system variables that have been added in the series. The list does not include variables that are not part of the default release.

Variable
Added

For system variables that have been removed or deprecated, see .

See Also

This page is licensed: CC BY-SA / Gnu FDL

Status Variables Added in MariaDB 10.2

This is a list of status variables that were added in the series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 11.1

This is a list of system variables that have been added in the series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 5.5

This is a list of that were added in the series.

The list excludes variables related to non-default storage engines and plugins that can be added to :

Variable
Added

See also

  • System Variables Added in MariaDB 10.0

  • Upgrading from MariaDB 5.3 to MariaDB 5.5

This page is licensed: CC BY-SA / Gnu FDL

innodb_adaptive_flushing_method

innodb_adaptive_hash_index_partitions

innodb_blocking_buffer_pool_restore

system variables

innodb_encrypt_temporary_ables

innodb_instant_alter_column_allowed

max_password_errors

optimizer_trace

optimizer_trace_max_mem_size

tcp_nodelay

tls_version

Upgrading from MariaDB 10.3 to MariaDB 10.4
Status Variables Added in MariaDB 10.4
System Variables Added in MariaDB 10.5
System Variables Added in MariaDB 10.3
System Variables Added in MariaDB 10.2
analyze_sample_percentage
default_password_lifetime
disconnect_on_expired_password
gtid_cleanup_batch_size

Innodb_buffer_pool_resize_status

Innodb_encryption_num_key_requests

Innodb_have_punch_hole

Innodb_pages0read

Innodb_scrub_log

System variables added in MariaDB 10.2
Status variables added in MariaDB 10.3
Status variables added in MariaDB 10.1
Status variables added in MariaDB 10.0
Com_alter_user
Com_execute_immediate
Com_multi
Com_show_create_user

log_slow_max_warnings

optimizer_max_sel_args

server_uid

transaction_isolation

transaction_read_only

System Variables Added in MariaDB 11.0
innodb_alter_copy_bulk
innodb_log_spin_wait_delay
innodb_log_write_ahead_size
MariaDB 10.11.9
innodb_snapshot_isolation
character_set_collations
innodb_alter_copy_bulk
innodb_log_file_mmap
innodb_log_spin_wait_delay
innodb_log_write_ahead_size
innodb_snapshot_isolation
optimizer_join_limit_pref_ratio
server_uid
skip_grant_tables
slave_max_statement_time
innodb_log_spin_wait_delay
innodb_snapshot_isolation
optimizer_max_sel_args

Status Variables Added in MariaDB 10.3

This is a list of status variables that were added in the series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

Status Variables Added in MariaDB 11.5

This is a list of status variables that were added in the series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

Com_create_package_body

Com_create_sequence

Com_drop_package

Com_drop_package_body

Com_drop_sequence

Com_show_create_package

Com_show_create_package_body

Com_show_package_status

Com_show_package_body_status

Feature_json

Feature_system_versioning

Handler_tmp_delete

Innodb_buffer_pool_load_incomplete

Memory_used_initial

Rpl_semi_sync*

Rpl_transactions_multi_engine

Table_open_cache_active_instances

Table_open_cache_hits

Table_open_cache_misses

Table_open_cache_overflows

Transactions_gtid_foreign_engine

Transactions_multi_engine

System variables added in MariaDB 10.3
Status variables added in MariaDB 10.4
Status variables added in MariaDB 10.2
Status variables added in MariaDB 10.1
Acl_package_body_grants
Acl_package_spec_grants
Com_alter_sequence
Com_create_package

Innodb_async_reads_total_enqueues

Innodb_async_reads_total_count

Innodb_async_reads_wait_slot_sec

Innodb_async_writes_pending

Innodb_async_writes_queue_size

Innodb_async_writes_tasks_running

Innodb_async_writes_total_enqueues

Innodb_async_writes_total_count

Innodb_async_writes_wait_slot_sec

tmp_space_used

System variables added in MariaDB 11.5
max_tmp_space_used
Innodb_async_reads_pending
Innodb_async_reads_queue_size
Innodb_async_reads_tasks_running
innodb_buffer_pool_instances
nnodb_buffer_pool_restore_at_startup
innodb_change_buffering_debug
innodb_corrupt_table_action
innodb_flush_checkpoint_debug
innodb_force_load_corrupted
innodb_import_table_from_xtrabackup
innodb_large_prefix
innodb_purge_batch_size
innodb_purge_threads
innodb_recovery_update_relay_log
innodb_rollback_segments
innodb_use_global_flush_log_at_trx_commit
innodb_use_native_aio

System Variables Added in MariaDB 10.3

This is a list of system variables that have been added in the series. The list does not include variables that are not part of the default release.

Variable
Added

For system variables that have been removed or deprecated, see .

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 10.2

This is a list of that have been added in the series. The list does not include variables that are not part of the default release.

Variable
Added

See Also

  • Status Variables Added in MariaDB 10.2

  • System Variables Added in MariaDB 10.3

  • System Variables Added in MariaDB 10.1

  • System Variables Added in MariaDB 10.0

This page is licensed: CC BY-SA / Gnu FDL

aria_recover_options

eq_range_index_dive_limit

innodb_adaptive_hash_index_parts

innodb_deadlock_detect

system variables

column_compression_threshold

column_compression_zlib_level

column_compression_zlib_strategy

column_compression_zlib_wrap

idle_readonly_transaction_timeout

idle_transaction_timeout

idle_write_transaction_timeout

in_predicate_conversion_threshold

innodb_encrypt_temporary_ables

innodb_instant_alter_column_allowed

log_disabled_statements

log_slow_disabled_statements

rpl_semi_sync_*

secure_timestamp

slave_transaction_retry_errors

slave_transaction_retry_interval

system_versioning_alter_history

system_versioning_asof

system_versioning_innodb_algorithm_simple

tcp_keepalive_interval

tcp_keepalive_probes

tcp_keepalive_time

version_source_revision

Upgrading from MariaDB 10.2 to MariaDB 10.3
Status Variables Added in MariaDB 10.3
System Variables Added in MariaDB 10.4
System Variables Added in MariaDB 10.2
System Variables Added in MariaDB 10.1
alter_algorithm
bind_address
binlog_file_cache_size
gtid_pos_auto_engines

Status Variables Added in MariaDB 10.5

This is a list of status variables that were added in the series.

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

System Variables Added in MariaDB 10.5

This is a list of system variables that have been added in the series. The list does not include variables that are not part of the default release.

Variable
Added

For system variables that have been removed or deprecated, see .

See Also

This page is licensed: CC BY-SA / Gnu FDL

Innodb_buffer_pool_pages_made_young

Innodb_buffer_pool_pages_old

Innodb_buffer_pool_pages_LRU_flushed

Innodb_buffered_aio_submitted

Innodb_checkpoint_age

Innodb_checkpoint_max_age

Innodb_deadlocks

Innodb_ibuf_discarded_delete_marks

Innodb_ibuf_discarded_deletes

Innodb_ibuf_discarded_inserts

Innodb_ibuf_free_list

Innodb_ibuf_merged_delete_marks

Innodb_ibuf_merged_deletes

Innodb_ibuf_merged_inserts

Innodb_ibuf_merges

Innodb_ibuf_segment_size

Innodb_ibuf_size

Innodb_lsn_current

Innodb_lsn_flushed

Innodb_lsn_last_checkpoint

Innodb_master_thread_active_loops

Innodb_master_thread_idle_loops

Innodb_max_trx_id

Innodb_mem_adaptive_hash

Innodb_mem_dictionary

performance_schema_index_stat_lost

performance_schema_memory_classes_lost

performance_schema_metadata_lock_lost

performance_schema_nested_statement_lost

performance_schema_prepared_statements_lost

performance_schema_program_lost

performance_schema_table_lock_stat_lost

S3_pagecache_blocks_not_flushed

S3_pagecache_blocks_unused

S3_pagecache_blocks_used

S3_pagecache_reads

System variables added in MariaDB 10.5
Status variables added in MariaDB 10.4
Status variables added in MariaDB 10.3
Innodb_adaptive_hash_hash_searches
Innodb_adaptive_hash_non_hash_searches
Innodb_background_log_sync
Innodb_buffer_pool_pages_made_not_young

optimizer_max_sel_arg_weight

performance_schema_events_transactions_history_long_size

performance_schema_events_transactions_history_size

performance_schema_max_index_stat

performance_schema_max_memory_classes

performance_schema_max_metadata_locks

performance_schema_max_prepared_statement_instances

performance_schema_max_program_instances

performance_schema_max_sql_text_length

performance_schema_max_statement_stack

performance_schema_max_table_lock_stat

require_secure_transport

s3_access_key

s3_block_size

s3_bucket

s3_debug

s3_host_name

s3_pagecache_age_threshold

s3_pagecache_buffer_size

s3_pagecache_division_limit

s3_pagecache_file_hash_size

s3_protocol_version

s3_region

s3_secret_key

server_uid

sql_if_exists

thread_pool_dedicated_listener

thread_pool_exact_stats

Upgrading from MariaDB 10.4 to MariaDB 10.5
Status Variables Added in MariaDB 10.5
System Variables Added in MariaDB 10.4
System Variables Added in MariaDB 10.3
binlog_row_metadata
innodb_instant_alter_column_allowed
innodb_lru_flush_size
innodb_max_purge_lag_wait
innodb_default_row_format
innodb_encrypt_temporary_ables
innodb_fill_factor
innodb_flush_sync
innodb_lock_schedule_algorithm
innodb_log_checksums
innodb_log_optimize_ddl
innodb_log_write_ahead_size
innodb_max_undo_log_size
innodb_page_cleaners
innodb_purge_rseg_truncate_frequency
innodb_safe_truncate
innodb_stats_include_delete_marked
innodb_temp_data_file_path
max_recursive_iterations
read_binlog_speed_limit
session_track_schema
session_track_state_change
session_track_system_variables
session_track_transaction_info
slave_parallel_workers
table_open_cache_instances
thread_pool_prio_kickup_timer
thread_pool_priority
tmp_disk_table_size
tmp_memory_table_size

Status Variables Added in MariaDB 10.0

This is a list of status variables that were added in the series.

The list excludes status related to the following storage engines included in :

  • Mroonga Status Variables

  • Spider Status Variables

Variable
Added

See also

This page is licensed: CC BY-SA / Gnu FDL

Status Variables Added in MariaDB 10.1

This is a list of that were added in the series.

The list excludes status related to the following storage engines included in :

Variable
Added

System Variables Added in MariaDB 11.3

This is a list of that have been added in the series.

Variable
Added

wsrep_applier_retry_count
wsrep_mode

Binlog_group_commit_trigger_count

Binlog_group_commit_trigger_timeout

Binlog_group_commit_trigger_lock_wait

Com_create_role

Com_drop_role

Com_get_diagnostics

Com_grant_role

System variables added in MariaDB 10.0
Status variables added in MariaDB 10.1

Galera Status Variables

See Also

  • System variables added in MariaDB 10.1

  • Status variables added in MariaDB 10.2

  • Status variables added in MariaDB 10.0

This page is licensed: CC BY-SA / Gnu FDL

Acl_column_grants

Acl_database_grants

status variables

Galera Status Variables
See Also
  • System Variables Added in MariaDB 11.2

This page is licensed: CC BY-SA / Gnu FDL

innodb_truncate_temporary_tablespace_now

redirect_url

system variables

System Variables Added in MariaDB 10.1

This is a list of system variables that were added in the series.

The list excludes the following variables, related to storage engines and plugins included in :

  • Spider System Variables

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

wsrep_status_file
wsrep_allowlist
wsrep_applier_thread_count
wsrep_rollbacker_thread_count
wsrep_certification_rules
wsrep_trx_fragment_size
wsrep_trx_fragment_unit
wsrep_certification_rules
wsrep_reject_queries
wsrep_certification_rules

default_tmp_storage_engine

encrypt_binlog

encrypt_tmp_disk_tables

encrypt_tmp_files

enforce_storage_engine

explicit_defaults_for_timestamp

innodb_background_scrub_data_check_interval

innodb_background_scrub_data_compressed

innodb_background_scrub_data_interval

innodb_background_scrub_data_uncompressed

innodb_buf_dump_status_frequency

innodb_compression_algorithm

innodb_default_encryption_key_id

innodb_default_row_format

innodb_defragment

innodb_defragment_fill_factor

innodb_defragment_fill_factor_n_recs

innodb_defragment_frequency

innodb_defragment_n_pages

innodb_defragment_stats_accuracy

innodb_disallow_writes

innodb_encrypt_log

innodb_encrypt_tables

innodb_encryption_rotate_key_age

innodb_encryption_rotation_iops

innodb_encryption_threads

innodb_fatal_semaphore_wait_threshold

innodb_force_primary_key

innodb_idle_flush_pct

innodb_immediate_scrub_data_uncompressed

innodb_instrument_semaphores

innodb_mtflush_threads

innodb_prefix_index_cluster_optimization

innodb_scrub_log

innodb_scrub_log_speed

innodb_use_mtflush

innodb_use_trim

log_bin_basename

log_bin_index

log_tc_size

max_digest_length

max_session_mem_used

max_statement_time

mysql56_temporal_format

relay_log_basename

strict_password_validation

skip_parallel_replication

slave_parallel_mode

slave_run_triggers_for_rbr

version_ssl_library

wsrep_certification_rules

wsrep_dirty_reads

Status Variables Added in MariaDB 10.1
System Variables Added in MariaDB 10.2
System Variables Added in MariaDB 10.0
aria_encrypt_tables
Com_revoke_grant
Com_show_explain
Com_start_all_slaves
Com_start_slave
Com_stop_all_slaves
Com_stop_slave
Connection_errors_accept
Connection_errors_internal
Connection_errors_max_connections
Connection_errors_peer_address
Connection_errors_select
Connection_errors_tcpwrap
Delete_scan
Feature_delay_key_write
Handler_external_lock
Handler_read_retry
Innodb_buffer_pool_dump_status
Innodb_buffer_pool_load_status
Innodb_master_thread_active_loops
Innodb_master_thread_idle_loops
Innodb_num_open_files
Innodb_system_rows_deleted
Innodb_system_rows_inserted
Innodb_system_rows_read
Innodb_system_rows_updated
Memory_used
Oqgraph_boost_version
Performance_schema_accounts_lost
Performance_schema_hosts_lost
Performance_schema_socket_classes_lost
Performance_schema_socket_instances_lost
Performance_schema_stage_classes_lost
Performance_schema_statement_classes_lost
Slave_skipped_errors
Sort_priority_queue_sorts
Update_scan
Acl_function_grants
Acl_procedure_grants
Acl_proxy_users
Acl_role_grants
Acl_roles
Acl_table_grants
Acl_users
Master_gtid_wait_count
Com_compound_sql
Com_create_temporary_table
Com_create_drop_table
Com_show_generic
Innodb_defragment_compression_failures
Innodb_defragment_count
Innodb_defragment_failures
Innodb_encryption_rotation_estimated_iops
Innodb_encryption_rotation_pages_flushed
Innodb_encryption_rotation_pages_modified
Innodb_encryption_rotation_pages_read_from_cache
Innodb_encryption_rotation_pages_read_from_disk
Innodb_have_bzip2
Innodb_have_lz4
Innodb_have_lzma
Innodb_have_lzo
Innodb_have_snappy
Innodb_num_index_pages_written
Innodb_num_non_index_pages_written
Innodb_onlineddl_pct_progress
Innodb_onlineddl_rowlog_pct_used
Innodb_onlineddl_rowlog_rows
Innodb_num_page_compressed_trim_op
Innodb_num_page_compressed_trim_op_saved
Innodb_num_pages_page_compressed
Innodb_num_pages_page_compression_error
Innodb_num_pages_page_decompressed
Innodb_num_pages_page_decrypted
Innodb_num_pages_page_encrypted
Innodb_page_compression_saved
Innodb_page_compression_trim_sect512
Innodb_page_compression_trim_sect1024
Innodb_page_compression_trim_sect2048
Innodb_page_compression_trim_sect4096
Innodb_page_compression_trim_sect8192
Innodb_page_compression_trim_sect16384
Innodb_page_compression_trim_sect32768
Innodb_secondary_index_triggered_cluster_reads
Innodb_secondary_index_triggered_cluster_reads_avoided
Master_gtid_wait_count
Master_gtid_wait_time
Master_gtid_wait_timeouts
Max_statement_time_exceeded

System Variables Added in MariaDB 10.0

This is a list of system variables that were added in the series.

The list excludes the following variables, related to storage engines and plugins included in :

  • Connect System Variables

  • Galera System Variables

  • Mroonga System Variables

Variable
Added

See Also

This page is licensed: CC BY-SA / Gnu FDL

aria_pagecache_file_hash_size

binlog_commit_wait_count

binlog_commit_wait_usec

default_master_connection

default_regex_flags

gtid_binlog_pos

Query Response Time Plugin Variables
Spider System Variables
Status Variables Added in MariaDB 10.0
System Variables Added in MariaDB 10.1
Upgrading from MariaDB 5.5 to MariaDB 10.0

gtid_binlog_state
gtid_current_pos
gtid_domain_id
gtid_ignore_duplicates
gtid_seq_no
gtid_slave_pos
gtid_strict_mode
histogram_size
histogram_type
innodb_adaptive_flushing_lwm
innodb_adaptive_max_sleep_delay
innodb_api_bk_commit_interval
innodb_api_disable_rowlock
innodb_api_enable_binlog
innodb_api_enable_mdl
innodb_api_trx_level
innodb_buffer_pool_dump_at_shutdown
innodb_buffer_pool_dump_now
innodb_buffer_pool_filename
innodb_buffer_pool_load_abort
innodb_buffer_pool_load_at_startup
innodb_buffer_pool_load_now
innodb_change_buffer_max_size
innodb_checksum_algorithm
innodb_cleaner_lsn_age_factor
innodb_cmp_per_index_enabled
innodb_compression_failure_threshold_pct
innodb_compression_level
innodb_compression_pad_pct_max
innodb_disable_sort_file_cache
innodb_empty_free_list_algorithm
innodb_flush_neighbors
innodb_foreground_preflush
innodb_ft_aux_table
innodb_ft_cache_size
innodb_ft_enable_diag_print
innodb_ft_enable_stopword
innodb_ft_max_token_size
innodb_ft_min_token_size
innodb_ft_num_word_optimize
innodb_ft_result_cache_limit
innodb_ft_server_stopword_table
innodb_ft_sort_pll_degree
innodb_ft_total_cache_size
innodb_ft_user_stopword_table
innodb_io_capacity_max
innodb_log_arch_dir
innodb_log_arch_expire_sec
innodb_log_archive
innodb_log_compressed_pages
innodb_max_dirty_pages_pct_lwm
innodb_max_purge_lag_delay
innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_online_alter_log_max_size
innodb_optimize_fulltext_only
innodb_random_read_ahead
innodb_read_only
innodb_recovery_stats
innodb_sched_priority_cleaner
innodb_simulate_comp_failures
innodb_sort_buffer_size
innodb_stats_auto_recalc
innodb_stats_modified_counter
innodb_stats_persistent
innodb_stats_persistent_sample_pages
innodb_stats_traditional
innodb_stats_transient_sample_pages
innodb_status_output
innodb_status_output_locks
innodb_sync_array_size
innodb_undo_directory
innodb_undo_logs
innodb_undo_tablespaces
key_cache_file_hash_size
last_gtid
oqgraph_allow_create_integer_latch
performance_schema_accounts_size
performance_schema_digests_size
performance_schema_events_stages_history_long_size
performance_schema_events_stages_history_size
performance_schema_events_statements_history_long_size
performance_schema_events_statements_history_size
performance_schema_hosts_size
performance_schema_max_digest_length
performance_schema_max_socket_classes
performance_schema_max_socket_instances
performance_schema_max_stage_classes
performance_schema_max_statement_classes
performance_schema_session_connect_attrs_size
performance_schema_setup_actors_size
performance_schema_setup_objects_size
performance_schema_users_size
slave_ddl_exec_mode
slave_domain_parallel_threads
slave_parallel_max_queued
slave_parallel_threads
ssl_crl
ssl_crlpath
use_stat_tables
version_malloc_library
MariaDB 11.6
MariaDB 11.6.2
MariaDB 11.6.2
MariaDB 11.6.1
MariaDB 11.7
MariaDB 11.7.0
MariaDB 11.7.1
MariaDB 11.7.0
MariaDB 11.7.1
MariaDB 11.7.1
MariaDB 11.7.1
MariaDB 11.7.1
MariaDB 11.7.0
MariaDB 10.8
MariaDB 10.8.1
MariaDB 10.8.4
MariaDB 11.0
MariaDB 11.0.2
MariaDB 11.5
MariaDB 11.5.2
MariaDB 11.5.1
MariaDB 11.5.2
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.2
MariaDB 10.9
MariaDB 10.9.1
MariaDB 10.9.1
MariaDB 11.2
MariaDB 11.2.0
MariaDB 11.2.0
MariaDB 11.2.0
MariaDB 11.2.0
MariaDB 11.2.1
MariaDB 11.2.5
MariaDB 11.2.6
MariaDB 11.2.4
MariaDB 11.2.5
MariaDB 11.2.4
MariaDB 11.2.6
MariaDB 11.2.5
MariaDB 10.10
MariaDB 10.10.1
MariaDB 10.10.1
MariaDB 10.10.7
MariaDB 10.10.7
MariaDB 10.10.1
MariaDB 10.10.1
MariaDB 10.10.1
MariaDB 11.0
MariaDB 11.0.1
MariaDB 11.0.1
MariaDB 11.0.1
MariaDB 11.0.4
MariaDB 11.0.6
MariaDB 11.0.6
MariaDB 11.0.4
MariaDB 10.4
MariaDB 10.4.5
MariaDB 10.4.1
MariaDB 10.4.2
MariaDB 10.4.5
MariaDB 10.4.7
MariaDB 10.4.7
MariaDB 10.4
MariaDB 10.4.3
MariaDB 10.4.3
MariaDB 10.4.3
MariaDB 10.4.1
MariaDB 10.4.7
MariaDB 10.4.13
MariaDB 10.4.2
MariaDB 10.4.3
MariaDB 10.4.3
MariaDB 10.4.0
MariaDB 10.4.6
MariaDB 10.4.3
MariaDB 10.4.2
MariaDB 10.4.2
MariaDB 10.2
MariaDB 10.2.0
MariaDB 10.2.3
MariaDB 10.2.0
MariaDB 10.2.0
MariaDB 10.2.2
MariaDB 10.2.4
MariaDB 10.2.4
MariaDB 10.2.4
MariaDB 10.2.4
MariaDB 11.1
MariaDB 11.1.6
MariaDB 11.1.5
MariaDB 11.1.6
MariaDB 11.1.3
MariaDB 11.1.3
MariaDB 11.1.6
MariaDB 11.1.0
MariaDB 11.1.0
MariaDB 5.5
MariaDB 5.5
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 5.5.20
MariaDB 10.3
MariaDB 10.3.5
MariaDB 10.3.5
MariaDB 10.3.1
MariaDB 10.3.5
MariaDB 10.3.5
MariaDB 10.3.0
MariaDB 10.3.5
MariaDB 10.3.5
MariaDB 10.3.0
MariaDB 10.3.5
MariaDB 10.3.5
MariaDB 10.3.5
MariaDB 10.3.5
MariaDB 10.3.7
MariaDB 10.3.7
MariaDB 10.3.0
MariaDB 10.3.5
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.1
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.1
MariaDB 10.3.1
MariaDB 11.5
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 11.5.0
MariaDB 10.3
MariaDB 10.3.7
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.1
MariaDB 10.3.2
MariaDB 10.3.2
MariaDB 10.3.2
MariaDB 10.3.2
MariaDB 10.3.0
MariaDB 10.3.0
MariaDB 10.3.0
MariaDB 10.3.18
MariaDB 10.3.17
MariaDB 10.3.23
MariaDB 10.3.1
MariaDB 10.3.1
MariaDB 10.3.3
MariaDB 10.3.7
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.4
MariaDB 10.3.4
MariaDB 10.3.4
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.3
MariaDB 10.3.2
MariaDB 10.3.13
MariaDB 10.3.6
MariaDB 10.2
MariaDB 10.2.0
MariaDB 10.2.18
MariaDB 10.2.2
MariaDB 10.2.6
MariaDB 10.2.2
MariaDB 10.2.26
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.3
MariaDB 10.2.2
MariaDB 10.2.17
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.19
MariaDB 10.2.6
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.3
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.0
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.2
MariaDB 10.2.7
MariaDB 10.2.7
MariaDB 10.2.22
MariaDB 10.5
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5.0
MariaDB 10.5.3
MariaDB 10.5.7
MariaDB 10.5.7
MariaDB 10.5.9
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5.2
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5
MariaDB 10.5.26
MariaDB 10.5.2
MariaDB 10.5.0
MariaDB 10.5.0
MariaDB 11.3
MariaDB 11.3.0
MariaDB 11.3.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.18
MariaDB 10.0.18
MariaDB 10.0.18
MariaDB 10.0.5
MariaDB 10.0.5
MariaDB 10.0.4
MariaDB 10.0.5
MariaDB 10.0.5
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.4
MariaDB 10.0.4
MariaDB 10.0.4
MariaDB 10.0.4
MariaDB 10.0.4
MariaDB 10.0.4
MariaDB 10.0.27
MariaDB 10.0.13
MariaDB 10.0.0
MariaDB 10.0.27
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.9
MariaDB 10.0.9
MariaDB 10.0.0
MariaDB 10.0.15
MariaDB 10.0.15
MariaDB 10.0.15
MariaDB 10.0.15
MariaDB 10.0.1
MariaDB 10.0.7
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.18
MariaDB 10.0.13
MariaDB 10.0.27
MariaDB 10.1
MariaDB 10.1
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.1
MariaDB 10.1.6
MariaDB 10.1.6
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1.3
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1
MariaDB 10.1.0
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1.2
MariaDB 10.1.2
MariaDB 10.1.0
MariaDB 10.1.2
MariaDB 10.1.2
MariaDB 10.1.2
MariaDB 10.1.2
MariaDB 10.1.2
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.4
MariaDB 10.1.1
MariaDB 10.1
MariaDB 10.1
MariaDB 10.1.3
MariaDB 10.1.0
MariaDB 10.1.7
MariaDB 10.1.3
MariaDB 10.1.5
MariaDB 10.1.4
MariaDB 10.1.8
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.6
MariaDB 10.1.0
MariaDB 10.1.4
MariaDB 10.1.32
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.1
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.2
MariaDB 10.1.0
MariaDB 10.1.2
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.0
MariaDB 10.1.2
MariaDB 10.1.3
MariaDB 10.1.4
MariaDB 10.1.0
MariaDB 10.1.0
MariaDB 10.1.6
MariaDB 10.1.6
MariaDB 10.1.3
MariaDB 10.1.5
MariaDB 10.1.21
MariaDB 10.1.1
MariaDB 10.1.2
MariaDB 10.1.6
MariaDB 10.1.2
MariaDB 10.1.3
MariaDB 10.1.3
MariaDB 10.1.1
MariaDB 10.1.3
MariaDB 10.1.38
MariaDB 10.1.3
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.13
MariaDB 10.0.5
MariaDB 10.0.5
MariaDB 10.0.1
MariaDB 10.0.11
MariaDB 10.0.3
MariaDB 10.0.5
MariaDB 10.0.3
MariaDB 10.0.2
MariaDB 10.0.10
MariaDB 10.0.2
MariaDB 10.0.3
MariaDB 10.0.3
MariaDB 10.0.2
MariaDB 10.0.2
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.9
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.9
MariaDB 10.0
MariaDB 10.0.9
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.9
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.9
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.9
MariaDB 10.0.9
MariaDB 10.0.9
MariaDB 10.0.9
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.9
MariaDB 10.0.14
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.15
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.16
MariaDB 10.0
MariaDB 10.0.14
MariaDB 10.0.14
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0
MariaDB 10.0.13
MariaDB 10.0.9
MariaDB 10.0.7
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.21
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.4
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.8
MariaDB 10.0.9
MariaDB 10.0.5
MariaDB 10.0.5
MariaDB 10.0.0
MariaDB 10.0.0
MariaDB 10.0.1
MariaDB 10.0.1