Changes and Improvements in MariaDB 11.2

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

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

MariaDB 11.2 is a short-term release series, and was maintained until November 2024.

Upgrading

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

New Features & Improvements

Online Schema Change

• ALTER TABLE can now do most operations with ALGORITHM=COPY, LOCK=NONE, that is, in most cases, unless the algorithm and lock level are explicitly specified, ALTER TABLE will be performed using the COPY algorithm while simultaneously allowing concurrent DML statements on the altered table.

InnoDB

• The InnoDB system tablespace is now shrunk by reclaiming unused space at startup (MDEV-14795)

JSON

• JSON_TABLE now allows retrieval of the key when iterating on JSON objects (MDEV-30145)

• New functions JSON_OBJECT_FILTER_KEYS, JSON_OBJECT_TO_ARRAY and JSON_ARRAY_INTERSECT to check for JSON intersection (MDEV-26182)

• JSON_KEY_VALUE extracts key/value pairs from a JSON object (MDEV-30145)

Miscellaneous

• All binlog* variables are now visible as system variables, specifically binlog_do_db, binlog_ignore_db, binlog_row_event_max_size (MDEV-30188)

• ALTER TABLE IMPORT enhancement (MDEV-26137)

• Temporary tables are now displayed in the Information Schema TABLES Table, SHOW TABLES and SHOW TABLE STATUS (MDEV-12459)

• Stored programs: validation of stored program statements (MDEV-5816)

• Remove the deprecated old_alter_table variable (MDEV-30905)

• Extend AES_ENCRYPT() and AES_DECRYPT() to support an initialization vector and algorithm (MDEV-9069)

Variables

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

Security Vulnerabilities Fixed in MariaDB 11.2

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

• CVE-2023-22084: MariaDB 11.2.3, MariaDB 11.2.2

List of All MariaDB 11.2 Releases

Date	Release	Status	Release Notes	Changelog
Date	Release	Status	Release Notes	Changelog
1 Nov 2024	MariaDB 11.2.6	Stable (GA)	Release Notes	Changelog
8 Aug 2024	MariaDB 11.2.5	Stable (GA)	Release Notes	Changelog
16 May 2024	MariaDB 11.2.4	Stable (GA)	Release Notes	Changelog
7 Feb 2024	MariaDB 11.2.3	Stable (GA)	Release Notes	Changelog
21 Nov 2023	MariaDB 11.2.2	Stable (GA)	Release Notes	Changelog
21 Aug 2023	MariaDB 11.2.1	RC	Release Notes	Changelog
20 Jun 2023	MariaDB 11.2.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}