# System Variables Added in MariaDB 10.5 This is a list of [system variables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables) that have been added in the [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) series. The list does not include variables that are not part of the default release. | Variable | Added | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------- | | [binlog\_row\_metadata](https://mariadb.com/docs/server/standard-replication/replication-and-binary-log-system-variables#binlog_row_metadata) | [MariaDB 10.5.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.0) | | [innodb\_instant\_alter\_column\_allowed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_instant_alter_column_allowed) | [MariaDB 10.5.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.3) | | [innodb\_lru\_flush\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_lru_flush_size) | [MariaDB 10.5.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.7) | | [innodb\_max\_purge\_lag\_wait](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_max_purge_lag_wait) | [MariaDB 10.5.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.7) | | [optimizer\_max\_sel\_arg\_weight](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#optimizer_max_sel_arg_weight) | [MariaDB 10.5.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.9) | | [performance\_schema\_events\_transactions\_history\_long\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_transactions_history_long_size) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_events\_transactions\_history\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_transactions_history_size) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_index\_stat](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_index_stat) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_memory\_classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_memory_classes) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_metadata\_locks](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_metadata_locks) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_prepared\_statement\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_prepared_statement_instances) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_program\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_program_instances) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_sql\_text\_length](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_sql_text_length) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_statement\_stack](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_statement_stack) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [performance\_schema\_max\_table\_lock\_stat](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_table_lock_stat) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [require\_secure\_transport](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#require_secure_transport) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [s3\_access\_key](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_access_key) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_block\_size](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_block_size) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_bucket](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_bucket) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_debug](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_debug) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_host\_name](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_host_name) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_pagecache\_age\_threshold](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_pagecache_age_threshold) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_pagecache\_buffer\_size](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_pagecache_buffer_size) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_pagecache\_division\_limit](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_pagecache_division_limit) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_pagecache\_file\_hash\_size](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_pagecache_file_hash_size) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_protocol\_version](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_protocol_version) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_region](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_region) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [s3\_secret\_key](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables#s3_secret_key) | [MariaDB 10.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/what-is-mariadb-105) | | [server\_uid](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#server_uid) | [MariaDB 10.5.26](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.26) | | [sql\_if\_exists](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#sql_if_exists) | [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2) | | [thread\_pool\_dedicated\_listener](https://mariadb.com/docs/server/ha-and-performance/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables#thread_pool_dedicated_listener) | [MariaDB 10.5.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.0) | | [thread\_pool\_exact\_stats](https://mariadb.com/docs/server/ha-and-performance/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables#thread_pool_exact_stats) | [MariaDB 10.5.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.0) | For system variables that have been removed or deprecated, see [Upgrading from MariaDB 10.4 to MariaDB 10.5](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-4-to-mariadb-10-5). ## See Also * [Status Variables Added in MariaDB 10.5](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-105) * [System Variables Added in MariaDB 10.4](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-4) * [System Variables Added in MariaDB 10.3](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-3) *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}