# MariaDB 10.9 Changes & Improvements
[MariaDB 10.9](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109) is no longer maintained. Please use a [more recent release](https://mariadb.com/docs/release-notes/latest-releases).
The most recent release of [MariaDB 10.9](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109) is:[**MariaDB 10.9.8**](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.8) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/10.9.8/)
[MariaDB 10.9](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109) is a previous short-term release series. The first stable release was in August 2022, and it was [maintained until](https://mariadb.org/about/#maintenance-policy) August 2023.
## Upgrading
* See [Upgrading Between Major MariaDB Versions](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-on-linux/upgrading-between-major-mariadb-versions) and [Upgrading from MariaDB 10.8 to MariaDB 10.9](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109).
## New Features & Improvements
### JSON
* [JSON\_OVERLAPS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/special-functions/json-functions/json_overlaps) function ([MDEV-27677](https://jira.mariadb.org/browse/MDEV-27677))
* Implement range notation for [JSONPath](https://github.com/mariadb-corporation/docs-release-notes/blob/test/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/JSONPath_Expressions/README.md) ([MDEV-27911](https://jira.mariadb.org/browse/MDEV-27911))
* Support [JSONPath](https://github.com/mariadb-corporation/docs-release-notes/blob/test/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/JSONPath_Expressions/README.md) negative index ([MDEV-22224](https://jira.mariadb.org/browse/MDEV-22224))
### InnoDB
* [innodb\_log\_file\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_file_size) is now dynamic ([MDEV-27812](https://jira.mariadb.org/browse/MDEV-27812))
* InnoDB performance improvements ([MDEV-27557](https://jira.mariadb.org/browse/MDEV-27557), [MDEV-28185](https://jira.mariadb.org/browse/MDEV-28185), [MDEV-27767](https://jira.mariadb.org/browse/MDEV-27767), [MDEV-28313](https://jira.mariadb.org/browse/MDEV-28313), [MDEV-28137](https://jira.mariadb.org/browse/MDEV-28137), [MDEV-28465](https://jira.mariadb.org/browse/MDEV-28465), [MDEV-26789](https://jira.mariadb.org/browse/MDEV-26789))
* [innodb\_disallow\_writes](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-system-variables#innodb_disallow_writes) removed ([MDEV-25975](https://jira.mariadb.org/browse/MDEV-25975))
### Hashicorp Key Management Plugin
* [Hashicorp Key Management Plugin](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/hashicorp-key-management-plugin) for implementing [encryption](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/encryption/data-at-rest-encryption) using keys stored in the Hashicorp Vault KMS ([MDEV-19281](https://jira.mariadb.org/browse/MDEV-19281))
### Replication and Galera
* Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for [mariadb-binlog](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/logging-tools/mariadb-binlog) ([MDEV-20119](https://jira.mariadb.org/browse/MDEV-20119))
* Semisync-slave server recovery is extended to work on new server\_id server ([MDEV-27342](https://jira.mariadb.org/browse/MDEV-27342))
* [mariadb-binlog --stop-never --raw](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/logging-tools/mariadb-binlog/mariadb-binlog-options) now flushes the result file to disk after each processed event so the file can be listed with the actual bytes ([MDEV-14608](https://jira.mariadb.org/browse/MDEV-14608))
* JSON file interface to wsrep node state / SST progress logging ([MDEV-26971](https://jira.mariadb.org/browse/MDEV-26971))
### SHOW ANALYZE FORMAT=JSON
* Extend [SHOW EXPLAIN](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/administrative-sql-statements/show/show-explain) to support SHOW ANALYZE \[FORMAT=JSON] ([MDEV-27021](https://jira.mariadb.org/browse/MDEV-27021))
* Add EXPLAIN FOR CONNECTION syntax support to [SHOW EXPLAIN](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/administrative-sql-statements/show/show-explain) ([MDEV-10000](https://jira.mariadb.org/browse/MDEV-10000))
### Variables
* For a list of all new variables, see [System Variables Added in MariaDB 10.9](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/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-9).
* Merge [old](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#old) to [old\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#old_mode) sql variable ([MDEV-24920](https://jira.mariadb.org/browse/MDEV-24920))
The following variables have been deprecated:
* [innodb\_change\_buffering](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-system-variables#innodb_change_buffering)
* [old](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#old) (replaced by [old\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#old_mode))
and [Status Variables Added in MariaDB 10.9](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109).
## Security Vulnerabilities Fixed in [MariaDB 10.9](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109)
For a complete list of security vulnerabilities (CVEs) fixed across all\
versions of MariaDB, see the [Security Vulnerabilities Fixed in MariaDB](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/cve)\
page.
* [CVE-2022-47015](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-47015): [MariaDB 10.9.6](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.6)
* [CVE-2022-38791](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-38791): [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes)
* [CVE-2022-32091](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-32091): [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes)
* [CVE-2022-32089](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-32089): [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes)
* [CVE-2022-32084](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-32084): [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes)
* [CVE-2022-32082](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-32082): [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes)
* [CVE-2022-32081](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-32081): [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes)
* [CVE-2018-25032](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2018-25032): [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes)
## List of All [MariaDB 10.9](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109) Releases
| Date | Release | Status | Release Notes | Changelog |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------- |
| 14 Aug 2023 | [MariaDB 10.9.8](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.8) | Stable (GA) | [Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.8) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.8) |
| 7 Jun 2023 | [MariaDB 10.9.7](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.7) | Stable (GA) | [Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.7) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.7) |
| 10 May 2023 | [MariaDB 10.9.6](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.6) | Stable (GA) | [Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.6) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.6) |
| 6 Feb 2023 | [MariaDB 10.9.5](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.5) | Stable (GA) | [Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.5) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.5) |
| 7 Nov 2022 | [MariaDB 10.9.4](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-10-9-4-release-notes) | Stable (GA) | [Release Notes](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.4) |
| 19 Sep 2022 | [MariaDB 10.9.3](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.3) | Stable (GA) | [Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.3) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.3) |
| 22 Aug 2022 | [MariaDB 10.9.2](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/mariadb-1092-release-notes) | Stable (GA) | [Release Notes](https://github.com/mariadb-corporation/docs-server/blob/test/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-9-series/broken-reference/README.md) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.2) |
| 20 May 2022 | [MariaDB 10.9.1](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.1) | RC | [Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.1) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/10.9/10.9.1) |
| 23 Mar 2022 | [MariaDB 10.9.0](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.0) | Alpha | [Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/10.9.0) | |
{% hint style="info" %}
Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the [Distributions which Include MariaDB](https://app.gitbook.com/s/WCInJQ9cmGjq1lsTG91E/distributions-including-mariadb) page.
{% endhint %}
*This page is licensed: CC BY-SA / Gnu FDL*
{% @marketo/form formid="4316" formId="4316" %}
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://mariadb.com/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.