The most recent release of MariaDB Community Server 11.8 is: 11.8.8 Stable (GA)
Download Community Server 11.8.8
Alternate download from mariadb.org
{% endhint %} Download Release Notes Changelog Overview of 11.8 **Release date:** 18 Dec 2024 {% hint style="danger" %} **Do not use non-stable (non-GA) releases in production!** {% endhint %} [MariaDB 11.8](/docs/release-notes/community-server/11.8/what-is-mariadb-118.md) is a long-term development series of MariaDB. It is an evolution of [MariaDB 11.7](/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117.md) with several entirely new features. [MariaDB 11.8.0](/docs/release-notes/community-server/11.8/11.8.0.md) is a single preview release. Features are to be considered previews, and none are guaranteed to make it into [MariaDB 11.8](/docs/release-notes/community-server/11.8/what-is-mariadb-118.md). The preview is available as a container **quay.io/mariadb-foundation/mariadb-devel:11.8-preview**. **For an overview of** [**MariaDB 11.8**](/docs/release-notes/community-server/11.8/what-is-mariadb-118.md)**, see the** [**What is MariaDB 11.8?**](/docs/release-notes/community-server/11.8/what-is-mariadb-118.md) **page.** Thanks, and enjoy MariaDB! ## Notable Items ### Vectors * New function [VEC\_DISTANCE](/docs/server/reference/sql-functions/vector-functions/vector-functions-vec_distance.md) for calculating either a Euclidean or Cosine distance between two vectors, depending on the underlying index type ([MDEV-35450](https://jira.mariadb.org/browse/MDEV-35450)) * aarch64 SIMD instructions now supported ([MDEV-34699](https://jira.mariadb.org/browse/MDEV-34699)) ### Optimizer * Expanded [Optimizer hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md#expanded-optimizer-hints) ([MDEV-35504](https://jira.mariadb.org/browse/MDEV-35504)) * Implement [subquery optimizer hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md#subquery-hints) ([MDEV-34888](https://jira.mariadb.org/browse/MDEV-34888)) * Implement [MAX\_EXECUTION\_TIME hint](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md#max_execution_time) ([MDEV-34860](https://jira.mariadb.org/browse/MDEV-34860)) * Optimizer hints did not make it into the final [MariaDB 11.8](/docs/release-notes/community-server/11.8/what-is-mariadb-118.md) release. * Optimizer can now take advantage of queries of the format [SUBSTR(col, 1, n) = const\_str](/docs/server/reference/sql-functions/string-functions/substring.md) ([MDEV-34911](https://jira.mariadb.org/browse/MDEV-34911)) * Add basic optimizer support for [virtual columns](/docs/server/reference/sql-statements/data-definition/create/generated-columns.md) - see [Virtual Column Support in the Optimizer](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/virtual-column-support-in-the-optimizer.md) ([MDEV-35616](https://jira.mariadb.org/browse/MDEV-35616)) ### InnoDB * Fix [innodb-adaptive-hash-index](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_adaptive_hash_index) scalability with multiple threads ([MDEV-35049](https://jira.mariadb.org/browse/MDEV-35049)) ### Importing * The [mariadb-dump](/docs/server/clients-and-utilities/backup-restore-and-import-clients/mariadb-dump.md) `--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](https://jira.mariadb.org/browse/MDEV-32250)) * [mariadb-import](/docs/server/clients-and-utilities/backup-restore-and-import-clients/mariadb-import.md) 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](https://jira.mariadb.org/browse/MDEV-34740)) ### GIS New GIS functions. These functions improve compatibility with MySQL 8. * [ST\_Validate](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_validate.md) ([MDEV-34137](https://jira.mariadb.org/browse/MDEV-34137)) * [MBRCoveredBy](/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrcoveredby.md) ([MDEV-34138](https://jira.mariadb.org/browse/MDEV-34138)) * [ST\_Simplify](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_simplify.md) ([MDEV-34141](https://jira.mariadb.org/browse/MDEV-34141)) * [ST\_GeoHash](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_geohash.md) ([MDEV-34158](https://jira.mariadb.org/browse/MDEV-34158)) * [ST\_LatFromGeoHash](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_latfromgeohash.md) ([MDEV-34159](https://jira.mariadb.org/browse/MDEV-34159)) * [ST\_LongFromGeoHash](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_longfromgeohash.md) ([MDEV-34160](https://jira.mariadb.org/browse/MDEV-34160)) * [ST\_PointFromGeoHash](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_pointfromgeohash.md) ([MDEV-34277](https://jira.mariadb.org/browse/MDEV-34277)) * [ST\_IsValid](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_isvalid.md) ([MDEV-34276](https://jira.mariadb.org/browse/MDEV-34276)) * [ST\_Collect](/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_collect.md) ([MDEV-34278](https://jira.mariadb.org/browse/MDEV-34278)) ### Functions * New [FORMAT\_BYTES](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/miscellaneous-functions-format_bytes.md) function. Given a byte count, returns a string consisting of a value and the units in a human-readable format ([MDEV-31736](https://jira.mariadb.org/browse/MDEV-31736)) ### Referential Integrity * [CHECK TABLE ... EXTENDED](/docs/server/reference/sql-statements/table-statements/check-table.md) now also checks for referential integrity ([MDEV-34309](https://jira.mariadb.org/browse/MDEV-34309)) ### Information Schema * When querying the [information Schema](/docs/server/reference/system-tables/information-schema.md), [stored functions](/docs/server/server-usage/stored-routines/stored-functions.md) that have the same name as a native function no longer generate a warning ([MDEV-35437](https://jira.mariadb.org/browse/MDEV-35437)) {% hint style="info" %} Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) 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](/docs/general-resources/distributions-including-mariadb.md) page. {% endhint %} *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formid="4316" formId="4316" %}