All pages
Powered by GitBook
1 of 1

Loading...

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.0 | Release Notes | Changelog | Overview 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 to the server and storage engines (, ).

SFORMAT

  • function for arbitrary text formatting (, ).

UUID

  • New (, )

Natural Sort

  • function (, ).

JSON Histograms

  • Histograms in the statistics tables are more precise and stored as JSON, not binary (, , ). Note that this feature was not included in .

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

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

Password Reuse

  • The 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. (, ).

InnoDB Bulk Insert

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

Misc. Features

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

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

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

  • Add option to as of specified timestamp ().

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

Do not use alpha releases in production!

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

  • 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)

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

  • MDEV-12933
    blog post
    MDEV-25015
    blog post
    MDEV-4958
    blog post
    MDEV-4742
    blog post
    MDEV-21130
    MDEV-26519
    blog post
    MariaDB 10.7.1
    MDEV-22166
    blog post
    MDEV-22165
    MDEV-26471
    MDEV-9245
    blog post
    MDEV-24621
    MDEV-23143
    MDEV-16375
    MDEV-26572
    MDEV-16355
    MariaDB 10.7.0
    changelog

    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 the page.

    wsrep_replicate_myisam
    wsrep_strict_ddl
    Distributions which Include MariaDB
    compression capabilities
    SFORMAT
    UUID data type
    NATURAL_SORT_KEY
    password_reuse_check plugin
    JSON_EQUALS
    JSON_NORMALIZE
    dump
    system versioned table
    GET DIAGNOSTICS

    This page is licensed: CC BY-SA / Gnu FDL