> 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" %}
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/11.7.0.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.