Changes and Improvements in MariaDB 11.1

MariaDB 11.1 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download NowAlternate download from mariadb.org

MariaDB 11.1 is a short-term release series, and was maintained until August 2024.

Upgrading

• See Upgrading Between Major MariaDB Versions and Upgrading from MariaDB 11.0 to MariaDB 11.1.

New Features & Improvements

JSON

• JSON_SCHEMA_VALID function for validating a JSON schema (MDEV-27128)

Optimizer

• Semi-join optimization for single-table UPDATE/DELETE statements. Update and delete statements that use subqueries can now use all subquery optimization strategies that MariaDB offers, so now if you use subqueries in UPDATE or DELETE, these statements will likely be much faster (MDEV-7487)

• Queries with the DATE or YEAR functions comparing against a constant can now make use of indexes, so these will be noticeably quicker in certain instances. For example SELECT * FROM t2 WHERE YEAR(a) = 2019 or SELECT * FROM t2 WHERE DATE(a) <= '2017-01-01'. See Sargable DATE and YEAR (MDEV-8320)

Transactions

• The transaction_isolation option is now a system variable, and the tx_isolation system variable is deprecated (MDEV-21921)

InnoDB

• Remove innodb_defragment and related parameters (MDEV-30545)

mariadb-backup

• Rename mariadb-backup’s xtrabackup_* files to mariadb_backup_* (MDEV-18931)

Variables

• For a list of all new variables, see System Variables Added in MariaDB 11.1.

Security Vulnerabilities Fixed in MariaDB 11.1

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.

• CVE-2024-21096: MariaDB 11.1.5

• CVE-2023-22084: MariaDB 11.1.3

List of All MariaDB 11.1 Releases

Date	Release	Status	Release Notes	Changelog
Date	Release	Status	Release Notes	Changelog
8 Aug 2024	MariaDB 11.1.6	Stable (GA)	Release Notes	Changelog
16 May 2024	MariaDB 11.1.5	Stable (GA)	Release Notes	Changelog
7 Feb 2024	MariaDB 11.1.4	Stable (GA)	Release Notes	Changelog
13 Nov 2023	MariaDB 11.1.3	Stable (GA)	Release Notes	Changelog
21 Aug 2023	MariaDB 11.1.2	Stable (GA)	Release Notes	Changelog
6 Jun 2023	MariaDB 11.1.1	RC	Release Notes	Changelog
27 Mar 2023	MariaDB 11.1.0	Alpha	Release Notes

Be notified of new MariaDB Server releases automatically by subscribing 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 page.

_{This page is licensed: CC BY-SA / Gnu FDL}