MariaDB 11.2 Changes & Improvements

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

New Features & Improvements

Online Schema Change

• 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 algorithm while simultaneously allowing concurrent on the altered table.

For more information, refer to, .

InnoDB

• The is now shrunk by reclaiming unused space at startup ()

JSON

• now allows retrieval of the key when iterating on JSON objects ()

• New functions , and to check for JSON intersection ()

• extracts key/value pairs from a JSON object ()

Miscellaneous

• All binlog* variables are now visible as system variables, specifically , , ()

• enhancement ()

• Temporary tables are now displayed in the , and ()

• : validation of stored program statements (

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