Changes and Improvements in MariaDB 10.9
Contents
MariaDB 10.9 is the current short-term branch, maintained until August 2023.
New Features & Improvements
JSON
- JSON_OVERLAPS function (MDEV-27677)
- Implement range notation for JSONPath (MDEV-27911)
- Support JSONPath negative index (MDEV-22224)
InnoDB
- innodb_log_file_size is now dynamic (MDEV-27812)
- InnoDB performance improvements (MDEV-27557, MDEV-28185, MDEV-27767, MDEV-28313, MDEV-28137, MDEV-28465, MDEV-26789)
- innodb_disallow_writes removed (MDEV-25975)
Hashicorp Key Management Plugin
- Hashicorp Key Management Plugin for implementing encryption using keys stored in the Hashicorp Vault KMS (MDEV-19281)
Replication and Galera
- Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for mariadb-binlog (MDEV-20119)
- Semisync-slave server recovery is extended to work on new server_id server (MDEV-27342)
- mariadb-binlog --stop-never --raw now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)
- JSON file interface to wsrep node state / SST progress logging (MDEV-26971)
SHOW ANALYZE FORMAT=JSON
- Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON] (MDEV-27021)
- Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN (MDEV-10000)
Variables
- For a list of all new variables, see System Variables Added in MariaDB 10.9.
- Merge old to old_mode sql variable (MDEV-24920)
The following variables have been deprecated:
- innodb_change_buffering
- old (replaced by old_mode)
List of All MariaDB 10.9 Releases
Date | Release | Status | Release Notes | Changelog |
---|---|---|---|---|
6 Feb 2023 | MariaDB 10.9.5 | Stable (GA) | Release Notes | Changelog |
7 Nov 2022 | MariaDB 10.9.4 | Stable (GA) | Release Notes | Changelog |
19 Sep 2022 | MariaDB 10.9.3 | Stable (GA) | Release Notes | Changelog |
22 Aug 2022 | MariaDB 10.9.2 | Stable (GA) | Release Notes | Changelog |
20 May 2022 | MariaDB 10.9.1 | RC | Release Notes | Changelog |
23 Mar 2022 | MariaDB 10.9.0 | Alpha | Release Notes |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.