MariaDB 11.8.0 Release Notes
Download Release Notes Overview of 11.8
Release date: 18 Dec 2024
Do not use alpha releases in production!
MariaDB 11.8.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.8.
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)
Optimizer
- Expanded Optimizer hints (MDEV-35504)
- Implement subquery optimizer hints (MDEV-34888)
- Implement MAX_EXECUTION_TIME hint (MDEV-34860)
- 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 (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)
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.