> 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.0/11.0.2.md).

# MariaDB 11.0.2 Release Notes

The most recent release of [MariaDB 11.0](/docs/release-notes/community-server/old-releases/11.0/what-is-mariadb-110.md) is:[**MariaDB 11.0.6**](/docs/release-notes/community-server/old-releases/11.0/11.0.6.md) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/11.0.6/)

[Download 11.0.2](https://downloads.mariadb.org/mariadb/11.0.2/) | [Release Notes](/docs/release-notes/community-server/old-releases/11.0/11.0.2.md) | [Changelog](/docs/release-notes/community-server/changelogs/11.0/mariadb-11-0-2-changelog.md) | [Overview of 11.0](/docs/release-notes/community-server/old-releases/11.0/what-is-mariadb-110.md)

**Release date:** 6 Jun 2023

[MariaDB 11.0](/docs/release-notes/community-server/old-releases/11.0/what-is-mariadb-110.md) is a current short-term stable series of MariaDB and will be maintained until June 2024. It is an evolution of [MariaDB 10.11](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md) with several entirely new features.

[MariaDB 11.0.2](/docs/release-notes/community-server/old-releases/11.0/11.0.2.md) is a [***Stable (GA)***](/docs/release-notes/community-server/about/release-criteria.md) release.

**For an overview of** [**MariaDB 11.0**](/docs/release-notes/community-server/old-releases/11.0/what-is-mariadb-110.md) **see the**[**What is MariaDB 11.0?**](/docs/release-notes/community-server/old-releases/11.0/what-is-mariadb-110.md) **page.**

Thanks, and enjoy MariaDB!

## Notable Items

### Functions

* Given a time in picoseconds, the new function [FORMAT\_PICO\_TIME](/docs/server/reference/sql-functions/date-time-functions/format_pico_time.md) returns a human-readable time value and unit indicator ([MDEV-19629](https://jira.mariadb.org/browse/MDEV-19629))

### InnoDB

* InnoDB does not free UNDO after the fix of [MDEV-30671](https://jira.mariadb.org/browse/MDEV-30671) ([MDEV-31234](https://jira.mariadb.org/browse/MDEV-31234))
* InnoDB hang fixes ([MDEV-31158](https://jira.mariadb.org/browse/MDEV-31158), [MDEV-31343](https://jira.mariadb.org/browse/MDEV-31343), [MDEV-31350](https://jira.mariadb.org/browse/MDEV-31350))
* [Innodb\_buffer\_pool\_read\_requests](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables.md#innodb_buffer_pool_read_requests) is not updated correctly ([MDEV-31309](https://jira.mariadb.org/browse/MDEV-31309))
* InnoDB monitor trx\_rseg\_history\_len was accidentally disabled by default ([MDEV-31308](https://jira.mariadb.org/browse/MDEV-31308))
* Revert "[MDEV-30473](https://jira.mariadb.org/browse/MDEV-30473) : Do not allow GET\_LOCK() / RELEASE\_LOCK() in cluster"

### Optimizer

* [Split Materialized](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/lateral-derived-optimization.md) optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too ([MDEV-26301](https://jira.mariadb.org/browse/MDEV-26301))
* New optimizer\_switch option, [hash\_join\_cardinality](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/hash_join_cardinality-optimizer_switch-flag.md), is added. It is ON by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. ([MDEV-30812](https://jira.mariadb.org/browse/MDEV-30812))
* Crash with condition pushable into derived and containing outer reference ([MDEV-31403](https://jira.mariadb.org/browse/MDEV-31403) [MDEV-31240](https://jira.mariadb.org/browse/MDEV-31240))
* Crash with [EXPLAIN EXTENDED](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain.md) for multi-table update of system table ([MDEV-31224](https://jira.mariadb.org/browse/MDEV-31224))
* [ANALYZE FORMAT=JSON](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-format-json.md) now prints more information about [Block Nested Loop joins](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizer/block-based-join-algorithms.md#block-nested-loop-join): `block-nl-join` element now has `r_loops`, `r_effective_rows` and `r_other_time_ms` fields ([MDEV-30806](https://jira.mariadb.org/browse/MDEV-30806), [MDEV-30830](https://jira.mariadb.org/browse/MDEV-30830), [MDEV-30972](https://jira.mariadb.org/browse/MDEV-30972)).

### Variables

* New status variable: [max\_used\_connections\_time](/docs/server/server-management/variables-and-modes/server-status-variables.md#max_used_connections_time) ([MDEV-30543](https://jira.mariadb.org/browse/MDEV-30543))

### Security

* Fixes for the following [security vulnerabilities](/docs/server/security/cve.md):
  * CVE-\`-\`\`\`

## Changelog

For a complete list of changes made in [MariaDB 11.0.2](/docs/release-notes/community-server/old-releases/11.0/11.0.2.md), with links to detailed information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/11.0/mariadb-11-0-2-changelog.md).

## Contributors

For a full list of contributors to [MariaDB 11.0.2](/docs/release-notes/community-server/old-releases/11.0/11.0.2.md), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-11-1-1-11-0-2-now-available/).

{% 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 %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}