All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 10.6.0 Release Notes

MariaDB 10.6.0 is a preview release of MariaDB Community Server 10.6, released on 2021-04-26

Download Release Notes Changelog Overview 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.

Thanks, and enjoy MariaDB!

Notable Changes

This is the first alpha release in the series.

Notable changes of this release include:

SQL Syntax

  • ()

  • Implement SQL-standard ()

  • Add syntax (InnoDB only) ()

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

Oracle Compatibility

  • Anonymous (no AS clause) are permitted in

Storage Engines

  • has been removed ()

  • has been removed ()

InnoDB

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

  • Make ()

  • now directly reflects the filesystem, and has been removed ()

  • innodb_flush_method=O_DIRECT

Replication, Galera and Binlog

  • Increase limit to 255, user to 128 ()

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

Sys Schema

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

Performance Schema

  • Merged replication instrumentation and tables (, )

General

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

  • now listens on both IPv6 and IPv4 addresses ()

  • Support systemd socket activation ()

  • For the , support AD or local group name, and SIDs on Windows ()

Galera

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

  • has been deprecated. Use instead.

InnoDB Variables

The following deprecated variables have been removed ():

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 alpha releases in production!

is enabled by default (
), and liburing replaces libaio on recent Linux kernels (
).
  • 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 , and the --strict-check/-C and --write/-w options from (MDEV-25105)

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

  • has been reduced to 1000 (MDEV-17239)

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

  • MariaDB 10.6
    MDEV-7317
    MDEV-23908
    MDEV-13115
    MDEV-17399
    ORACLE mode
    MDEV-19780
    MDEV-23024
    MDEV-515
    MDEV-23497
    MDEV-22343
    MDEV-24312
    MDEV-20008
    MDEV-20715
    MDEV-24946
    MDEV-9077
    MDEV-16437
    MDEV-20220
    MDEV-19237
    MDEV-6536
    MDEV-5536
    MDEV-23959
    MDEV-23397
    MariaDB 10.6.0
    changelog
    MariaDB 10.6.0
    MariaDB Foundation release announcement
    MDEV-24854
    MDEV-24883

    The most recent release of MariaDB 10.6 is:

    MariaDB 10.6.24 Stable (GA) Download Now

    Alternate download from mariadb.org

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

    wsrep_mode
    wsrep_mode
    wsrep_strict_ddl
    wsrep_mode=STRICT_REPLICATION
    Distributions which Include MariaDB
    Indexes can be ignored
    SELECT ... OFFSET ... FETCH
    SELECT ... SKIP LOCKED
    JSON_TABLE
    subqueries in a FROM clause
    TokuDB
    CassandraSE
    InnoDB's COMPRESSED row format
    read-only by default
    Information Schema SYS_TABLESPACES
    SYS_DATAFILES
    master_host
    sys-schema
    --bind-address=hostname
    GSSAPI plugin
    innodb_adaptive_max_sleep_delay
    innodb_background_scrub_data_check_interval
    innodb_background_scrub_data_compressed
    innodb_background_scrub_data_interval
    innodb_checksum_algorithm
    innochecksum
    max_recursive_iterations
    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

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