Changes and Improvements in MariaDB 11.8

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-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)

List of All MariaDB 11.8 Releases