Changes and Improvements in MariaDB 11.2
The most recent release of MariaDB 11.2 is:
MariaDB 11.2.6 Stable (GA) Download Now
Alternate download from mariadb.org
Contents
MariaDB 11.2 is a current short-term release series, maintained until November 2024.
Upgrading
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.
List of All MariaDB 11.2 Releases
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 |
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.