MariaDB 11.8.0 Release Notes
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.
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)
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?