Changes and Improvements in MariaDB 11.1

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)

Mariabackup

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

Variables

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

List of All MariaDB 11.1 Releases