> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](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-5.md).

# System Variables Added in MariaDB 10.5

This is a list of [system variables](/docs/server/server-management/variables-and-modes/server-system-variables.md) that have been added in the [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) series. The list does not include variables that are not part of the default release.

| Variable                                                                                                                                                                                                                  | Added                                                                                         |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------- |
| [binlog\_row\_metadata](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_row_metadata)                                                                          | [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)            |
| [innodb\_instant\_alter\_column\_allowed](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_instant_alter_column_allowed)                                                                | [MariaDB 10.5.3](/docs/release-notes/community-server/old-releases/10.5/10.5.3.md)            |
| [innodb\_lru\_flush\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_lru_flush_size)                                                                                             | [MariaDB 10.5.7](/docs/release-notes/community-server/old-releases/10.5/10.5.7.md)            |
| [innodb\_max\_purge\_lag\_wait](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_max_purge_lag_wait)                                                                                    | [MariaDB 10.5.7](/docs/release-notes/community-server/old-releases/10.5/10.5.7.md)            |
| [optimizer\_max\_sel\_arg\_weight](/docs/server/server-management/variables-and-modes/server-system-variables.md#optimizer_max_sel_arg_weight)                                                                            | [MariaDB 10.5.9](/docs/release-notes/community-server/old-releases/10.5/10.5.9.md)            |
| [performance\_schema\_events\_transactions\_history\_long\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_transactions_history_long_size) | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_events\_transactions\_history\_size](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_events_transactions_history_size)            | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_index\_stat](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_index_stat)                                                 | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_memory\_classes](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_memory_classes)                                         | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_metadata\_locks](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_metadata_locks)                                         | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_prepared\_statement\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_prepared_statement_instances)            | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_program\_instances](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_program_instances)                                   | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_sql\_text\_length](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_sql_text_length)                                      | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_statement\_stack](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_statement_stack)                                       | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [performance\_schema\_max\_table\_lock\_stat](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#performance_schema_max_table_lock_stat)                                      | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [require\_secure\_transport](/docs/server/server-management/variables-and-modes/server-system-variables.md#require_secure_transport)                                                                                      | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [s3\_access\_key](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_access_key)                                                                                        | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_block\_size](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_block_size)                                                                                        | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_bucket](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_bucket)                                                                                                 | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_debug](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_debug)                                                                                                   | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_host\_name](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_host_name)                                                                                          | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_pagecache\_age\_threshold](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_pagecache_age_threshold)                                                             | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_pagecache\_buffer\_size](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_pagecache_buffer_size)                                                                 | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_pagecache\_division\_limit](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_pagecache_division_limit)                                                           | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_pagecache\_file\_hash\_size](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_pagecache_file_hash_size)                                                          | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_protocol\_version](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_protocol_version)                                                                            | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_region](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_region)                                                                                                 | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [s3\_secret\_key](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_secret_key)                                                                                        | [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) |
| [server\_uid](/docs/server/server-management/variables-and-modes/server-system-variables.md#server_uid)                                                                                                                   | [MariaDB 10.5.26](/docs/release-notes/community-server/old-releases/10.5/10.5.26.md)          |
| [sql\_if\_exists](/docs/server/server-management/variables-and-modes/server-system-variables.md#sql_if_exists)                                                                                                            | [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)            |
| [thread\_pool\_dedicated\_listener](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md#thread_pool_dedicated_listener)                 | [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)            |
| [thread\_pool\_exact\_stats](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md#thread_pool_exact_stats)                               | [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)            |

For system variables that have been removed or deprecated, see [Upgrading from MariaDB 10.4 to MariaDB 10.5](/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.md).

## See Also

* [Status Variables Added in MariaDB 10.5](/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.md)
* [System Variables Added in MariaDB 10.4](/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.md)
* [System Variables Added in MariaDB 10.3](/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.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}
