Changes and Improvements in MariaDB 10.7

MariaDB 10.7 is the current short-term support stable series. The first stable release was in February 2022, and it will be supported until February 2023.

Upgrading

New Features & Improvements

UUID

JSON

Natural Sort

Optimization

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

Provider Plugins

SFORMAT

mariadb-dump

Convert Partitions

  • ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166), 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

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. (MDEV-9245)

Replication

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

InnoDB Bulk Insert

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

Diagnostics

  • GET 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 (MDEV-10075, MDEV-26611)

Variables

The following deprecated variables have been removed :

Security Vulnerabilities Fixed in MariaDB 10.7

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.

List of All MariaDB 10.7 Releases

DateReleaseStatusRelease NotesChangelog
12 Feb 2022MariaDB 10.7.3Stable (GA)Release NotesChangelog
9 Feb 2022MariaDB 10.7.2Stable (GA)Release NotesChangelog
8 Nov 2021MariaDB 10.7.1RCRelease NotesChangelog
17 Sep 2021MariaDB 10.7.0AlphaRelease Notes

Comments

Comments loading...
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.