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

The most recent release of MariaDB 11.8 is:

MariaDB 11.8.6 Stable (GA) Download Now

_{Alternate download from mariadb.org}

Download Release Notes Changelog Overview of 11.8

Release date: 18 Dec 2024

Do not use non-stable (non-GA) releases in production!

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 VEC_DISTANCE for calculating either a Euclidean or Cosine distance between two vectors, depending on the underlying index type (MDEV-35450)

• aarch64 SIMD instructions now supported (MDEV-34699)

Optimizer

• Expanded Optimizer hints (MDEV-35504)

  • Implement subquery optimizer hints (MDEV-34888)

  • Implement MAX_EXECUTION_TIME hint (MDEV-34860)

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

• Optimizer can now take advantage of queries of the format SUBSTR(col, 1, n) = const_str (MDEV-34911)

• Add basic optimizer support for virtual columns - see Virtual Column Support in the Optimizer (MDEV-35616)

InnoDB

• Fix innodb-adaptive-hash-index scalability with multiple threads (MDEV-35049)

Importing

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

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

GIS

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

• ST_Validate (MDEV-34137)

• MBRCoveredBy (MDEV-34138)

• ST_Simplify (MDEV-34141)

• ST_GeoHash (MDEV-34158)

• ST_LatFromGeoHash (MDEV-34159)

• ST_LongFromGeoHash (MDEV-34160)

• ST_PointFromGeoHash (MDEV-34277)

• ST_IsValid (MDEV-34276)

• ST_Collect (MDEV-34278)

Functions

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

Referential Integrity

• CHECK TABLE ... EXTENDED now also checks for referential integrity (MDEV-34309)

Information Schema

• When querying the information Schema, stored functions that have the same name as a native function no longer generate a warning (MDEV-35437)

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}