> 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.5/11.5.1.md).

# MariaDB 11.5.1 Release Notes

{% hint style="info" %}

<p align="center">The most recent release of MariaDB 11.5 is:</p>

<h4 align="center"><a href="/docs/release-notes/community-server/old-releases/11.5/11.5.2.md"><strong>MariaDB 11.5.2</strong></a> Stable (GA) <a href="https://downloads.mariadb.org/mariadb/11.5.2/" class="button primary">Download Now</a></h4>
{% endhint %}

<a href="https://downloads.mariadb.org/mariadb/11.5.1/" class="button primary">Download</a> <a href="/docs/release-notes/community-server/old-releases/11.5/11.5.1.md" class="button secondary">Release Notes</a> <a href="/docs/release-notes/community-server/changelogs/11.5/mariadb-11-5-1-changelog.md" class="button secondary">Changelog</a> <a href="/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md" class="button secondary">Overview of 11.5</a>

**Release date:** 30 May 2024

{% hint style="danger" %} <mark style="color:red;">**Do not use non-stable (non-GA) releases in production!**</mark>
{% endhint %}

[MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) is a development version of the MariaDB rolling release. It is an evolution of [MariaDB 11.4](/docs/release-notes/community-server/11.4/what-is-mariadb-114.md) with several entirely new features.

[MariaDB 11.5.1](/docs/release-notes/community-server/old-releases/11.5/11.5.1.md) is a [***Release Candidate (RC)***](/docs/release-notes/community-server/about/release-criteria.md) release.

Thanks, and enjoy MariaDB!

## New Features

### Temporary files and tables

* [Limit size of created disk temporary files and tables](/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/limiting-size-of-created-disk-temporary-files-and-tables-overview.md) ([MDEV-9101](https://jira.mariadb.org/browse/MDEV-9101))
* There are two system variables used for controlling this feature:
  * [max\_tmp\_session\_space\_usage](/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_session_space_usage-system-variable.md): Limits the temporary space allowance per user.
  * [max\_tmp\_total\_space\_usage](/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_total_space_usage-system-variable.md): Limits the temporary space allowance for all users.

### Data Types

* The [TIMESTAMP](/docs/server/reference/data-types/date-and-time-data-types/timestamp.md) range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms ([MDEV-32188](https://jira.mariadb.org/browse/MDEV-32188)).

### Optimizer

* [Index condition pushdown](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index-condition-pushdown.md) is now supported for partitioned tables ([MDEV-12404](https://jira.mariadb.org/browse/MDEV-12404))
* ANALYZE FORMAT=JSON now [shows selectivity of pushed index condition](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-interpreting-rows-and-filtered-members.md) ([MDEV-18478](https://jira.mariadb.org/browse/MDEV-18478))

### Protocol

* Permit bulk implementation to return ALL individual results ([MDEV-30366](https://jira.mariadb.org/browse/MDEV-30366))
* Send initial values of system variables in first OK packet ([MDEV-31609](https://jira.mariadb.org/browse/MDEV-31609))

### Observability

* New [USERS table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-users-table.md) in the Information Schema for storing information about users, [password expiry](/docs/server/security/user-account-management/user-password-expiry.md), and the limits set by [max\_password\_errors](/docs/server/server-management/variables-and-modes/server-system-variables.md#max_password_errors) ([MDEV-23729](https://jira.mariadb.org/browse/MDEV-23729), [MDEV-32218](https://jira.mariadb.org/browse/MDEV-32218))
* Add more columns to Information Schema [TABLE\_STATISTICS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-table_statistics-table.md), [CLIENT\_STATISTICS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-client_statistics-table.md) and [USER STATISTICS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-user_statistics-table.md) tables ([MDEV-33151](https://jira.mariadb.org/browse/MDEV-33151))
* Add QUERIES column to Information Schema [INDEX\_STATISTICS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-index_statistics-table.md) table ([MDEV-33152](https://jira.mariadb.org/browse/MDEV-33152))
* Add [FLUSH GLOBAL STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md#flush-status) ([MDEV-33145](https://jira.mariadb.org/browse/MDEV-33145))
* Provide InnoDB async IO statistics ([MDEV-32841](https://jira.mariadb.org/browse/MDEV-32841))
* Extend [Query Response Time plugin](/docs/server/reference/plugins/other-plugins/query-response-time-plugin.md) to be compatible with Percona server ([MDEV-33501](https://jira.mariadb.org/browse/MDEV-33501))

### [Sequences](/docs/server/reference/sql-structure/sequences.md)

* Additional features for Sequences ([MDEV-28152](https://jira.mariadb.org/browse/MDEV-28152))
  * [CREATE SEQUENCE ... AS](/docs/server/reference/sql-structure/sequences/create-sequence.md) permits creating as any [INT](/docs/server/reference/data-types/numeric-data-types/int.md) type (including [BIGINT UNSIGNED](/docs/server/reference/data-types/numeric-data-types/bigint.md)), extending the range
  * [Information Schema Sequences table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-sequences-table.md)
  * Parser accepts larger and smaller values for [MINVALUE](/docs/server/reference/sql-structure/sequences/create-sequence.md#minvalue) and [MAXVALUE](/docs/server/reference/sql-structure/sequences/create-sequence.md#maxvalue)
* [ANALYZE TABLE](/docs/server/reference/sql-statements/table-statements/analyze-table.md) on [sequences](/docs/server/reference/sql-structure/sequences.md) no longer attempts to collect statistics ([MDEV-33938](https://jira.mariadb.org/browse/MDEV-33938))

### Other

* [REPAIR TABLE ... FORCE](/docs/server/reference/sql-statements/table-statements/repair-table.md) ([MDEV-33449](https://jira.mariadb.org/browse/MDEV-33449))
* Introduce the [innodb\_log\_spin\_wait\_delay](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_spin_wait_delay) system variable to address excessive context switching caused by log\_sys.lsn\_lock (observed on write-intensive workloads on NUMA systems) ([MDEV-33515](https://jira.mariadb.org/browse/MDEV-33515))
* Deprecate and ignore the [alter\_algorithm](/docs/server/server-management/variables-and-modes/server-system-variables.md#alter_algorithm) system variable ([MDEV-33655](https://jira.mariadb.org/browse/MDEV-33655))
* Change default Unicode collation to uca1400\_ai\_ci ([MDEV-25829](https://jira.mariadb.org/browse/MDEV-25829))
* Parallel dump of multiple databases via [mariadb-dump](/docs/server/clients-and-utilities/backup-restore-and-import-clients/mariadb-dump.md) with the `--dir` option ([MDEV-33625](https://jira.mariadb.org/browse/MDEV-33625))
* Deprecate [spider\_casual\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md#spider_casual_read) ([MDEV-31789](https://jira.mariadb.org/browse/MDEV-31789))

### Security

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

## Changelog

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

## Contributors

For a full list of contributors to [MariaDB 11.5.1](/docs/release-notes/community-server/old-releases/11.5/11.5.1.md), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-11-4-2-and-mariadb-11-5-1-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" %}