All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 11.8.0 Release Notes

MariaDB 11.8.0 is a preview release of MariaDB Community Server 11.8, released on 2024-12-18

Download Release Notes Changelog Overview of 11.8

Release date: 18 Dec 2024

MariaDB 11.8 is a long-term development series of MariaDB. It is an evolution of MariaDB 11.7 with several entirely new features.

MariaDB 11.8.0 is a single preview release. Features are to be considered previews, and none are guaranteed to make it into MariaDB 11.8.

The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.8-preview.

For an overview of MariaDB 11.8, see the What is MariaDB 11.8? page.

Thanks, and enjoy MariaDB!

Notable Items

Vectors

  • New function for calculating either a Euclidean or Cosine distance between two vectors, depending on the underlying index type ()

  • aarch64 SIMD instructions now supported ()

Optimizer

  • Expanded ()

    • Implement ()

    • Implement ()

    • Optimizer hints did not make it into the final release.

InnoDB

  • Fix scalability with multiple threads ()

Importing

  • The --no-autocommit option is now set by default to allow faster data loading by InnoDB, writing only one undo log for the whole operation ()

  • has a new option --innodb-optimize-keys to delay creation of secondary indexes until after data load, resulting in faster loads. By default. ()

GIS

New GIS functions. These functions improve compatibility with MySQL 8.

  • ()

  • ()

  • ()

  • ()

Functions

  • New function. Given a byte count, returns a string consisting of a value and the units in a human-readable format ()

Referential Integrity

  • now also checks for referential integrity ()

Information Schema

  • When querying the , that have the same name as a native function no longer generate a warning ()

Optimizer can now take advantage of queries of the format (MDEV-34911)

  • Add basic optimizer support for - see (MDEV-35616)

  • (MDEV-34159)

  • (MDEV-34160)

  • (MDEV-34277)

  • (MDEV-34276)

  • (MDEV-34278)

  • MDEV-35450
    MDEV-34699
    MDEV-35504
    MDEV-34888
    MDEV-34860
    MariaDB 11.8
    MDEV-35049
    MDEV-32250
    MDEV-34740
    MDEV-34137
    MDEV-34138
    MDEV-34141
    MDEV-34158
    MDEV-31736
    MDEV-34309
    MDEV-35437

    The most recent release of MariaDB 11.8 is:

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

    Distributions which Include MariaDB
    VEC_DISTANCE
    Optimizer hints
    subquery optimizer hints
    MAX_EXECUTION_TIME hint
    innodb-adaptive-hash-index
    mariadb-dump
    mariadb-import
    ST_Validate
    MBRCoveredBy
    ST_Simplify
    ST_GeoHash
    FORMAT_BYTES
    CHECK TABLE ... EXTENDED
    information Schema
    stored functions
    SUBSTR(col, 1, n) = const_str
    virtual columns
    Virtual Column Support in the Optimizer
    ST_LatFromGeoHash
    ST_LongFromGeoHash
    ST_PointFromGeoHash
    ST_IsValid
    ST_Collect

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