All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 10.7.1 Release Notes

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

Download 10.7.1 | Release Notes | Changelog | Overview of 10.7

Release date: 8 Nov 2021

Do not use non-stable (non-GA) 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.1 is a Release Candidate (RC) release.

For an overview of MariaDB 10.7 see theWhat is MariaDB 10.7? page.

Thanks, and enjoy MariaDB!

Notable Items

This release includes all features from the preview releases except for the JSON histogram preview feature, which was not ready in time to be included.

Performance Schema

  • Comments have been added for each table column in the to improve documentation (). For example:

Diagnostics

  • The property introduced in to identify the affected row has been renamed to the more intuitive ROW_NUMBER (, )

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

Convert Partitions

  • (, ), and

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

  • The redundant PARTITION keyword is now optional in the ()

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

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

  • Linux after kernel version 5.10 has a io-uring regression causing a write to storage to be lost, or not acknowledged. As such will default to 0 (off) until 5.16. If is enabled in your configuration, a warning will be logged, however it will continue with the io-uring enabled, potentially resulting in a hang, or an assertion later. The long term support kernel 5.14.14 we haven't observed failures, and 5.15.0-rc7 failures have been observed, though less frequently. If you have explicitly enabled, and are using watch out for a lack of InnoDB updates followed by a 10 minute timeout. See for details.

  • ALTER TABLE…IMPORT TABLESPACE fixes (, , ,

Replication

  • Memory hogging on slave by ROW event applier is eliminated ()

  • mysql --binary-mode now properly handles \\0 in data ()

  • Fixes race condition between SHOW BINARY LOGS and RESET MASTER ()

Packaging & Misc

  • Session tracking flag in OK_PACKET ()

  • Some views force server (and mysqldump) to generate invalid SQL for their definitions ()

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

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

Security

  • Fixes for the following :

    • CVE-`-```

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

Do not use non-stable (non-GA) releases in production!

)
  • innodb_undo_log_truncate fixes (MDEV-26445, MDEV-26450, MDEV-26672, MDEV-26864)

  • Page I/O performance fixes (MDEV-25215, MDEV-26547, MDEV-26626, MDEV-26819)

  • Replication timeouts with XA PREPARE (MDEV-26682)

  • Improved DDL and data dictionary (MDEV-25919)

  • Performance fixes (MDEV-26356, MDEV-26467, MDEV-26826)

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

  • Add option to as of specified timestamp (MDEV-16355).

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

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

  • MariaDB 10.7.0
    MDEV-25325
    GET DIAGNOSTICS
    MariaDB 10.7.0
    MDEV-26611
    MDEV-10075
    MDEV-12933
    blog post
    MDEV-25015
    blog post
    MDEV-4958
    blog post
    MDEV-4742
    blog post
    MDEV-22166
    blog post
    MDEV-22165
    MDEV-26471
    MDEV-9245
    blog post
    MDEV-24621
    innodb_use_native_aio
    innodb_use_native_aio
    innodb_use_native_aio
    MDEV-26674
    MDEV-18543
    MDEV-20931
    MDEV-26131
    MDEV-26712
    MDEV-25444
    MDEV-20215
    MDEV-26868
    MDEV-26299
    MDEV-23143
    MDEV-16375
    MariaDB 10.7.1
    changelog
    MariaDB 10.7.1
    MariaDB Foundation release announcement
    MDEV-26621
    SELECT column_name, column_comment FROM information_schema.columns 
      WHERE table_schema='performance_schema' AND table_name='file_instances';
    ...
    *************************** 2. row ***************************
       column_name: EVENT_NAME
    column_comment: Instrument name associated with the file.
    *************************** 3. row ***************************
       column_name: OPEN_COUNT
    column_comment: Open handles on the file. A value of greater than zero means 
                    that the file is currently open.
    ...

    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
    Performance Schema
    compression capabilities
    SFORMAT
    UUID data type
    NATURAL_SORT_KEY
    ALTER TABLE ... CONVERT PARTITION .. TO TABLE
    ALTER TABLE ... CONVERT TABLE ... TO PARTITION ...
    partition definition
    password_reuse_check plugin
    JSON_EQUALS
    JSON_NORMALIZE
    security vulnerabilities
    dump
    system versioned table

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