Changes and Improvements in MariaDB 11.1

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

Upgrading

New Features & Improvements

JSON

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

InnoDB

Mariabackup

Variables

List of All MariaDB 11.1 Releases

DateReleaseStatusRelease NotesChangelog
7 Feb 2024MariaDB 11.1.4Stable (GA)Release NotesChangelog
13 Nov 2023MariaDB 11.1.3Stable (GA)Release NotesChangelog
21 Aug 2023MariaDB 11.1.2Stable (GA)Release NotesChangelog
6 Jun 2023MariaDB 11.1.1RCRelease NotesChangelog
27 Mar 2023MariaDB 11.1.0AlphaRelease 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.