Changes and Improvements in MariaDB 11.8
Contents
MariaDB 11.8 is currently in development.
New Features
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-autocommitoption 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)
List of All MariaDB 11.8 Releases
| Date | Release | Status | Release Notes | Changelog |
|---|---|---|---|---|
| 18 Dec 2024 | MariaDB 11.8.0 | Alpha | Release Notes |
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
