MariaDB 10.6 Changes & Improvements

MariaDB 10.6 is a long-term maintenance stable version. The first stable release was in July 2021, and it will be maintained until July 2026.

Upgrading

• See and .

New Features & Improvements

See the page for items that are different between MariaDB Community Server 10.6 and MariaDB Enterprise Server 10.6.

Atomic DDL

• , , , , and related DDL statements . Either the statement is fully completed, or everything is reverted to it's original state. Note that when deleting multiple tables with DROP TABLE, only each individual drop is atomic, not the full list of tables). ().

SQL Syntax

• Implement SQL-standard ()

• Add syntax (InnoDB only) ()

• (, )

• , used to extract JSON data based on a JSON path expression and to return it as a relational table ()

Oracle Compatibility

• Anonymous (no AS clause) are permitted in ()

• added ()

• added ()

• added ()

InnoDB

• Optimization to speed up inserts into an empty table ()

• We intended to deprecate and eventually remove the . The first step was to make the tables , but this plan was abandoned from () ()

• now directly reflects the filesystem, and has been removed ()

Replication, Galera and Binlog

• Increase limit to 255, user to 128 ()

• The system variable, for turning on WSREP features which are not part of default behavior (including the experimental Aria replication) (, , )

• The delay between binary log purges can now be specified with much greater precision. The system variable is introduced as a form of alias for , which now accepts a precision of 1/1000000 days ()

Sys Schema

• Bundle , a collection of views, functions and procedures to help administrators get insight into database usage. ()

Performance Schema

• Merged replication instrumentation and tables (, )

Information Schema

• The views and have been added to the information schema ()

Storage Engines

• has been removed ()

• has been removed ()

Character Sets

• The utf8 (and related collations) is now by default an alias for utf8mb3 rather than the other way around. It can be set to imply utf8mb4 by changing the value of the system variable ()

General

• Bundle sys schema ()

• Do not resend unchanged resultset metadata for prepared statements ()

• now listens on both IPv6 and IPv4 addresses ()

• Support systemd socket activation ()

Variables

• For a list of all new variables, see and .

• has been reduced to 1000 ()

InnoDB Variables

The following deprecated variables have been removed ():

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