MariaDB 10.7.0 Release Notes

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

Download 10.7.0Release NotesChangelogOverview of 10.7

Release date: 17 Sep 2021

Do not use alpha releases in production!

MariaDB 10.7 is the current development series of MariaDB. It is an evolution of MariaDB 10.6 with several entirely new features.

MariaDB 10.7.0 is not a single release, but is instead a number of feature preview releases based on feature branches. Each should be considered as having a maturity of an Alpha release. Read more about feature preview releases here.

Thanks, and enjoy MariaDB!

Remember, these features are in separate preview packages. The subsection header text corresponds to the preview package name.

Notable changes of this series of releases include:

Provider Plugins

• Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide compression capabilities to the server and storage engines (MDEV-12933, blog post).

SFORMAT

• SFORMAT function for arbitrary text formatting (MDEV-25015, blog post).

UUID

• New UUID data type (MDEV-4958, blog post)

Natural Sort

• NATURAL_SORT_KEY function (MDEV-4742, blog post).

JSON Histograms

• Histograms in the statistics tables are more precise and stored as JSON, not binary (MDEV-21130, MDEV-26519, blog post). Note that this feature was not included in MariaDB 10.7.1.

Convert Partitions

• ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166, blog post), and

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

• ALTER TABLE .. ADD PARTITION allows to omit the redundant PARTITION keyword (MDEV-26471)

Password Reuse

• The 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. (MDEV-9245, blog post).

InnoDB Bulk Insert

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

Misc. Features

• JSON_EQUALS function to check for equality between JSON objects (MDEV-23143).

• JSON_NORMALIZE function, which recursively sorts keys and removes spaces (MDEV-16375)

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

• Add option to dump system versioned table as of specified timestamp (MDEV-16355).

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

• GET DIAGNOSTICS supports a new condition property name ERROR_INDEX. In multi-row inserts it allows to retrieve a number of a row that has caused the error (MDEV-10075)

• wsrep_replicate_myisam andwsrep_strict_ddl deprecated system variables were removed (MDEV-24947, MDEV-24843)

Do not use alpha releases on production systems! For a complete list of changes made in MariaDB 10.7.0, with links to detailed information on each push, see the changelog.

Do not use alpha releases in production!

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 theDistributions which Include MariaDB page.