MariaDB 10.7 Changes & Improvements

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

The most recent release of MariaDB 10.7 is:MariaDB 10.7.8 Stable (GA) Download Now

MariaDB 10.7 is a previous short-term maintenance stable series. The first stable release was in February 2022, and it was maintained for one year.

Upgrading

• See and .

New Features & Improvements

UUID

• New ()

JSON

• function to check for equality between JSON objects ().

• function, which recursively sorts keys and removes spaces ()

Natural Sort

• function ().

Optimization

• Improve simple multibyte collation performance on the ASCII range ().

Provider Plugins

• Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide to the server and storage engines (, ).

SFORMAT

• function for arbitrary text formatting ()

mariadb-dump

• Add option to as of specified timestamp ().

Convert Partitions

• ALTER TABLE ... CONVERT PARTITION .. TO TABLE (), and

• ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... () as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP

Password Reuse

• password_reuse_check plugin is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. ()

Replication

• Multi-source replication supports MySQL-style CHANNEL syntax ()

InnoDB Bulk Insert

• In bulk insert, pre-sort and build indexes one page at a time ()

Diagnostics

• supports a new condition property name ROW_NUMBER. In multi-row inserts it allows one to retrieve a number of a row that has caused the error (, )

Variables

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

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