> 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/release-notes/community-server/old-releases/10.9/10.9.0.md). # MariaDB 10.9.0 Release Notes The most recent release of [MariaDB 10.9](/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109.md) is:[**MariaDB 10.9.8**](/docs/release-notes/community-server/old-releases/10.9/10.9.8.md) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/10.9.8/) [Download 10.9.0](https://downloads.mariadb.org/mariadb/10.9.0) | [Release Notes](/docs/release-notes/community-server/old-releases/10.9/10.9.0.md) | Changelog | [Overview of 10.9](/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109.md) **Release date:** 23 March 2022 **Do not use *****alpha***** releases in production!** [MariaDB 10.9](/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109.md) is a current development series of MariaDB. It is an evolution of [MariaDB 10.8](/docs/release-notes/community-server/old-releases/10.8/what-is-mariadb-108.md) with several entirely new features. [MariaDB 10.9.0](/docs/release-notes/community-server/old-releases/10.9/10.9.0.md) is not a single release, but is instead a number of preview releases based on feature branches. Each should be considered [***Alpha***](/docs/release-notes/community-server/about/release-criteria.md).\ Read more about feature preview releases [here](https://mariadb.org/preview-releases/). Thanks, and enjoy MariaDB! Remember, these features are in separate *preview packages*. The subsection header text corresponds to the preview package name. ### JSON * [JSON\_OVERLAPS](/docs/server/reference/sql-functions/special-functions/json-functions/json_overlaps.md) function ([MDEV-27677](https://jira.mariadb.org/browse/MDEV-27677)) * Implement range notation for [JSONPath](/docs/server/reference/sql-functions/special-functions/json-functions/jsonpath-expressions.md) ([MDEV-27911](https://jira.mariadb.org/browse/MDEV-27911)) * Support [JSONPath](/docs/server/reference/sql-functions/special-functions/json-functions/jsonpath-expressions.md) negative index ([MDEV-22224](https://jira.mariadb.org/browse/MDEV-22224)) ### SHOW ANALYZE FORMAT=JSON * Extend [SHOW EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-explain.md) to support \[SHOW ANALYZE [FORMAT=JSON](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-analyze.md)] ([MDEV-27021](https://jira.mariadb.org/browse/MDEV-27021)) * Add EXPLAIN FOR CONNECTION syntax support to [SHOW EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-explain.md) ([MDEV-10000](https://jira.mariadb.org/browse/MDEV-10000)) ### Async redo log write * Asynchronous [redo log](/docs/server/server-usage/storage-engines/innodb/innodb-redo-log.md) write ([MDEV-26603](https://jira.mariadb.org/browse/MDEV-26603)) (not included in [MariaDB 10.9.1](/docs/release-notes/community-server/old-releases/10.9/10.9.1.md)) ### Miscellaneous * Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for [mariadb-binlog/mysqlbinlog](/docs/server/clients-and-utilities/logging-tools/mariadb-binlog.md) ([MDEV-20119](https://jira.mariadb.org/browse/MDEV-20119)) * [information\_schema.tables.table\_type](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-tables-table.md) now shows TEMPORARY for local temporary tables ([MDEV-12459](https://jira.mariadb.org/browse/MDEV-12459)) (not included in [MariaDB 10.9.1](/docs/release-notes/community-server/old-releases/10.9/10.9.1.md)) * Merge [old](/docs/server/server-management/variables-and-modes/server-system-variables.md#old) to [old\_mode](/docs/server/server-management/variables-and-modes/server-system-variables.md#old_mode) sql variable ([MDEV-24920](https://jira.mariadb.org/browse/MDEV-24920)) * [Hashicorp Key Management Plugin](/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/hashicorp-key-management-plugin.md) for implementing [encryption](/docs/server/security/encryption/data-at-rest-encryption.md) using keys stored in the Hashicorp Vault KMS ([MDEV-19281](https://jira.mariadb.org/browse/MDEV-19281)) * JSON file interface to wsrep node state / SST progress logging ([MDEV-26971](https://jira.mariadb.org/browse/MDEV-26971)) * Allow [innodb\_log\_file\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_file_size) to change without server restart ([MDEV-27812](https://jira.mariadb.org/browse/MDEV-27812)) {% 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](/docs/general-resources/distributions-including-mariadb.md) page. {% endhint %} *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formid="4316" formId="4316" %}