MariaDB 11.1 Changes & Improvements

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 and .

New Features & Improvements

JSON

• function for validating a JSON schema ()

Optimizer

• for single-table / 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 ()

• Queries with the or 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 ()

Transactions

• The option is now a system variable, and the tx_isolation system variable is deprecated ()

InnoDB

• Remove and related parameters ()

mariadb-backup

• Rename xtrabackup_* files to mariadb_backup_* ()

Variables

• For a list of all new variables, see .

Security Vulnerabilities Fixed in

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

• :

• :

List of All Releases