# MariaDB 11.5 Changes & Improvements
[MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) is an old [rolling release](/docs/release-notes/community-server/about/release-model.md) and is no longer maintained. Please use a [more recent release](/docs/release-notes/latest-releases.md).
{% hint style="info" %}
The most recent release of MariaDB 11.5 is:
{% endhint %}
## Upgrading
* See [Upgrading Between Major MariaDB Versions](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-on-linux/upgrading-between-major-mariadb-versions.md) and [Upgrading from MariaDB 10.11 to MariaDB 11.0](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-11-to-mariadb-11-0.md).
## 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 for statement should show selectivity of pushed index condition ([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](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md) statistics ([MDEV-32841](https://jira.mariadb.org/browse/MDEV-32841))
* Including a number of [status variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-11-5.md).
* 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))
* 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](/docs/server/reference/data-types/string-data-types/character-sets/supported-character-sets-and-collations.md) to uca1400\_ai\_ci, a modern Unicode collation with proper support for SMP characters (including emoji)([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))
### Removed Features
The following deprecated features have been removed:
* ... COMPRESSED...
* the correct syntax is COMPRESSED... ...
* [wsrep\_load\_data\_splitting](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_load_data_splitting)
* [integer latches in OQGraph](/docs/server/server-usage/storage-engines/oqgraph-storage-engine/oqgraph-overview.md) (and the related [oqgraph\_allow\_create\_integer\_latch](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/oqgraph-system-and-status-variables.md#oqgraph_allow_create_integer_latch) variable).
### Variables
* For a list of all new variables, see [System Variables Added in MariaDB 11.5](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-11-5.md) and [Status Variables Added in MariaDB 11.5](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-11-5.md).
## Security Vulnerabilities Fixed in [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)
For a complete list of security vulnerabilities (CVEs) fixed across all\
versions of MariaDB, see the [Security Vulnerabilities Fixed in MariaDB](/docs/server/security/cve.md)\
page.\
Add listcve macro here - removed for performance reasons
## List of All [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) Releases
| Date | Release | Status | Release Notes | Changelog |
| ----------- | ---------------------------------------------------------------------------------- | ----------- | --------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------- |
| 14 Aug 2024 | [MariaDB 11.5.2](/docs/release-notes/community-server/old-releases/11.5/11.5.2.md) | Stable (GA) | [Release Notes](/docs/release-notes/community-server/old-releases/11.5/11.5.2.md) | [Changelog](/docs/release-notes/community-server/changelogs/11.5/mariadb-11-5-2-changelog.md) |
| 30 May 2024 | [MariaDB 11.5.1](/docs/release-notes/community-server/old-releases/11.5/11.5.1.md) | RC | [Release Notes](/docs/release-notes/community-server/old-releases/11.5/11.5.1.md) | [Changelog](/docs/release-notes/community-server/changelogs/11.5/mariadb-11-5-1-changelog.md) |
| 18 Mar 2024 | [MariaDB 11.5.0](/docs/release-notes/community-server/old-releases/11.5/11.5.0.md) | Alpha | [Release Notes](/docs/release-notes/community-server/old-releases/11.5/11.5.0.md) | |
{% 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: 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:
```
GET https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md?ask=
```
The question should be specific, self-contained, and written in natural language.
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.