> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/11.7.0.md).
# MariaDB 11.7.0 Release Notes
{% hint style="info" %}
The most recent release of MariaDB 11.7 is:
{% endhint %}
Download Release Notes Overview of 11.7
**Release date:** 25 Sep 2024
{% hint style="danger" %} **Do not use non-stable (non-GA) releases in production!**
{% endhint %}
[MariaDB 11.7](/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117.md) is a [rolling release](/docs/release-notes/community-server/about/release-model.md). It is an evolution of [MariaDB 11.6](/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116.md) with several entirely new features.
[MariaDB 11.7.0](/docs/release-notes/community-server/old-releases/11.7/11.7.0.md) is a single preview release. Features are to be considered preview, and none are guaranteed to make it into [MariaDB 11.7](/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117.md).
The preview is available as a container **quay.io/mariadb-foundation/mariadb-devel:11.7-preview**.
Thanks, and enjoy MariaDB!
## Notable Items
### Replication and Binary Log
* When [binlogging](/docs/server/server-management/server-monitoring-logs/binary-log.md) is enabled, committing a large transaction no longer freezes all other transactions until completed ([MDEV-32014](https://jira.mariadb.org/browse/MDEV-32014))
* [binlog\_optimize\_thread\_scheduling](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_optimize_thread_scheduling) has been deprecated ([MDEV-33756](https://jira.mariadb.org/browse/MDEV-33756))
* Async rollback prepared transactions during binlog crash recovery ([MDEV-33853](https://jira.mariadb.org/browse/MDEV-33853))
* New variable, [slave\_abort\_blocking\_timeout](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#slave_abort_blocking_timeout), for aborting long-running queries on a replica ([MDEV-34857](https://jira.mariadb.org/browse/MDEV-34857))
* New variable, [binlog\_large\_commit\_threshold](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_large_commit_threshold), for increasing transaction concurrency for large transactions ([MDEV-32014](https://jira.mariadb.org/browse/MDEV-32014))
### UUID
* New function for generating version 4 UUIDs [UUIDv4](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_v4.md) ([MDEV-11339](https://jira.mariadb.org/browse/MDEV-11339))
* New function for generating version 7 UUIDs [UUIDv7](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_v7.md) ([MDEV-32637](https://jira.mariadb.org/browse/MDEV-32637))
### Optimization
* Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies ([MDEV-25008](https://jira.mariadb.org/browse/MDEV-25008))
* The [Charset Narrowing Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/charset-narrowing-optimization.md) is now on by default ([MDEV-34380](https://jira.mariadb.org/browse/MDEV-34380))
### GIS
New GIS functions. These functions improve compatibility with MySQL 8. **Note that these were not included in** [**MariaDB 11.7**](/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117.md)
* [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\_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))
### System-Versioned Tables
* Allow a [system-versioned table](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md) to be converted from implicit to explicit row\_start/row\_end columns ([MDEV-27293](https://jira.mariadb.org/browse/MDEV-27293))
### Slow Query Log
* New variable, [log\_slow\_always\_query\_time](/docs/server/server-management/server-monitoring-logs/slow-query-log/log_slow_always_query_time-system-variable.md), for specifying that all queries longer than this time are logged to the [slow query log](/docs/server/server-management/server-monitoring-logs/slow-query-log.md), regardless of [log\_slow\_min\_examined\_row\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_min_examined_row_limit) and [log\_slow\_rate\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_rate_limit) ([MDEV-33144](https://jira.mariadb.org/browse/MDEV-33144))
### Stored Routines
* ROW data type for stored function return values ([MDEV-12252](https://jira.mariadb.org/browse/MDEV-12252))
### Derived Tables
* Add optional correlation column list for [derived tables](/docs/server/reference/sql-statements/data-manipulation/selecting-data/subqueries/subqueries-in-a-from-clause-derived-tables.md) ([MDEV-31466](https://jira.mariadb.org/browse/MDEV-31466))
### Vectors
* [MariaDB Vector Search](/docs/server/reference/sql-structure/vectors.md) ([MDEV-34939](https://jira.mariadb.org/browse/MDEV-34939))
### \[SHOW] CREATE SERVER
* Implement [SHOW CREATE SERVER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-server.md) ([MDEV-15696](https://jira.mariadb.org/browse/MDEV-15696))
* Allow arbitrary options in [CREATE SERVER](/docs/server/reference/sql-statements/data-definition/create/create-server.md) ([MDEV-34716](https://jira.mariadb.org/browse/MDEV-34716))
### General
* [SESSION\_USER()](/docs/server/reference/sql-functions/secondary-functions/information-functions/session_user.md), which used to be an alias for [USER()](/docs/server/reference/sql-functions/secondary-functions/information-functions/user.md) now shows the value of [CURRENT\_USER()](/docs/server/reference/sql-functions/secondary-functions/information-functions/current_user.md) when the session was created ([MDEV-30908](https://jira.mariadb.org/browse/MDEV-30908))
* CURRENT\_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) ([MDEV-15751](https://jira.mariadb.org/browse/MDEV-15751))
* A warning has been added when [max\_sort\_length](/docs/server/server-management/variables-and-modes/server-system-variables.md#max_sort_length) is exceeded. ([MDEV-27277](https://jira.mariadb.org/browse/MDEV-27277))
### Deprecated Variables
* [binlog\_optimize\_thread\_scheduling](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_optimize_thread_scheduling) ([MDEV-33756](https://jira.mariadb.org/browse/MDEV-33756))
#### Spider
* The Spider variables [spider\_table\_crd\_thread\_count](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md#spider_table_crd_thread_count) and [spider\_table\_sts\_thread\_count](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md#spider_table_sts_thread_count) have been deprecated ([MDEV-28009](https://jira.mariadb.org/browse/MDEV-28009))
{% 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" %}