MariaDB 10.6.0 Release Notes

The most recent release of MariaDB 10.6 is:MariaDB 10.6.21 Stable (GA) Download NowAlternate download from mariadb.org

Download 10.6.0Release NotesChangelogOverview of 10.6

Release date: 26 Apr 2021

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

MariaDB 10.6.0 is an Alpha release.

Do not use alpha releases in production!

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

Thanks, and enjoy MariaDB!

Notable Changes

This is the first alpha release in the MariaDB 10.6 series.

Notable changes of this release include:

SQL Syntax

• Indexes can be ignored (MDEV-7317)

• Implement SQL-standard SELECT ... OFFSET ... FETCH (MDEV-23908)

• Add SELECT ... SKIP LOCKED syntax (InnoDB only) (MDEV-13115)

• JSON_TABLE, used to extract JSON data based on a JSON path expression and to return it as a relational table (MDEV-17399)

Oracle Compatibility

• Anonymous subqueries in a FROM clause (no AS clause) are permitted in ORACLE mode

Storage Engines

• TokuDB has been removed (MDEV-19780)

• CassandraSE has been removed (MDEV-23024)

InnoDB

• Optimization to speed up inserts into an empty table (MDEV-515)

• Make InnoDB's COMPRESSED row format read-only by default (MDEV-23497)

• Information Schema SYS_TABLESPACES now directly reflects the filesystem, and SYS_DATAFILES has been removed (MDEV-22343)

• innodb_flush_method=O_DIRECT is enabled by default (MDEV-24854), and liburing replaces libaio on recent Linux kernels (MDEV-24883).

• The InnoDB transaction deadlock reporter was improved (MDEV-24738).

• The old MariaDB 5.5-compatible innodb checksum is no longer supported, only crc32 and full_crc32. Removed the *innodb and *none options from innodb_checksum_algorithm, and the --strict-check/-C and --write/-w options from innochecksum (MDEV-25105)

Replication, Galera and Binlog

• Increase master_host limit to 255, user to 128 (MDEV-24312)

• The wsrep_mode system variable, for turning on WSREP features which are not part of default behavior (including the experimental Aria replication) (MDEV-20008, MDEV-20715, MDEV-24946)

Sys Schema

• Bundle sys-schema, a collection of views, functions and procedures to help administrators get insight into database usage. (MDEV-9077)

Performance Schema

• Merged replication instrumentation and tables (MDEV-16437, MDEV-20220)

General

• Do not resend unchanged resultset metadata for prepared statements (MDEV-19237)

• --bind-address=hostname now listens on both IPv6 and IPv4 addresses (MDEV-6536)

• Support systemd socket activation (MDEV-5536)

• For the GSSAPI plugin, support AD or local group name, and SIDs on Windows (MDEV-23959)

• Check for $MARIADB_HOME/my.cnf (MDEV-21365)

• max_recursive_iterations has been reduced to 1000 (MDEV-17239)

• Setting system variables to negative values will no longer set them to the maximum value (MDEV-22219)

Galera

• wsrep_mode variable for turning on WSREP features which are not part of default behavior.

• wsrep_strict_ddl has been deprecated. Use wsrep_mode=STRICT_REPLICATION instead.

InnoDB Variables

The following deprecated variables have been removed (MDEV-23397):

• innodb_adaptive_max_sleep_delay

• innodb_background_scrub_data_check_interval

• innodb_background_scrub_data_compressed

• innodb_background_scrub_data_interval

• innodb_background_scrub_data_uncompressed

• innodb_buffer_pool_instances

• innodb_commit_concurrency

• innodb_concurrency_tickets

• innodb_file_format

• innodb_large_prefix

• innodb_log_checksums

• innodb_log_compressed_pages

• innodb_log_files_in_group

• innodb_log_optimize_ddl

• innodb_page_cleaners

• innodb_replication_delay

• innodb_scrub_log

• innodb_scrub_log_speed

• innodb_thread_concurrency

• innodb_thread_sleep_delay

• innodb_undo_logs

Changelog

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

Contributors

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

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.