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.1Release NotesChangelogOverview 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 MariaDB 10.7.0 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 Performance Schema to improve documentation (MDEV-25325). For example:

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

Diagnostics

• The GET DIAGNOSTICS property introduced in MariaDB 10.7.0 to identify the affected row has been renamed to the more intuitive ROW_NUMBER (MDEV-26611, MDEV-10075)

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

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

• The redundant PARTITION keyword is now optional in the partition definition (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

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

• Linux after kernel version 5.10 has a io-uring regression causing a write to storage to be lost, or not acknowledged. As such innodb_use_native_aio will default to 0 (off) until 5.16. If innodb_use_native_aio 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 innodb_use_native_aio explicitly enabled, and are using watch out for a lack of InnoDB updates followed by a 10 minute timeout. See MDEV-26674 for details.

• ALTER TABLE…IMPORT TABLESPACE fixes (MDEV-18543, MDEV-20931, MDEV-26131, MDEV-26621)

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

Replication

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

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

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

Packaging & Misc

• Session tracking flag in OK_PACKET (MDEV-26868)

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

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

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

Security

• Fixes for the following security vulnerabilities:

  • CVE-`-```

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.7.1, see the MariaDB Foundation release announcement.

Do not use non-stable (non-GA) 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 the Distributions which Include MariaDB page.

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