All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 10.8 Changes & Improvements

MariaDB 10.8 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Now

MariaDB 10.8 is a previous short-term maintenance series. The first stable release was in May 2022, and it was maintained for one year.

Upgrading

  • See and .

New Features & Improvements

Stored Procedures INOUT Parameters

  • Stored procedures already have support for the parameter qualifiers. Added as well for and (IN only) (). This was a by .

Lag free ALTER TABLE in replication

  • Normally, gets fully executed on the primary first and only then it is and starts executing on replicas. With this feature ALTER TABLE gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. This way the replication lag caused by a heavy ALTER TABLE can be completely eliminated ().

Descending indexes

  • Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (, , , ).

InnoDB redo log improvements

  • autosize ().

  • Improve the for concurrency ().

  • Remove FIL_PAGE_FILE_FLUSH_LSN ().

JSON Histograms

  • Histograms in the statistics tables are more precise and stored as JSON, not binary (, , ).

Spider Storage Engine Improvements

  • This was mostly internal refactoring work. As a result one can now declare connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (, ).

Misc. features

  • Add an optional argument to the function, as well as the function, which uses the Castagnoli polynomial. (). Note: The order of the 2-ary arguments was swapped after the preview release: crc32('MariaDB')=crc32(crc32('Maria'),'DB')

  • Deprecate the variable ().

  • now handles --default-* options in exactly the same way as other MariaDB tools ().

mysqlbinlog GTID support

  • (or mysqlbinlog as it was called back when the task was created) now supports both filtering events by GTID ranges through --start-position and --stop-position, and validating a binary log's ordering of GTIDs through --gtid-strict-mode ().

Windows - Improved i18n support

  • On newer versions of Windows (Windows 10 1903 or later), the mariadb client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage).

Variables

  • For a list of all new variables, see .

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

  • :

  • :

  • :

  • :

List of All Releases

Date
Release
Status
Release Notes
Changelog

UCA are now notably faster (MDEV-27266, MDEV-27265).

CVE-2022-32089: MariaDB 10.8.4

  • CVE-2022-32084: MariaDB 10.8.4

  • CVE-2022-32082: MariaDB 10.8.4

  • CVE-2022-32081: MariaDB 10.8.4

  • CVE-2022-24052: MariaDB 10.8.1

  • CVE-2022-24051: MariaDB 10.8.1

  • CVE-2022-24050: MariaDB 10.8.1

  • CVE-2022-24048: MariaDB 10.8.1

  • CVE-2021-46659: MariaDB 10.8.1

  • CVE-2018-25032: MariaDB 10.8.4

  • Stable (GA)

    19 Sep 2022

    Stable (GA)

    15 Aug 2022

    Stable (GA)

    20 May 2022

    Stable (GA)

    12 Feb 2022

    RC

    09 Feb 2022

    RC

    21 Dec 2021

    Alpha

    10 May 2023

    MariaDB 10.8.8

    Stable (GA)

    Release Notes

    Changelog

    6 Feb 2023

    MariaDB 10.8.7

    Stable (GA)

    Release Notes

    Changelog

    MDEV-10654
    contribution
    ManoharKB
    MDEV-11675
    MDEV-13756
    MDEV-26938
    MDEV-26939
    MDEV-26996
    MDEV-25342
    MDEV-14425
    MDEV-27199
    MDEV-21130
    MDEV-26519
    blog post
    MDEV-5271
    MDEV-27106
    MDEV-27208
    MDEV-23570
    MDEV-26238
    MDEV-4989
    MariaDB 10.8
    CVE-2023-5157
    MariaDB 10.8.4
    CVE-2022-47015
    MariaDB 10.8.8
    CVE-2022-38791
    MariaDB 10.8.4
    CVE-2022-32091
    MariaDB 10.8.4
    MariaDB 10.8

    7 Nov 2022

    MariaDB 10.8.6
    Release Notes
    Changelog
    MariaDB 10.8.5
    Release Notes
    Changelog
    MariaDB 10.8.4
    Release Notes
    Changelog
    MariaDB 10.8.3
    Release Notes
    Changelog
    MariaDB 10.8.2
    Release Notes
    Changelog
    MariaDB 10.8.1
    Release Notes
    Changelog
    MariaDB 10.8.0
    Release Notes

    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.

    Distributions which Include MariaDB
    Upgrading Between Major MariaDB Versions
    Upgrading from MariaDB 10.7 to MariaDB 10.8
    IN, OUT and INOUT
    stored functions
    cursors
    ALTER TABLE
    replicated
    index
    ORDER BY
    innodb_buffer_pool_chunk_size
    redo log
    Spider
    CRC32()
    CRC32C()
    keep_files_on_create
    my_print_defaults
    mariadb-binlog
    System Variables Added in MariaDB 10.8
    Security Vulnerabilities Fixed in MariaDB
    collations

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